We provide IT Staff Augmentation Services!

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 Engineer

Confidential, 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 consultant

Confidential, 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 Lead

Confidential, 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

Hire Now