We provide IT Staff Augmentation Services!

Technical Lead / Senior Developer Resume

San Ramon, CA

PROFILE SUMMARY:

12+ years of IT experience, primarily in the field of Data Warehousing for System Analysis, Designing, Development, Administration and Support of various systems for Business Intelligence. As part of my career, I was involving in Requirement & Data Analysis, Designing, Quality Reviews, Migration, System Integration & Functional Testing along with Production Support. I also have good experience in the Agile Methodology and effective communication and mentoring skills. Having very good exposure roles as a Data Analyst, ETL Developer, QA Analyst, ETL Architect, Technical & Project Lead and Informatica Admin.

KEY STRENGTHS:

  • Good knowledge of Data warehousing Concepts
  • 10+ years of solid experience in Data warehousing/ Integration using different ETL Tools, mainly Informatica.
  • Experience in performing Data profiling, Data governance identification and resolution of data quality issues.
  • Strong experience in Data analysis, Data integration in cross functional environment.
  • Experience in working with Oracle, Teradata, DB2, SQL Server, UNIX, DPA
  • Involved in Requirement analysis, Data Analysis, Data modeling, Performance tuning.
  • Good knowledge in Software Development Life Cycle Process and Agile Methodology
  • In - depth experience in different BI lifecycle processes like Data Integration/ETL process, EDW, Data Marts, Master Data Management and Metadata Management.
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling.
  • Worked in multiple large end-to-end data warehousing implementations in different domains like Banking, Finance, Health Care, Retail etc.
  • Worked on project proposals, project estimates and providing line of estimates.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.5/9.1/8.6/7.5 & Decision Point Analyzer(DPA)

Database: Oracle 11g/10g/9i, Teradata, SQL Server,DB2

Development Tools: SQL Developer, Toad, Teradata SQL Assistant

Languages: UNIX,SQL, PL/SQL, VB, C#

Reporting Tools: Business Objects, Hyperion

Other Tools & Technologies: Quality Center, JIRA, Version One, Tidal, AutoSys

WORK EXPERIENCES:

Confidential, San Ramon, CA

Technical Lead / Senior Developer

Responsibilities:

  • Performed data profiling in the source systems that are required for FMS System
  • Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
  • Worked with project team representatives to ensure physical data models were developed in line with corporate standards and guidelines.
  • Involved in defining the source to target data mappings, business rules and data definitions.
  • Responsible for defining the key identifiers for each mapping/interface.
  • Responsible for defining the functional requirement documents for each source to target interface.
  • Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
  • High level ETL design, Review the low level design, Unit Testing Strategy etc.
  • Design and Develop complex mappings involved
  • Involved in Code migration in different environments.
  • Coordinating and Supporting SIT and UAT activities with different teams.

Confidential, Pleasanton, CA

Technical Lead & Production support

Responsibilities:

  • Review project status and project metrics on a weekly/monthly basis.
  • Review and revise project plan to meet changing requirements in the project
  • Submit or update monthly project plan or operational reports to customer on the progress of the project to meet the timeline or highlight any kind of risk
  • Active Participation with Business team during Requirement gathering phase
  • Responsible for ETL processes and tools as well as database loading and manipulation
  • Interacting with client to understand the requirements and distributing the work to offshore team.
  • Participate in weekly Tech leads meetings and the actively involved in all activities including deployment and initial code support.
  • High level ETL design, Review the low level design, Unit Testing Strategy etc.
  • Create Technical design document.
  • Develop ETL complex mappings like institutional & professional claim header and detail mappings.
  • Prepare and test Unix scripts for HCG & ICS grouping
  • Supporting SIT and UAT activities, also worked in Production support job.
  • Review and revise the operational aspects of the account with the reporting managers on a weekly basis
  • Ensure compliance with project standards and quality assurance procedures.

Confidential, Walnut Creek, CA

Module Lead / Informatica Admin

