Etl Developer Resume
Atlanta, GeorgiA
SUMMARY:
Technical professional with tangible skills in a broad range of technologies with a focus on ETL and data integration solutions, communication at all organizational levels, as well as the management of one person and group initiatives for both short term and long term multi - year projects
TECHNICAL SKILLS:
- ETL Development
- UNIX
- Team and Project Management
- SQL Server (Non-DBA)
- Informatica
- Oracle (Non-DBA)
- Integration
- Advanced Communication Skills
- Technical/Business/Systems Analysis
- Application Development
PROFESSIONAL EXPERIENCE:
Confidential, Atlanta, Georgia
ETL DeveloperResponsibilities:
- Ran proprietary processes built entirely in UNIX for ETL functions
- UNIX scripts
Confidential
Senior Consultant, Atlanta, Georgia
Responsibilities:
- As a Lead Developer, worked with four offshore developers in the development of the data ETL/integration work involving ingesting file feeds from Confidential for different metrics required for Service Assurance (SA) teams
- Facilitated offshore meetings to assure development was occurring on schedule and with the appropriate standards in place
- Developed Informatica objects including but, not limited to, mappings, mapplets, sessions, worklets, workflows, and UNIX pieces
- Tuned Informatica for improved performance
- Developed UNIX scripts as a pre-Informatica solution to process hundreds of files thereby taking the load of the Informatica servers
- Developed Shell Scripts that generated the parameter files and in turn started Informatica workflows
- Developed ETL detail design documents based on the Functional Requirements and Lead detailed design reviews and strategy sessions with the Client
- In a Data Analyst role, matched complex requirements to reports in OBIEE that would be affected by upcoming changes switch changes
- Analyzed the functionality of new product offerings and the effect on databases and reporting
Confidential
ETL Developer, Atlanta, Georgia
Responsibilities:
- Use of a variety of ETL frameworks and tools, mainly involving Informatica, in the creation of complex, robust, and scalable integration solutions
- Complex transformations for data manipulation and cleansing using varying degrees of logic
- Aginity Workbench for Netezza for manipulating Informatica data
- UNIX and shell scripting
- SQL Server/Oracle
- Pre/Post SQL and Post Session Commands calling Stored Procedures reducing the need for processing heavy data loads on the Informatica server
- Different database models and processing techniques depending on integration solution usage and scheduling
- Analysis, Design, and Documentation
Confidential
Senior Systems Analyst, Atlanta, Georgia
Responsibilities:
- Internal application and software
- Production of databases with complex user interfaces for a variety of applications including both financial and operational reporting, data transformation, and file generation
- Creation of detailed technical documentation covering all projects needs
- Development of the processes for data migration from four proprietary systems into SQL Server
- Design of a database for processing daily, weekly, and monthly ETL processes for financial reporting
- Created and managed weekly payroll processes for companywide consultants using XML based reporting
Confidential
IS Manager, Atlanta, Georgia
Responsibilities:
- Managed a 4-person department focusing on complex reporting from both SQL Server and Microsoft Access databases
Confidential
Manager and Lead Data Migration Engineer, Atlanta, Georgia
Responsibilities:
- Managed a 4-person department while performing full migrations
- Communicated daily via meetings, calls, and emails with clients gathering information regarding their business processes/needs, managing expectations, and defining the path to reach the common goals
- Designed complex migration paths into two different applications
- Analyzed client proprietary systems necessitating the creation of custom scripts
Confidential
Developer & Quality Assurance Engineer, Boston, Massachusetts
Responsibilities:
- Worked towards the delivery of a child welfare/youth corrections case management system
- Developed forms for use in quality assurance problem tracking
- Tested and documented problems for a developing software project through ad-hoc testing and script writing
