Etl Architect Resume
5.00/5 (Submit Your Rating)
Ny
SUMMARY:
- 11+ years of IT experience
- 4+ years for project management experience delivering projects over 4 million dollars.
- 11+ years of extensive experience in ETL Architecture, Data warehouse, Data Mart design, development, PL SQL Development, Data conversion, Performance tuning.
- 11+ years of Data warehouse experience using Informatica Power Center 6.x/7.x/8.x/9.x
- 11+ Years of experience in implementing projects in Oracle PL/SQL.
- 4 years of experience in Business Objects; creating universe and WebI reports.
- Extensive experience with designing and developing data models in Big Data technology using Greenplum database.
- Extensive experience in UNIX shell scripting.
- Experience in dealing with Web Sphere® MQ series and messages.
- Worked on data conversion tools like POWER EXCHANGE.
- Experience in integration of various data sources like Oracle, JMS, MQ, Flat files into an operational data store.
- Expertise in performance tuning of Informatica mappings and sessions for better performance and meeting SLA.
- Experience in writing test cases for Informatica mappings using test tools like ALM.
- Experience in PL/SQL, Oracle performance tuning, partitioned tables (partitioning strategy), indexes, function based index and optimizing the SQL to improve the performance.
- Responsible for L3 Production Support to ensure proper and timely completion of BAU processes.
- Responsible for month end, quarter end and year end critical batch processing.
- Managed projects with onshore - offshore working model with a team size of 30 members.
- Successfully identified and mitigated risks associated with the projects, both in terms of technical and strategic.
- Excellent Verbal and written communication skills.
- Strong planning, analytical and problem solving skills.
TECHNICAL SKILLS:
RDBMS: Oracle 11g, Vertica, Sybase, Greenplum, SQL Server
Data warehousing: Informatica Power Center 8.x/9.x
BI Tools: Tableau, Business Objects, QlikViewLanguages: UNIX Shell Scripting, SQL, PL/SQL
Scheduling: Autosys, ControlM
Data Modeling Tools: Toad
PROFESSIONAL EXPERIENCE:
Confidential, NY
ETL Architect
Responsibilities:
- Data analysis
- Data modeling
- ETL Design
- Development, deployment and support.
Architect and Project Manager
Responsibilities:
- Management of all phases of the project lifecycle from scope definition to the deployment including testing, training, change management and legal compliance.
- Effectively managed schedule and resource utilization, with reports to senior management on a regular basis.
- Creation of the implementation plan for primary Operational Risk system, with integration from 6 downstream systems, coordination of implementation/validation handoffs between Program, Technology and 10 lines of business.
- Setup a 24x7 War room and Triage room to support Dry Runs/Go-live of the Implementation plan staffed with leads trained in monitoring a ~700 project plan, escalation protocols and project status communications.
- Creation of Dry Run strategies, Go-Live strategies, Hour-by-Hour plan, Environment dependencies/risk, Program critical path dependencies and risk mitigation.
- Spearheading the development of migration solutions by understanding source/target system design, mapping data elements, identifying enrichment/cleanup needs by business via multiple technical methods, ensuring audit and regulatory compliance.
- Leading the Lines of Business/Functions in a Proof of Concept (POC) for selection of an optimal solution for critical business activities required for Go-Live. The POC presented options, which were tested for the criteria of timeliness, resource capacity, usability and technical adaptability.
- Coordinating and managing creation of ~1800 Risk Control Self Assessments for all Lines of Business by defining an overall strategy, holding daily triage calls, leading the Program team in creation of training documents, and other documentation to support the process.
ETL Architect and Project Manager
Responsibilities:
- Requirements Gathering: - I was responsible to get the requirement from the client and create a POC for their requirement. Once the POC was approved, we started with the budgeting and team building exercise.
- Team Building: - I was responsible to build a team comprising of offshore and onshore resources to balance the profitability of the project. I got the right composition of business analyst, testing and build resources in the team with the given budget, which ensured the smooth execution of the project.
- Risk Identification and mitigation: - As part of the project status reporting, one of the key responsibilities was to identify the risks, in scope and out of scope requirements and educate the client about these risks.
- People Management: - In this project my responsibility was not only to meet the client requirement but also to address my teams concerns about their professional aspirations and concerns.
Lead Architect/Project Manager
Responsibilities:
- Worked with Informatica shared services team to acquire the required infrastructure. Configure the server i.e. installing all the required drivers e.g. Oracle driver, Sybase, Vertica, Informatica etc.
- Worked with legacy team to understand the system and design Informatica framework that will include the above-mentioned features.
- Worked with the project stakeholders (Project support team, Business users to design the process monitor dashboard.
- Design other features of the project like restart ability and process orchestration script in Shell script.
Technology Architect
Responsibilities:
- Data Modeling: Data Modeling of the data marts.
- Design of UI scheduler: Design and architecture of scheduler.
- ETL Architect: Getting requirement from end users and design ETL solution for those requirements.
- Data Analyst: Analyzing data from new sources and identify gap between existing system and new data sources.
Technology Architect
Responsibilities:
- Informatica architect and build: Get the requirement from business and develop the required ETL framework.
- Onshore lead: Communicate the requirements to offshore team; work with then in the development, code review and unit testing.
- SIT/UAT support, Production migration and L3 production support.
Oracle PL/SQL architect and build.
Responsibilities:
- Understand the issues faced by the DBA.
- Understand the table compress process, various ways of implementing this and identify the best possible option, so that it doesn’t impact the ETL process.
- Design and develop oracle package, which was supposed to run every day and compress close to 1TB data.
- Testing the package in lower environment and explain this to stake holders (ETL team/DBAs) about the functionalities and its benefits.
Reporting Architect and Project Management.
Responsibilities:
- Understand the business requirement for the operational reporting.
- Analyze the changes needed in the Universe/Report so that the scheduled instances of the reports are not impacted.
- Design and developing the ETL process using Informatica, Oracle PL/SQL is needed for the reporting process.
- Managing reporting team and provide the critical production support to the reporting and ETL processes.
- Performance tuning for the existing reports, which also involved the changing the oracle housekeeping processes
ETL developer
Responsibilities:
- Getting requirements from the business user.
- Analyze source files and identify the deviation from the existing framework.
- Determining the level of efforts for requirements.
- Working with onshore team and develop ETL code as per requirement.
- Code deployment to environment like QA/UAT and Production.
- Production L3 supports.