Responsibilities:

  • Plan daily/weekly activities for the team and track the progress on each deliverables.
  • Prepare project plan and progress report and share with onsite coordinator.
  • Review and revise project plan to meet changing requirements in the project
  • Design business requirements to technical requirements and get the sign off from client managers.
  • Ensure compliance with project standards and quality assurance procedures.
  • Coordinating with Onsite PM and understanding the requirements and distributing the work to offshore team
  • Designing the ETL Architecture and load strategy
  • Review the ETL Design, Unit Testing Strategy etc.
  • Develop ETL mappings and UNIX scripts.
  • Prepare Unit test cases and capture the test results.
  • Supporting the SIT and UAT activities
  • Informatica Admin related activities

Confidential, San Francisco, CA

Senior Developer / ETL Architect

Responsibilities:

  • Plan daily/weekly activities for the team and track the progress on each deliverables.
  • Understanding the client requirements and prepare understanding and design documents
  • Reviewing the understanding and design document with DA and finalize the design.
  • Coding and Unit testing.
  • Interact with onsite counterpart and plan activities
  • Manage and allocate tasks for the team members
  • Document and upload the various artifacts required for process related audits.
  • Ensure effective and clear communication of Client team's requirements, expectations and feedback to the team at onshore and offshore.
  • Periodic reviews of all the project/account level metrics with onshore and offshore project leads.
  • Daily or weekly calls with the team and offshore management leads to keep the project timeline or upcoming project release activities to plan.
  • Keep up-to-date both onshore & offshore leads on the client decisions and if any project plan changes.

Confidential, Alameda, CA

Offshore Technical Lead

Responsibilities:

  • Ensure effective and clear communication of Client team's requirements, expectations and feedback to the team at onshore and offshore.
  • Understanding the changes and design documents and developing the code based on it.
  • Gathering requirements and functional knowledge from Onsite and updating the work status.
  • Developing ETL objects, Database objects.
  • Maintaining design documents, Business Requirement documents and uploading to Cisco's Live link for easy sharing and maintenance
  • Adherence to Quality procedures as per client standards
  • Prepare the Test cases for the Unit testing.
  • Conducting impact analysis for the changes suggested by the clients
  • Coding based on the Specifications provided by the Client and according to the checklist.
  • Testing application (includes the Unit Testing and Pre Integration Testing).
  • Reconciling the data and identifying any data-issues including Known Issues and fixing it.
  • Write or assist in the writing of new project proposals and statement of works and formally present the same to client.

Confidential

Senior Developer

Responsibilities:

  • Analyzing the existing RIC process and Reviewing the designs
  • Preparation of Logical and Technical docs.
  • ETL,PL/SQL Coding and Unit testing
  • System Integration Testing
  • Performance tuning
  • Interaction with onsite Testing team on project activities iQA Support
  • ETL code migration

Confidential

QA Analyst

Responsibilities:

  • Preparing Detailed Test Plan.
  • Assigning activities to the team members
  • Understanding the clients’ requirements, project functionalities and writing test cases.
  • Interaction with onsite Testing team on project activities
  • Responsible for reviewing, executing test cases and logging defects.
  • Responsible for Functional, Integration and System testing.
  • Defect reporting & tracking and Status Reporting.
  • Preparation of status reports.
  • Maintaining test documents

Confidential

Data Analyst

Responsibilities:

  • Requirement Analysis
  • Data analysis
  • Impact analysis
  • Technical design
  • Preparing Functional Design document
  • Discussing the Design with Onsite and Offshore Developers
  • Design and code design reviews
  • Functional testing
  • Functional defect reviews.

Confidential

ETL Developer

Responsibilities:

  • Requirement Analysis
  • ETL Designing
  • Preparation of Logical and Technical docs.
  • ETL,PL/SQL Coding and Unit testing
  • Writing the test cases
  • System Integration Testing
  • Performed Unit testing and Functional Testing.
  • QA Support
  • ETL code migration
  • Prod Warranty support for 3 months

Confidential

ETL Developer

Responsibilities:

  • Requirement Analysis
  • ETL Designing
  • Preparation of Logical and Technical docs.
  • ETL,PL/SQL Coding and Unit testing
  • Designing and optimizing the Mapping to load the data in slowly changing dimension.
  • Writing the test cases
  • System Integration Testing
  • Performed Unit testing and Functional Testing.
  • QA Support
  • Supporting the SIT and UAT activities
  • ETL code migration.

Hire Now