Mds Business Analyst / Data Engineer Resume
San Jose, UsA
SUMMARY
- 10+ years’ experience in Data warehousing space using Informatica 7x/8x/9.x/10.x and ETL Concepts.
- Acquired and developed skills in Requirement Analysis, Design, Coding and Testing of various software applications in Informatica.
- Handled project specific s for the new Joiners in the project.
- Having worked with different clients and various teams has helped me to effectively handle critical situations with ease.
- Ability to learn new technologies with ease, implement and deliver projects efficiently.
- Quick learner and creative problem - solver.
- Solid ETL database programming and database reporting experience and Enterprise Data Warehouse environment
- Must also have significant experience using Informatica and Confidential and a strong knowledge
- Experience with all phases of SDLC and in implementing, staging, operation data stores and dimensional data modeling preferred.
- Experience researching and staying informed of industry technical/ business information security requirements and translating those requirements to the Banks information environment.
- Make recommendations and maintain appropriate working relationships with vendors ensuring access to support, product maintenance and software updates
- Document all areas of the systems, including which clients are accessing which applications, databases and system security design
- Work with the business continuity staff to create and update system disaster avoidance and recovery plans
- Strengths include ability in meeting deadlines and deliverables while achieving excellence and quality of work.
- Used Workflow manager to create and configure workflow and session task to load data; used Informatica workflow monitor to create, monitor workflow in case of process failures; performed testing as per UTC
- Implemented optimization techniques for performance tuning and wrote pre-& post session shell scripts
- Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance
- Involved in extensive performance tuning by determining bottlenecks in sources, mappings and sessions
- Possess strong problem-solving skills developed through variety of projects Expertise in creating Reports using SSRS.
- Experienced in interacting with customer and provide support as needed.
- Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
- 24 x 7 Production Database on Call Support.
TECHNICAL SKILLS
Methodologies: Agile, Waterfall,SDLC
RDBMS: Confidential, Server 2000/2005/2008/2008 R2/2012, Confidential Access,SOQL
ETL Tools: Informatica 8.x,9.x,10.x,Server Integration Services (SSIS) 2005/2008,Metal, Informatica MDM/IDQ,Pantheon
Reporting Tools: Server Reporting Services (SSRS) 2005/2008, Tableau
Database Tools: Server Management Studio(SSMS), Confidential Server, Query Analyzer, Workbench,NOSQL,BQ
Processing Modeling: ERWIN, MS Visio
Business Analysis: Business Requirements, Process Mapping, Root Cause Analysis, Toad
Operating Systems: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003/2008/2008 R2, Windows NT, Windows XP Professional/Standard, Windows Vista Business/Ultimate, Windows 7 Ultimate, Unix
PROFESSIONAL EXPERIENCE
MDS Business Analyst / Data EngineerConfidential, San Jose, USA
Responsibilities:
- Perform analysis of existing code for different source files(xml,FF) using ETL tools like Pantheon
- Understand the mapping logic's and business requirement, integrating external or new data-sets into existing data pipelines.
- Performing system analysis techniques, testing, debugging, design, and storage and understanding application development methodologies to support for different application modules in projects.
- Analyze current state of Corp Master Data pipelines and Creating visualizations and dashboards to help the company interpret and make decisions with the data.
- Track the pipelines transferring from MDS to the domain owners, continuously monitoring and testing the system to ensure optimized performance.
- Presenting the results of a technical analysis to business clients or internal teams and Optimize pipelines by eliminate deprecated logic's and sources.
- Analyzes performance metrics to evaluate user community adoption of tools and processes,
- Develop and deploy corrective action plans, monitor performance.
- Consistently communicates progress, obstacles, and growth opportunities to the stakeholders (development team, product team), and management team.
- Escalations Analyzed database, stored procedure, BQ, NOSQL queries using plx tool for optimizations and recommended enhancements
Environment: Pantheon, NOSQl, BQ, Tableau, Clarinet, UNIX, Data studio,PLX,Qualtrics
Systems Specialist II
Confidential, SFO, USA
Responsibilities:
- Perform analysis of existing code for different source file using ETL tools like Informatica to
- Understand the mapping logics and business requirement
- Performing system analysis techniques, testing, debugging, design, and storage and understanding application development methodologies to support for different application modules in projects.
- Debug the sessions by utilizing the logs of the sessions, Conducts run list reviews, code deployments and post deploy validations following standard software development lifecycle (SDLC)
- Tracking the ticket using the tracker toll using support force with GUS
- Involved in identifying the bugs in SOQL Queries using work Bench Tool to find out the RCA for Confidential data.
- Analyzed database, stored procedure, and SQLqueries for optimizations and recommended enhancements
Environment: Informatica 10.x Confidential, SQL developer, Workbench, Support Force, Tidal, UNIX, Winscp,BO, Wave analytics
Informatica consultantConfidential, San Ramon, USA
Responsibilities:
- Perform analysis of existing code in mainframes or in ETL tools like Informatica to understand the mapping logics
- Developing the mapping documents including System of Record field names, Mapping Rules and W Target field names.
- Perform analysis of the existing data to understand the mapping rules in the current environment
- Discussion of the mapping document with Architects and mapping team to appropriately map ‘The elements to the Banking Data Warehousing (BDW) Model.
- Continuous support through conference calls with mapping team and development team to provide accurate data in new environment.
- Reviewing the BDW mapping document to produce the same data in new environment as in current W.
- Transmission of the System of Record files from UNIX to new environment.
- Coding in new environment as per the mapping documents.
- Preparation of test cases to validate the output data generated using the mapping documents.
- Validation of the test cases using Quality Center tool of Bank.
- Defect tracking through Quality Center and SharePoint portal.
Environment: Informatica 9.x Confidential, SQL developer, Jira
Technical LeadConfidential, Minneapolis, USA
Responsibilities:
- Involved in preparing Technical Requirements Document, High Level Design document and Technical Design document.
- Complete Ownership of the application Project Accounting Data Ware House System.
- Participated in Deployment by adding objects into deployment group and moving the code from test to production.
- Deployment of Sources, targets, mappings, sessions and workflows and participated in deployment, to build efficient ETL components to meet the technical requirements.
- Ensuring smooth running of the application and facilitating improvisation as and when required.
- Monitor the changes carried out in the application as part of maintenance Confidential coordinating and Interacting with the offshore team and resolving the issues.
- Responsible for handling the ticket raised by business user and to provide root cause and fix the issue with in time line.
- Attended weekly status meetings and provide detailed status report to the client.
- Perform unit testing at various levels of the ETL.
- Debug the sessions by utilizing the logs of the sessions.
- Involved in writing Stored Procedures and Functions to handle database automation tasks
- Analyzed database, stored procedure, and TSQL queries for optimizations and recommended enhancements
- Created procedures, functions, sequences, constraints and triggers to maintain data integrity. Applied indexes and partitions to improve performance. Created views for monitoring and reporting.
- Designed source to target mapping strategy and performed ETL to populate databases from existing dispirit data sources (text, Excel, Access etc).
- Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
Environment: Informatica 9.x Confidential, SQL Server/2008R2/2012, CA Automation tool, Clear Quest
Confidential
Technical Lead
Responsibilities:
- Reporting the consolidated daily/weekly status to the PM
- Participated in the development of new systems and upgrades and updates to existing systems, throughout the entire application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment
- Generated the Reports Weekly or Monthly wise as per the Client
- Tickets committed within the SLA period without any disputes.
- Understanding the application data & business requirement.
- Responsible for developing ETL mappings to load data using Informatica Power Center 9.x
- Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and in Confidential all business requirements into all design specifications.
- Define and capture metadata and rules associated with ETL processes
- Adapt ETL processes to accommodate changes in source systems and new business user requirements
- Provide support and maintenance on ETL processes and documentation
- Involve in all Unix System Production Support by trouble shooting customers urgent requests.
- Create and execute validation and production support scripts for custom components. Documents, review, and execute performance tuning scripts.
- Understanding data requirements for test and development
- Successfully improved the performance on our application through index analysis, removing unused indexes and analyzing stored procedures, functions and SQL scripts.
- One of the stored procedure tuning efforts resulted in a 2 minute duration to a few milliseconds
- Maintained database environment security for development, test and pre-production environments
- Involved in Peer review activities for Code & Testing.
- Finding the Root causes of the bugs raised
- Optimized performance by tuning the Informatica ETL code.
- Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
- Used debugger to test the data flow and fix the code.
- Supporting the on call support on Quarter end and production release management deeds
- Respond to trouble shoot tickets assigned to me and fix any database issues promptly.
Environment: Informatica, SAP BO, Confidential, UNIX, Tableau,putty,winscp
Confidential
Technical Lead
Responsibilities:
- Designing, coding, benchmark testing, debugging, and documenting application features and changes
- Reviewing and assessing existing enterprise applications, to support new features, performance improvements, upgrades, and ongoing sustainment
- Proficiency with modern development toolsets including Visual Studio, SQL Server Management Studio, unit testing frameworks, source control, and task tracking such as Team Foundation Server
- Experience designing, implementing, supporting, and analyzing enterprise scale applications that perform extract/transform/load (ETL) operations with external data sources and SQL Server
- Developed and optimized SQL to implement ETL job steps using ETL tools such as Informatica, SSIS, or Metal
- Monitor, diagnose and repair all data loading and processing packages to ensure data integrity of the analysis data and also Designing & implement ETL requirements
- Involved in Peer review activities for Code & Testing, Deployment
- Reporting bugs in the Bug Tracker tool (VSTF) and following up with Business and resolving the issues by conducting meetings.
- Analyzed the performance, tuned and optimized, supported database objects to migrate to production level, executed stored procedures, index sizing
- Configured the necessary table structures in the database to collect and normalize business data
- Resolved known issues and bugs in the Confidential platform interface and back end database
- Programmed user Defined Functions, Views and TSQL Scripting for complex business logic.
- Finding the Root causes of the bugs raised
- Reporting the consolidated daily/weekly status to the PM
- Expertise in generating reports like drill down, drill through reports, parameterized reports, sub reports and different types chart reports in SSRS and tableau dash boards.
- Generated the Reports Weekly or Monthly wise as per the Client Requirements.
- Rendering the Reports in the form of PDF, EXCEL and CSV.
Environment: Informatica, SSRS, SSIS, Metal, Confidential, TSQL, SQL server 2008R2\20012
Confidential
Senior ETL Developer
Responsibilities:
- Involved in various activities like project planning and documentation.
- I have guided the team members on ETL development’s and design part.
- Coordinated with various businesses in DB to understand their requirements.
- Involved in generalized Architecture design of IRT tool.
- Involved in Functional and Technical level design.
- Involved in BRD document preparation.
- Design & implement ETL requirements
- Create and execute validation and production support scripts for custom components. Documents, review, and execute performance tuning scripts.
- Perform constant file manipulation using VI Editor
- Generalized component development using various transformations
- Expertise in generating reports like drill down, drill through reports, parameterized reports, sub reports and different types chart reports in Qlik View dash boards.
- Involved in Peer review activities for Code & Testing, Deployment
- Involved in Implementation
Environment: Informatica, Qlik View, Confidential, unix
Confidential
Senior ETL Developer
Responsibilities:
- Responsible for developing ETL mappings to load data using Informatica Power Center 8.1.1
- Extensively used Informatica Client Tools Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer to develop mappings.
- Used debugger to test the data flow and fix the code.
- Optimized performance by tuning the Informatica ETL code.
- Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
- Perform constant file manipulation using VI Editor and UltraEdit to insure data integrity
- Prepare UNIX applications and identify UNIX issues.
- Extensive experience of Slowly Changing Dimensions
- Good knowledge in UTC, Meta Data, QA Documents.
- Writing the Unix scripting
Environment: Informatica, Confidential, UNIX, WinSCP, putty
Confidential
Soft Engineer
Responsibilities:
- Developed Informatica workflows and sessions associated with the mappings using Workflow Manager
- Designed business rules based on client requirements and performed testing to validate successful implementation
- Supporting the on call support on Quarter end and production release management deeds
- Working on the Unix environment, debugging the issue
Environment: Informatica, Confidential, Unix, winscp, putty