A versatile, enthusiastic and motivated Data / Applications and Business Analyst with a proven track record of success in database and Applications development utilizing Microsoft,Oracle, SQL, SSRS, SSIS, DTS Packages, and ETL tools in a data warehouse environment seeks a challenging position capitalizing on the ability to contribute to the support of diverse information technology initiatives.
Application Analyst @ Children’s strive to enhance the lives of children through excellence in patient care, research and education. It’s through teamwork at every level of our organization and with you, the family, that we are able to achieve a high level of excellence in pediatric care.
• Create complex Structured Oracle 11g Queries using Toad 9 and oracle SQL developer
• Maintain the Organ Transplant Tracking Record Database known as (OTTR) that runs on ORACLE 11g
• Create Unique report using crystal 11 that requires user interaction for various department heads ie Heart, Liver and Kidney dept
• Meeting with department heads and/or super-users on a routine basis to identify and prioritize their needs.
• Train new user to the application From February 2009 to Present (6 years 11 months) Greater Atlanta AreaData Analyst/DTS & ELT writer @ TRX INC tracking and manipulating of corporate travel data gathered from the GDX systems and from different travel sources throughout the world includes fights, cruses, hotels, car rentals etc and then turn it into understandable data for our corporate clients.
• Developed new and worked on tuning existing SQL ETL procedures.
• Data mining using SQL 2000, 2005SSIS and business intelligent tools.
• Collate and distribute daily, weekly and monthly reports automatically through DTS procedures
• Creating DTS Packages to automate data migration imports and export between data marts
• Work closely with the business model to create reports, views SQL and T-SQL programming
• Transport data form one SQL server to another, recreating databases for testing
• Using Microsoft Excel it to create pivot tables creates arithmetic calculation formulas and formatting. From February 2008 to October 2008 (9 months) Greater Atlanta AreaData Analyst/Software support @ MR Default Services, LLC is in the business of reporting to financial institutions about borrowers who filed bankruptcy or any Chapters i.e. 7, 11, 12, 13,
• Developed and tuned existing SQL ETL procedures.
• Document code, procedures, architecture, and schema.
• Data mining using SQL 2000, 2005 and Access.
• Collate and distribute daily, weekly and monthly reports
• Worked closely with the reporting vendor and Data Base Administrators.
• Reviews and evaluates requests to develop or modify reports and/or ETL
• Creating DTS Packages to automate data migration imports and export between data marts From November 2006 to February 2008 (1 year 4 months) Data Analyst @ Data warehouse is a data holding company that houses terabits of information on everyone in America that has a mortgage dating back 30 plus years.
• Data mining process is to extract data using Microsoft SQL ETL Tools
• DTS packages and stored procedures 95% of the time.
• Extract and Load data sets to Microsoft Excel text delimited and CSV Data Migration process between data sources, data warehouses, and data marts
• Creating SQL scripts and stored procedures that would join, update truncate, delete and create tables in the database
• Create reports, SQL and T-SQL programming DTS and excel.
• Many times my team will have to restructure the Data Model inheritance, relationships, aggregation and composition to accommodate the reconstruction of the company’s business models.
• Serve as technical leader and consultant for extraction, transformation, and load (ETL) between data sources, data warehouses, and data marts From March 2006 to October 2006 (8 months) Data / System Analyst @ Gulfstream Technologies is a software company that writes software which track contact management, sales Force Management, Ad order entry and Accounts Receivable for magazine.
• Debugging program (codes) errors in Visual Studios 2003 using ASP.NET 2.0, 1.x/ASP, ADO.NET/ADO, C#, Visual Basic/VBScript, Web Services, Win Forms, Smart Client, XML/XSL
• Designed, developed and implemented object-oriented ASP.NET and Web form Smart Client applications.
• Setup website for new clients, Migrating there Data from various file structures such as CSV, text delimited, Microsoft excel and Microsoft access using Microsoft SQL DTS imports tools.
• Train new clients on how to use the software through Norton pc-Anywhere and CITRIX go-to-meeting.
• Level 3 Customer support technician for database related issues.
• Technical writer for the online user’s manuals (Help document).
• VERITAS (Symantec) backup and restore. From October 2003 to February 2006 (2 years 5 months) Information Systems /Helpdesk @ The Answer group is a Technical support in bound call center that takes support calls for Hp computer, Bellsouth DSL, Gateway, IBM, Hp, Hughes network systems and Best Buy geek squad.
• Level 3 support technician for both HP and Best Buy Geek Squad receiving incoming calls.
• Diagnosing hardware and software (windows operating systems) failures in computer.
• As a Microsoft Certified Professional, Implement and maintain a star/ mixed network using the NT model (File Server, Web server, workstation, and Domain enterprise) configuring policies, user accounts and protocol.
• Diagnosing over 1500 computer running Microsoft Windows 9X, NT, 2000 pro, 2000 server, server 2003 and XP pro in a star topology network. Diagnosing over 1500 computer running Microsoft Windows 9X, NT, 2000 pro, 2000 server and XP pro in a star topology network.
• Document current server hardware and software configuration, Design and support of database backups and recovery procedures.
• Support of logical and physical SQL Server databases From February 1998 to October 2003 (5 years 9 months)
Master's degree, Management Information Systems, General, 3.0 @ University of Phoenix From 2011 to 2014 Bachelors, Information Technology, 3.2 @ American InterContinental University From 2002 to 2004 High School Deploma, Regular/General High School/Secondary Diploma Program, 3.0 @ Miami Norland Senior High From 1993 to 1997 Gregory Thomas is skilled in: Crystal Reports, Epic Ambulatory, Epic Phoenix, Microsoft SQL Server, Oracle SQL Developer, ETL Tools, SSIS, SSRS, IIS, TCP/IP, Active Directory, Routing and Remote Access Service, Stored Procedures, Server Administration, DTS, OTTR Admin 1, Healthcare Information Technology