Lead Etl/dwh Solution Architect & Onsite Coordinator Resume
Mounds View, MN
SUMMARY
- Dynamic, result oriented technical having 9 years of experience in IT in Integrations, Data Migrations, ETL Projects, ETL Virtualization Designing and Data Warehousing Implementation projects.
- Strong experience in designing and developing solutions in Integrations, Data Migration Data Warehouse using ETL tools - Informatica PowerCenter 9.6.1/9.0.1/8.6.1/7. x/6.x, OLTP and OLAP.
- Excellent knowledge in data warehouse development life cycle using SDLC and SCRUM/AGILE Methodologies.
- Experties to follow Agile process in application development.
- Coordinate and deliver application development related activities.
- Having Good Experience in PowerExchange to work with SAP R/3 or SAP ECC tables.
- Having Good experience in Informatica Data Quality.
- Strong Logical and Analytical Reasoning Skills, Excellent Communication with good Listening, Presentation and Intrapersonal Skills.
- Strong Team building and mentoring skills and excellent Team leadership capability.
- Very good working experience with OLAP tools like SAP Business Objects and IBM Cognos.
- Very good knowledge in working with Windows and UNIX operating systems.
- Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server, DB2, Teradata and Flat files using Informatica ETL tool.
- Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center..
- Proficient in analyzing and translating business requirements to technical requirements and architecture.
- Very good experience in designing and implementing solutions using several architecture design patterns like OLTP, SOA, OLAP, and ETL.
- Had experience in data modeling using Start Schema Modeling, and Snowflake modeling, Fact and Dimensions tables, physical and logical modeling.
- Executed software projects for Supply Chain, Pharmaceutical, Insurance, Banking, Healthcare and Retail industry.
- Experience in Performance tuning in Informatica, SQL, and PL/SQL etc.
- Strong experience in coding using SQL, SQL*Plus, PL/SQL Procedures/Functions, Triggers and Packages.
- Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.
- Experience in implementing Slowly Changing Dimensions (Type1, Type2 and Type3) mappings.
- Scheduling the sessions to extract, transform and load data into warehouse database depending on the business requirements.
- Expertise in running of Informatica sessions and batches using UNIX Shell Scripts and TWS Job Scheduling tool.
- Experience in using Partitioning features in the sessions to reduce the load time.
- Extensively executed SQL queries on Oracle using Toad and SQL Server tables in order to view successful transaction of data and to validate data.
- Experience in Change Management, Bug Reporting and Defect Tracking.
- Able to understand and work flexibly in high paced environments and adapt quickly to different business organization needs.
- Having very good experience in Integrations & Data Migration Projects using ETL/Informatica and also on CDC (Change Data Capture).
- Experience in 24X7 production support, ETL executions and resolving root causes.
- Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, Test Director, Clear Quest.
- Experience in working with execution of the scheduled jobs by using Tivoli Workload scheduler.
- Having knowledge and good experience in managing application database, database creation, maintenance, controlling, performance, database tuning etc.
- Having experience in non-oracle sources like JD Edward sources.
- Experience in maintaining/running Data Quality checks by running pre/post validation scripts. These scripts are run to verify the data and report to the source/target application team for fix/justification. Also reconciliation on source/target side.
- Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
- Involved in Project Health Reviews.
- Quick adaptability to new technologies.
TECHNICAL SKILLS
Programming Languages: SQL, PL/SQL, Unix Shell Scripting
ETL Tools: Informatica 9.6.1/9.0.1/8.6.1/7. x/6.x, IBM Ascential Profile Stage
Databases: Oracle 11g/10g/9i/8i, IBM DB2, Teradata, MS SQL Server 2005/2008
Operating Systems: Windows 7, Microsoft Windows 95/98/00/NT/XP, UNIX, MS-DOS
Applications: Siebel 8.0 CRM EIM, SAP ECC 7.0 & SAP CRM, SAP LSMW tools, Salesforce.com
Replication Tools: IBM Web sphere Info sphere Replication (IRS)
Database Tools: TOAD, SQL Assistant, SQL Developer
Other Tools: Mercury Quality Center 9.0, HP ALM 11.5, IBM Rational Clear QuestIBM Rational Portfolio Management, GRS (Ticketing tool/Service Request/Incident/Change Management)
Scheduling Tools: IBM Tivoli Scheduling Console
OLAP Tools: SAP Business Objects and IBM Cognos.
PROFESSIONAL EXPERIENCE
Confidential, Mounds View, MN
Lead ETL/DWH Solution Architect & Onsite coordinator
Responsibilities:
- Working on EDW and EAI Integration development projects.
- Played the role of a Program Technical Lead/ETL Architect and was responsible for designing the ETL Strategy & Architecture of the Project.
- Was responsible in managing tasks and deadlines for the ETL teams both Onsite and Offshore.
- Was the point person on the ETL team for other teams such as Reporting, Testing, QA and Project Management for updates on Project Status and issues.
- To get the Functional Requirement Specifications from customer and understand the same.
- Was involved in conducting the review of Informatica Code, Unit Test Cases & Results with the Developers.
- Currently working on NCOA, EPIC BOM, SUNSHINE Release 3, and other major releases like EIO Flash, MDM HMS, Gen 10 Centerpiece, Callidus Integration.
- Worked on major Medtronic projects like Epic, Catapult, GCH Rel4, Model N Conversion, CNI and other integration projects.
- Maintained Quality and Standards set in the project.
- Demonstrated Positive Attitude, Promptness & Pro-Activeness within the project.
- Enforcing project processes and policies
- Helping to formulate estimates and timelines for project activities and setting related goals
- Acting as a technical mentor for developers
- Assisting developers with design work, analysis and requirements gathering
- Participate in peer code review to make sure that coding standard follow
- Provide direction to the developers when needed
- Participating in the weekly Technical Integration Working Group meetings
- Completing a weekly status report for the project manager
- Assisting production support issue
- Worked on identifying the go-forward business objectives for the new Exadata technology platforms.
- Responsible for research and design next generation, internet scale middleware solutions
- Responsible for key architecture decisions
- Design policy creation and enforcement middleware to support dynamic, context aware policies for access control and resource allocation
- Involved in designing and implementing solutions using several architecture design patterns like OLTP, SOA, OLAP and ETL Informatica.
- Work with a team of architects and engineers to develop proof-of-concept components
- Write and maintain architecture and detailed design specifications
- Manage a team of senior engineers and contractors to implement the key components of the product according to specifications
- Perform design and code review
- Work with product manager to ensure the architecture design meets the product requirements
- Work with QA manager to develop test specifications collaborating with application developers and architects to define application middleware requirements and create middleware configurations to meet these needs
- Drove IT management and delivery of parallel POC (Proof of Concept) efforts for future state requirements on Oracle Exadata x2-8, Exadata x2-2 and IBM P7 770 3 node RAC Systems.
- Creating and implementing procedures to bring new services onto the middleware platform and identifying ways to automate repeatable work
- Develop and monitor solutions focused on presentation, logic and data tiers that allow for more junior team members to understand and address service impacting issues in order to proactively remediate issues prior to escalation
- Direct the technology architecture & solution development for data virtualization as the core platform, a self-service based BI search tool.
- Measuring the capacity of the platform to allow for remediation of capacity issues before they impact service levels or performance
- Maintaining and debugging existing applications that interfaces with a database back end
- Preventing system resources and application consumption from negatively affect service availability
- Reporting on incidents and following through a resolution
- Implementing and maintaining a highly available and scalable system infrastructure
- Identifying offending processes in various systems and prevents future occurrences
- Creating technical procedures to prevent unscheduled outages
- Installed & Configuring various Middleware product like Oracle BPM, OBIEE,ODI,Oracle Exadata Database
- Collaborating with problem management engineers to identify and resolve issues to meet customer service level agreements
- I am also responsible for ensuring the coordination of various development efforts that take place in parallel on the project and ensuring that we are proceeding with tasks in the proper order and with the proper priority.
- The development managers on the project will be required to communicate with each other to ensure that tasks are getting assigned to the appropriate development team and that work is not being duplicated anywhere.
- Their responsibilities will also involve interfacing with representatives from the other projects to ensure that required tasks are properly logged and assigned.
- I also responsible for hands on development incase when we don't have enough resource allocated for any of the project which includes:
- Responsible for the design, development, and implementation and ongoing support of large-scale Data Factory and data integration application components using Informatica, Oracle, UNIX/LINUX and AppWorx.
- Adhere to product engineering methodology working collaboratively with product teams (application development, data integration, and quality assurance, and configuration management, product management) to bring information products.
- Perform detailed documentation of design, development, testing and deployment activities necessary to ensure team knowledge sharing.
- Transform business requirements into comprehensive solutions using the appropriate methods, tools and technologies.
- Coordinate and deliver application development related activities with team of 6 data integration team members to achieve success in design, development and deployment activities.
- Participate in application design and estimation activities.
- Perform hands on development and coding of application components using Informatica, Oracle and AppWorx.
- Perform detailed documentation of design, development, testing and deployment activities necessary to ensure team knowledge sharing.
- Mentor and challenge junior software engineers and other team members, while growing the technical, functional and leadership skills.
- Strong team leader with excellent interpersonal and communication skills.
- Environment: Informatica Power Center 7.1/8.0, Oracle 11g (PL/SQL, Procedure, Trigger, Function), SQL Server, Informix, UNIX/Linux Shell Scripting, Perl, AppWorx, Agile (Waterfall) process.
- Identifying Objects, Actions, and Activities — Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or activities.
- Managing the delivery of key projects in Medtronic
- Provided Quick Solution whenever there is an emergency requirement/fix.
- Adhered to quality assurance and quality control activities.
- Imparted Knowledge sharing activities in the team
- Communicating with Supervisors, Peers, or Subordinates — providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
- Always upgraded/ Refreshed with new technologies/skills which will help in the project, also for personal career growth.
- Applied Innovative/Problem Solving techniques in the project.
- Provided extended support to the client at times needed.
- Always Organized/Prioritize the project related tasks, Analysis work/fixing defects/change requests in prioritize manner.
- Provided accurate analysis in a timely fashion for any problem/ issues
- Avoided conflict / unnecessary exchange of mail within the team / client before delivering to the client final review is done to avoid any further defects/issues shown pro-activeness in getting the work to self and offshore so that to keep utilized
- Uploaded the project related documents in RPM and in share repository for each project maintained ZERO escalation from client
- Completed the tasks assigned to self or offshore in an estimated effort and timely manner
- Project mandated training & certification (as communicated from time to time) completed
- Documented all the project/CRD related information in shared repository
- Maintained ZERO peer review comment for the deliverables for self & offshore
- Maintained ZERO review comment from client regarding UTPs delivered for self & offshore
- Built good relationship with client/CRD/Project manager Hs and also geo team
- Always provided timely suggestions for improvising in work
- Managing escalation to be minimal if any.
Confidential, Eagan, MN
Lead ETL Informatica Production Support Analyst
Responsibilities:
- Coordinate onsite and offshore developers to provide business requirement for development and modification.
- Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
- Verified session logs to identify the errors occurred during the ETL execution.
- Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
- Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
- Effectively coordinated with the development team for closing a defect.
- Complete FUT of developments, configurations and modifications.
- Get client’s approval for developments, customizations and modifications
- Defined roadmap to in corporate predictive analytics, data discovery, data virtualization & data visualization into future architecture.
- Provide data Integration related support to client during daily business operations.
- Provide data Integration related support to client during daily business operations.
- Responsible for supporting 16 interfaces whenever any issues or queries raised on any interface
- Coordinating with offshore to manage the ticket volume
- Management of Oracle / Exadata Implementation and consolidation as part of Data Center Database migration.
- Handling complex ticket by working with Architect and providing the optimal solution
- Generating revenue for company by providing the improvement solution and getting the approval from business.
- Fixing ESM application issues like missing accounts, contact information of customers.
- Responsibility for the monthly Toolbox release which will update the AM/DM alignment data.
Environment: Informatica 8.6.0, Oracle 11g, SQL Server 2005, IBM DB2 9.4, Unix 6.4, UC4 8.0 and Tivoli Workload Scheduler.
Confidential, Frazer, PA
Sr. ETL Informatica Lead Architect
Responsibilities:
- As a Sr. ETL Architect responsible for Analysis, design, development, testing and implementation of entire Customer Master data.
- The implementation of a robust and scalable Customer Master solution is a key component of the Global Master Data Management initiative that will link together information about Cephalon’s customers and provide a trusted, comprehensive view of customers to Cephalon in support of the Aggregate State Spend and other activities.
- Understanding the functional specifications and the documents related to the development and also involved in the data analysis.
- Development of the mappings and building Workflows for inbound and outbound process
- Extensively involved in data loading from source system to warehouse by ETL process
- Created Landing and Staging & Bo tables for Customer Master. Configured match & merge rules and trust settings, validation rules, packages.
- Implemented data virtualization services across a range of data sources required by a client's reporting platform.
- Coordinate and communicate tasks with team members.
- Ensure that development is performed as per requirements.
- Responsible for preparing and executing Unit Test Plans and Unit Test Cases.
- Involved in addressing defects and issues identified during Unit Testing, System Testing
- Creating the Mappings, Sessions, workflows and Parameter files
- Tuning the mappings for better performance and Resolving the Bugs issues in Mappings, Sessions & Parameter file.
Environment: Informatica 8.6.1, Oracle 10G (Rapid SQL) and Siperian Hub XU
Confidential
Sr. ETL Informatica Lead Architect
Responsibilities:
- ARMOR project involves database architectural changes and ETL Mappings to provide data to Reporting Team and ARMOR integration team as per the changes happened in the legacy systems from Mainframes to Metavance
- Mainly involved in ETL design & development
- Mainly involved in Preparation of Low level Designs (Mapping Documents) by understanding the system BIDW.
- Responsible in developing the ETL logics and the data maps for loading the tables
- Responsible for migrating from Development to SIT and to Production(deployments)
- Responsible of business requirement and analysis from business users.
- Responsible of Production migration issues
- Involved in mapping reviews
- Responsible of Post Production issues
- Involved in production support after production
- Involved in Defect fixing based on priority basis
- Creating the Mappings, Sessions, workflows and Parameter files
- Tuning the mappings for better performance
- Resolving the Bugs issues in Mappings, Sessions & Parameter file
- Performing unit testing
- Preparing release note documents for different releases
- Involved in monitoring the production jobs
- Mentoring fresher’s in the team on Informatica
- Working on Enhancements for legacy system based on the requirements.
- Involved in Preparation of Source to Target documents by understanding the High level design documents.
Environment: Informatica 8.1.1, Oracle 10G (Rapid SQL), UNIX - AIX, Autosys.
Confidential
Sr. ETL Informatica Lead Architect
Responsibilities:
- Confidential is the largest bank in Singapore as measured by assets, and a leading bank in Hong Kong, with leading positions in corporate, consumer banking, treasury, markets, wealth management, securities brokerage, equity and debt fund raising. With one of the highest credit ratings in south East Asia.
- Mainly involved in the ONSITE and OFFSHORE Communication for requirements gathering from the Business users.
- Mainly involved in ETL design & development
- Mainly involved in Preparation of Low level Designs (Mapping Documents) by understanding the system RMG.
- Responsible in developing the ETL logics and the data maps for loading the tables
- Responsible for migrating from Development to staging and to Production(deployments)
- Responsible of business requirement and analysis from business users.
- Responsible of Production migration issues
- Responsible of Post Production issues
- Involved in Warranty support after production
- Creating the Mappings, Sessions, workflows and Parameter files
- Tuning the mappings for better performance
- Resolving the Bugs issues in Mappings, Sessions & Parameter file
- Performing unit testing
- Preparing release note documents for different releases
- Mentoring fresher’s in the team on Informatica
Environment: Informatica 7.1.3, Teradata V2R5, Unix - AIX, DB2, Tivoli 1.4
Confidential
Sr. ETL Informatica Developer
Responsibilities:
- Confidential Ltd is one of the largest and most comprehensive medical devices company in the world.
- Ortho Biotech (OBI), a subsidiary of Johnson & Johnson is involved in the business of making & selling biopharmaceutical drugs.
- PROCRIT is one such drug that is used in the treatments of anemia, especially in cancer patients undergoing chemotherapy.
- OBI sells drugs to its customer base that includes hospitals & Physical clinics.
- The customers enter into contract with OBI for purchasing drugs.
- Responsible of business requirement and analysis from business users.
- Mainly involved in ETL design & development
- Mainly involved in Preparation of Low level Designs (Mapping Documents) by understanding the system Confidential .
- Tuning the mappings for better performance
- Preparing Low level Design Documents
- Developing the Design Documents
- Detailed ETL Mapping design and development.
- Involved in the development of Source to Target Mappings.
- Developed mappings using Informatica Power Center Designer to load data from various source systems to target database.
- Performing unit testing
Environment: Informatica 7.1.2, Oracle 9i, Unix
Confidential
Sr. ETL Informatica Developer
Responsibilities:
- Confidential TIP/Mod space is in the business of renting, leasing and selling trailers and Modular Space equipment to private fleets and common carriers across North America.
- It is serving the Transportation industry from over 130 locations throughout North America
- Mainly involved in production support
- Process Monitoring
- Involved in maintenance of production system
- Involved in production deployment activities requested from development teams
- Involved in meeting daily SLA for all mart related loads
- Fixing the ITR, Non-ITR and Help Desk issues.
- Working on Enhancements based on the requirements.
- Fixing the Production issues on high priority basis.
- Change requests.
- Involved in reviewing all mappings being promoted to production system
Environment: Informatica 6.2.2, Business Objects 6.5, Oracle 9i
Confidential
Sr. ETL Informatica Developer
Responsibilities:
- Confidential is a world leader in offering medicines to protect health, cure disease and improve well-being.
- Goal of client is to discover, develop and successfully market innovative products to treat patients, ease suffering and to enhance the quality of life.
- They seek to provide a return to shareholders that reflects their performance and to adequately reward those who invest ideas and resources in their company.
- Requirement gathering from client
- Preparing Lowe level Design Documents
- Developing the Design Documents
- Detailed ETL Mapping design and development.
- Involved in the development of Source to Target Mappings.
- Developed mappings using Informatica Power Center Designer to load data from various source systems to target database
Environment: Windows XP, ETL tool (Informatica Power Center 7.1), Oracle 8i