Lead/senior Etl Consultant Resume
Washington D, C
OBJECTIVE
- In search of a career in ETL Data Warehousing, Data Mining/Analysis, Business Intelligence, and/or Project Management.
SUMMARY
- Talented, self - motivated, organized, efficient, and possess a good eye for detail.
- Specializing in Information Management, wif a broad background in ETL Data Warehousing Development, Data Analysis, Business Intelligence, Disparate Data Querying, Business Analysis, and Compliance Regulation Analysis.
- Business background includes Federal Government, Finance (banking), Health Care, and Real Estate.
- Has worked on a varied set of applications based on a diverse set of software and hardware technologies.
- Worked on project solutions involving data analysis, development, modernization of systems, support, and testing.
- The recipient of numerous awards for project contributions: at Confidential and at the U.S. State Department.
- Extensive experience wif the Migration of Data and in Data Warehousing and ETL Tools: Informatica 9.2, IBM Data Stage 8.1, Oracle 11g (Pl/Sql) and IWAY Data Migrator 8.2.
- Strong experience in Oracle 11g, Oracle Sql-Pl/Sql, Oracle tool sets, and experience in UNIX scripting.
- Experience in Business Objects Universe design and creation, and reports development.
- Proficient in improving Data Quality by conducting Data Analysis, Data Profiling, and Data Cleansing.
- Good knowledge of Dimensional Data Modeling Techniques, E-R modeling, Multi-Dimensional Database Schemas - Star schema and Snowflake schema, and in handling slowly changing dimensions.
- Designed Conceptual, Logical and Physical Data Models wifin MS VISIO and ERWIN.
- Broad experience wif gathering Business Requirements from stakeholders and creating supporting documentation.
- Experience in writing Documents: Business Requirements Document (BRD); Requirements Traceability Matrix (RTM); Software Architectural Design Document (SAD); Data Migration Plan (includes Strategy and Risk); Data Management Plan; Business Case Analysis to be presented to upper management; Data Integration Tools/Cost Benefit Analysis; Source to Target Mapping Document; Coding Standards; and Test Case and Test Plan Documents.
- Adept at working on multiple projects simultaneously and in tailoring solutions to solve client’s business issues.
- Comfortable at being the key primary contact for Stakeholders and at liaising between the client and the technical team.
TECHNICAL SKILLS
Operating Systems: Windows NT/2000/XP, WinFrame, UNIX - Sun Solaris, HPUX, AIX
Databases: Oracle 12c/11g/10g/9i/8i/7.3, MS Access
Application Servers: Apache - JRun/JServ; Tomcat, Oracle 10g/9iAS, WebSphere, WebLogic, JBossOLAP Tools Business Objects XI 3.1 - Web Intelligence and Designer
ETL: IBM Information Server 8.1, IBM DataStage Designer 8.1, Informatica PowerCenter 9.2, exposure to Oracle Data Integrator, IWAY Data Migrator 8.2
Software: Java, JSP, ASP, XML/XSLT, JavaScript, Oracle Sql, Pl/Sql, UNIX Shell Script, ERWIN 8.2, VISIO, Control-M, Subversion, JIRA
PROFESSIONAL EXPERIENCE
Confidential, Washington D.C.
Lead/Senior ETL Consultant
Responsibilities:
- The ETL migration of data provides the client wif KPI markers for budget requirements, which helps reduce the loss of funds and improves the allocation of funds, thus saving money.
- Leverage the ETL tool to design and develop efficient solutions for data management, migration and integration of processes from source to staging to warehouse to a reporting dimensional model architecture.
- Self-taught the ETL tool in record-time and single-handedly lifted the ETL development piece of the project from a low deliverable phase to an extremely productive one.
- Solely design, develop and implement ETL processes under a tight deadline and continue to meet project deadline.
- Streamlined existing development and deployment processes and continue to make improvements.
- Contribute to data analysis and to the content for the STTM.
- Unit test ETL processes, create test cases and test scripts.
- Contribute to the development of task plans, including schedule and effort estimations.
- Mentor co-workers on ETL development, testing and process improvement strategies.
Confidential, Washington D.C.
Senior Data Warehousing Consultant
Responsibilities:
- Provided an ETL data warehousing solution for BSA forms data migration into a consolidated data warehouse.
- Played a key role in analyzing data anomalies and coming up wif creative solutions to resolve issues.
- Analyzed, Cleansed and Processed data using Excel, Oracle 11g/12c Sql, and Datastage 8.1 Designer and Admin tools.
- Wrote the source to target mapping document, which included business transformation rules and data definitions.
- Responsible for extracting, loading, testing and validating client data, and for performing daily data load checks.
- Conducted extensive data testing by writing test plans, test cases, set up test data, and wrote Sql test execution scripts.
- Testing involved the writing of complex Sql queries to generate counts and other aggregate functions.
- Involved in providing and implementing a solution to balance and reconcile data from source to target load.
- Participated in numerous team discussions, client requirement meetings and data modeling meetings.
Confidential, Washington D.C.
Senior Data Warehousing Consultant
Responsibilities:
- Provided Informatica 9.2 data warehouse solution in preparation for data migration into a consolidated data warehouse.
- Developed and designed ETL processes wifin the Informatica PowerCenter client tool set.
- Performed extensive data analysis via Sql, and profiled and cleansed source data in order to improve data quality.
- Wrote the source to target mapping document made up of business transformation rules and detailed data definitions.
- Used Oracle Sql and Pl/Sql to perform data analysis and to write supporting stored functions and procedures.
- Conducted extensive testing of data. Wrote test plans, test cases, set up test data, and wrote test execution scripts in Sql.
- Was responsible for end-to-end movement of data through analysis of data, development, and testing and verification.
- Participated in numerous client requirement meetings and data modeling meetings.
Confidential, NJ
Senior Data Consultant
Responsibilities:
- Supported the Equity, Fixed Income and Revenue Management systems for the Asset and Wealth Management Group.
- Used extensive Oracle Sql and Pl/Sql to implement business processes and perform data analysis.
- Created a source to target transformation rules mapping document wifin Excel, and recommend enhancements in order to resolve data anomalies.
- Tested data via the implementation of test plans, test cases, set up test data, and wrote test execution scripts in Sql.
- Test execution scripts involved the generation of counts and aggregates of data.
- Assisted in the planning and design for implementing a new data warehousing solution wifin the Informatica 9.2 tool.
- Interacted heavily wif business users in order to obtain clarity on the implementation of data governance controls.
- Provided SOx audit related guidance and recommendations to the business and helped bring numerous neglected and out of compliance servers and applications back into Sox compliance wifin 6 months.
Confidential, VA
Senior ETL Consultant / Oracle Consultant/Business Analyst
Responsibilities:
- Supported projects for the Immigration and Customs Enforcement division’s Immigration Tracking system.
- Informatica Data Warehousing Project
- In charge of writing the Data Migration Plan and the Data Management Plan documents for the migration of legacy immigration related data into a modernized data warehouse system.
- Streamlined disparate immigration data into a single data warehouse through extensive data analysis in Sql.
- Provided Informatica 9.2 data warehouse solution in preparation for data migration into an Oracle 11g database
- Developed ETL processes wifin the Informatica 9.2 PowerCenter client: Designer, Workflow Manager, Workflow Monitor and Repository Manager and implemented slowly changing dimension type 2 logic.
- Performed extensive data analysis and analyzed data quality, profiled and cleansed legacy data, wrote the source to target mapping document wif business rules, and wrote test plans, cases and scripts.
- Lead Tracking Project
- Participated in the design and development of scalable solutions and the support of a scalable data infrastructure in order to support a new web-based lead tracking application.
- Created and populated Oracle 11g database tables and relevant objects using DDL and DML functionality, wrote database scripts, and performed deployments.
- Performed Bulk data load and transformations via Oracle 11g Pl/Sql stored procedures and Oracle Data Pump.
- Participated in requirement gathering and wireframe design reviews sessions wif stakeholders in order to provide valuable input, to understand business rules, and to find new solutions for business requirements.
- Liaised between the technical team and the stakeholders to help design technical solutions for business needs.
- Consolidated business requirements wif wireframes in order to analyze data via Sql, and in turn design the relational conceptual, logical and physical data models wifin VISIO and ERWIN.
- Tools: Oracle 11g, SQL, Pl/Sql, SQL*Developer, JBoss, JSP, HTML/CSS, Derby, VISIO, ERWIN 8.2.
Confidential, Washington D.C.
Senior Data Warehousing Consultant
Responsibilities:
- Worked on a Modernized Data Warehouse Project, which supported the U.S. Census Field Representative Survey.
- Aided in streamlining disparate survey sources into a single unified database and metadata set.
- Assisted in providing warehouse solutions in preparation for optimal data migrations.
- Wrote the mapping document wif source to target qualifiers and business transformation rules.
- Involved in Oracle Pl/Sql development and introduced several innovative code structures for data migration.
- Analyzed and tested Business Objects report outputs and performed data gap analysis.
Confidential, VA
DC Specialist Senior Federal Information Management
Responsibilities:
- RISK Analysis Data Warehouse Project
- Worked on Mortgage Backed Securities Data backed by federally insured or guaranteed loans.
- ETL developer for the ETL data conversion and integration project for risk analysis data warehouse in support of data marts to provide financial models for Risk analysis.
- Utilized Informatica PowerCenter 9.0 for ETL design, development and migration of data and incorporated ETL naming standards and Informatica Power Center best practices.
- Developed ETL processes wifin the Designer, Workflow Manager, Workflow Monitor and Repository Manager
- Managed historical data wifin a slowly changing type 2 methodology.
- Involved in mapping and converting the existing SAS centric data migration code into an Informatica supported data migration specification. Identified, assessed and documented data security and conversion risks.
- Participated in design and mapping sessions, wif the business analysts (the risk team) and the data architect, in order to leverage knowledge on business requirements and transformation rules.
- Analyzed legacy data, financial risk data, and Ginnie Mae ratings data against Moody’s and S&P 500.
- Wrote the GNMA Software Architectural Design Document containing detailed mappings from Source to Stage and Stage to the Star Schema dimensional and fact target data mart.
- Award recipient for all round dedication to the Informatica data warehousing project and the team.
- Oracle Data Conversion Project
- Worked on an Oracle Data conversion project to convert data from outdated and disparate Oracle tables into standardized Oracle tables in an Oracle 11g environment.
- Executed and tested Oracle ETL data conversion script using PL/Sql, secured PII data through encryption, and was the primary point of contact for development.
- During each phase of the data deployment lifecycle, wrote data recovery and restoration plans and scripts.
- Reviewed and contributed to the PRD and to the Requirements Traceability Matrix for the front-end application.
- Developed and deployed Sql test cases and a test plan for unit, integration and system testing.
- Award recipient for on-time and accurate project development and completion.
Confidential, VA
Lead ETL Developer / Senior Oracle Developer
Responsibilities:
- Time Keeping Data Warehousing Project
- Involved wif the Electronic Data Integration (EDI) initiative through which my team reduced data management cost by 90 percent, and drastically improved data confidence, data quality and validation of business rules. This reduced inaccurate data and reports, and dramatically sped up investigations by increasing the swiftness at which data was integrated into the DS data warehouse. This process used to be a quarter period behind schedule.
- Implemented an ETL solution in order to integrate agent timekeeping data from an unstable transactional system, developed in PL/Sql, into a robust Oracle 10g enterprise data warehouse system developed in DataStage 8.1.
- Lead ETL developer. Analyzed and profiledthe existing timekeeping data and system, wrote the source to target Technical Specifications mapping document, documented data and conversion risks, and wrote the ETL Jobs Specification and data restoration scripts.
- Contributed ideas, assisted wif the design of the EDI Logical Architecture diagram, the EDI Business Case Analysis to be presented to upper management, the Data integration tools/cost benefit analysis document, the Software Architectural Design (SAD) document, and the EDI PRD documents.
- Award recipient for work appreciation.
- Investigative Management System Project
- Technical Lead. Facilitated business requirements sessions wif stakeholders and business analysts.
- Designed the Business Object Universe and Web Intelligence Reports.
- Received Award recognition for solely creating critical management-level Oracle and Business Objects reports and designing the Business Objects Universe accurately and in record time.
- Responsible for the design, development, testing, support, maintenance, enhancement, and documentation of oracle back-end PL/Sql code and Business Objects reports.