We provide IT Staff Augmentation Services!

Senior Associate Resume

Nyc, NY

SUMMARY:

  • Over 9 years of professional and working as Senior Associate with Confidential
  • ETL developer and Data Analyst in Banking, finance and Healthcare domain with leading investment banks.
  • Proficient in requirements gathering and analysis, validation, Business Requirements Specifications
  • Expertise in using PL/SQL in writing complex queries for analysis
  • Expertise in using Oracle 10g/11g enterprise edition
  • Extensive experience in Datawarehousing and Powercenter Informatica as a developer.
  • Leading the ETL project for Claims attribution in Healthcare, in Teradata and Salesforce database and Informatica
  • Lead the datawarehousing project in Pentaho over Oracle Database
  • Expert in analysis in complex PL/SQL, procedures and functions
  • Involved in processing and the analysis of the Peoplesoft data and integrating into the database system
  • Proficient in query optimization and effective database management of different Databases (Oracle, Sybase)
  • Involved in Client Reporting systems Using Informatica mappings
  • Valuable experience on perl and shell scripting.
  • Worked as part of Change Management Team to create, interpret and implement changes to financial applications/systems.
  • Good experience of industry standard SDLC methodologies.
  • Progressively elaborate and document user requirements into user stories
  • Worked on Data Mapping, load process, and extract process.
  • Valuable experience with Data Modeling Tools (MS Visio), Databases (SQL Server, Oracle), Documentation Tools (MS Office, MS Share point)
  • Experience with Offshore - Onshore coordination.
  • Worked with team to explain the detailed business requirements and the functional specifications and clarifying ambiguities.
  • Assist the testing teams in identifying the test scenarios, identifying the defects.
  • Worked with the test team to do backend Testing.
  • Assisted UAT team, following up on user change requests, assist in user level documentation, manuals.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Unix, VI editor

Programming Languages and Scripting: Oracle PL/SQL, Perl, Shell, JIL

Database: Oracle 11g, Oracle9i, Oracle10g, Sybase 12.5, Teradata 13, Salesforce

Extraction Transformation and Loading Tool: Informatica, Pentaho

Configuration Tools: VSS, Harvest, ChangeMan, CVS

Defect Tracking Tool: Mercury Quality Center

Scheduling Tool: Autosys 11.3

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Senior Associate

Responsibilities:

  • ETL Lead in Patient 360 project
  • Works coordinating with Business Analysts to do detailed business analysis and made Pentaho jobs and the calculation models.
  • Involved in the design of the project from the scratch
  • Working on Pentaho (ETL tool) in workflow designer to create jobs for the feed cut and population of the dimension tables in Oracle database and the target salesforce Database
  • Documented detailed Business Requirements (BRD) for the enhancements required by the business in the existing modules and the new features required.
  • Owner of HLD (High Level Design) and LLD (Low Level Design) documents.
  • Coordinating sessions between the developers and offshore team to implement the requirements.
  • Facilitating UAT to guarantee accurate and required functionality.

Environment: Sql developer, Pentaho, SQL, Oracle 11G, Salesforce

Confidential, Newark, NJ

Senior Associate

Responsibilities:

  • Worked with Business Analysts to do detailed business analysis and integration of different data sources into target database.
  • Worked on Pentaho (ETL tool), applied transformations, on the data being populated from different data sources
  • Documented detailed Business Requirements (BRD) for the enhancements required by the business in the existing modules and the new features required.
  • Owner of HLD (High Level Design) and LLD (Low Level Design) documents.
  • Coordinating sessions between the developers and offshore team to implement the requirements.
  • Facilitating UAT to guarantee accurate and required functionality.

Environment: Toad, Pentaho, SQL, Oracle 11G,Teradata, perl/shell script

Confidential, Denver, CO

Informatica Lead

Responsibilities:

  • Acted as lead in maintenance and enhancements in IMT project
  • Acted as an Informatica developer in IDW project
  • Worked with Business Analysts to do detailed business analysis and made workflows and the calculation models.
  • Involved in the Impact Analysis of the workflows, tables and views as per the request created by the users in remedy.
  • Experience Optimizing Informatica Mappings and Sessions to improve the performance tuning of the queries
  • Worked on Informatica (ETL tool) in workflow designer to create mappings for the feed cut and population of the dimension tables in Oracle database.
  • Documented detailed Business Requirements (BRD) for the enhancements required by the business in the existing modules and the new features required.
  • Worked on Data Mapping for the external feed.
  • Coordinated sessions between the developers and offshore team to implement the requirements.
  • Interacted with the offshore team regarding FRD as needed.
  • Created SQL queries for technical analysis of data.
  • Facilitated UAT to guarantee accurate and required functionality.

Environment: Toad, Informatica, SQL, Oracle 11G,Teradata, perl/shell script

Confidential, New York, NY

Informatica Lead

Responsibilities:

  • Analyzed the current system and the modules it offers to understand the high-level process.
  • Acted as a Informatica developer in P1 DST project and in RRG P1 project
  • Worked with Business Analysts to do detailed business analysis and make workflows on the various risk factors (common factor risk, specific risk, total risk, value at risk) and the calculation models.
  • Created the perl /shell scripts and the jobs in autosys for the BAU functioning of the project.
  • Worked on Sybase to maintain the performance database.
  • Documented detailed Business Requirements (BRD) for the enhancements required by the business in the existing modules and the new features required.
  • Worked on Data Mapping for the external feed.
  • Collaborated with PMO in developing Project Plans, doing business analysis, preparing Business Requirements Document, Functional Specification Document and Testing during SDLC/RUP.
  • Conducted sessions with the developers to discuss the feasibility of various requirements.
  • Interacted with the offshore team regarding FRD as needed.
  • Created SQL queries for technical analysis of data.
  • Worked with TOAD to do querying.
  • Facilitated UAT to guarantee accurate and required functionality.
  • Assisted in preparing user manual and providing demos to end-users.

Environment: Toad, Informatica, Oracle 11G, perl/shell script, Sybase, Anova

Confidential, NY

Informatica Developer

Responsibilities:

  • Analyzing data to check integrity.
  • Progressively elaborate and document user requirements into user stories and use cases
  • Conducted Vision workshops with Informatica vendors to implement the extraction part in the database through mappings.
  • Prepared Business requirement document (BRD) by working with Implementation Managers, Traders, Operations and IT.
  • Worked on Data Mapping, load process, transformation and extract process.
  • Frequent interaction with development team and business users to manage expectations.
  • Explaining to the development team about the process flow and explained business logic using excel by examples wherever possible.
  • Helping with Testing Scenarios
  • Prepared the Requirements Catalogue based on discussions with the client and was involved in drafting of High Level Design Document and Detailed Design Document, which outlined the business flows, template designs, workflow designs, deployment strategies and test cases.
  • Handled the development module for Confidential (Data Access Profiler), Subscription Module team and was involved in designing, coding and testing of perl/shell and sql scripts using Oracle and UNIX.
  • Prepared the deployment environment, analyzed the targets and formats, customized the server configuration files and executed the deployment from development server to production server.
  • Documentation of BRD and FRD, maintained/tracked the changes via version control tool ‘visual source safe’.

Environment: Toad, Informatica, Oracle 11G, Perl/shell script, VSS

Confidential

Informatica developer

Responsibilities:

  • Requirement Analysis followed by preparation of functional specifications and proposals.
  • Conduct steering meeting with business stakeholder for work prioritization.
  • Prepare/Maintain project plan and conduct status meetings and communicate with the management & stakeholders.
  • Actively involved in the development team and the global user community
  • Establish quality standards for various operational areas, ensuring a high-quality customer experience. Map client’s requirements, assess feedback, and evaluate areas of improvements.
  • Worked on Oracle database to successfully implement the extraction and loading.
  • Analyzed the incidents and proposed the solution and calculated the feasibility of that solution.
  • Did detailed analysis of requirement to get the feasible approach to develop different types of Mappings using Informatica Tool.
  • Fixed the bugs using Debugging Tool in the Designer, Identified and Observed the Objects like Mapplets and Reusable Transformations using Informatica, Workflow Manager to create different types of tasks like session, email, command, worklets etc. Monitored the Workflows, worklets tasks using Workflow Monitor Tool.
  • Observed and Curtailed the Performance bottlenecks at different stages like Sources, Targets, and Mappings & Sessions.
  • Prepared the ETL Analysis doc, ETL doc, and UTP doc.

Environment: Toad, Informatica, Oracle 10G, perl/shell script

Confidential

PL/SQL developer

Responsibilities:

  • Requirement Analysis followed by preparation of functional specifications and proposals.
  • Conduct steering meeting with business stakeholder for work prioritization.
  • Prepare/Maintain project plan and conduct status meetings and communicate with the management & stakeholders.
  • Actively involved in the development team and the global user community
  • Establish quality standards for various operational areas, ensuring a high-quality customer experience. Map client’s requirements, assess feedback, and evaluate areas of improvements.
  • Worked with M204 and Oracle database to successfully implement the extraction and loading.
  • Prepared the Requirements Catalogue based on discussions with the client. She was involved in drafting of High Level Design Document and Detailed Design Document, which outlined the business flows, template designs, workflow designs, deployment strategies and test cases.
  • Handling various types of enhancement requests in the Confidential Enhancements) team and was involved in designing, coding and testing of shell and sql scripts using Oracle and UNIX.

Environment: Toad, Informatica, Oracle 10G, perl/shell script, M204

Hire Now