EXPERIENCE SUMMARY

• Extensive experience with RDBMS .
• Strong Technical Business Analysis skills including extracting initial requirements through to gap analysis and delivering detailed functional requirements.
• Extensive knowledge in Data Modelling (relational and dimensional database).
• 5 Years’ experience as Database Architect-designing very complex Enterprise Data Warehouse.
• Experience in Full Software Development Life Cycle (SDLC) both Agile and Waterfall.
• Partner with Architecture on technology direction, and the related evaluations, POCs and decisions.
• Coordinate with QA on proper strategies to ensure quality. Collaborate with QA to develop performance and load test scenarios.
• Experience in Managing and Mentoring team of 10+ people which includes work assignment, code review, governance and goal setting.
• Coordinate with release management to drive automation of all deployment artifacts.
• Experience in Data Profiling, metadata driven Data Integrity test and Quality Analysis on data received from multiple sources systems (format: xml,csv etc).
• An extensive knowledge on Database and Analytics with expertise in programming.
• Experience in creating ad-hoc reports using SQL query and BI reporting tool as per client requirement.
• Experience working with JIRA and Confluence.
• Excellent communication and interpersonal skills, and be able to effectively tailor communications to a diverse range of business and technical stakeholder groups.

KNOWLEDGE/SKILLS

Database: Oracle PL/SQL,MS SQL Server, Exadata, My SQL.

ETL: Oracle Warehouse Builder, Ab - Initio, Talend Integration Suit, Big Data, MS SSIS, SQL Developer, TOAD.

Business Intelligence: Oracle Business Intelligence Enterprise Edition, Tableau.

Others: Microsoft Office Products, UNIX Scripting, Control-M Scheduling IBM Tivoli Scheduler, Subversion (Version Control System),JIRA, Confluence.

PROFESSIONAL EXPERIENCE

Database Architect and Business Analyst 

Responsibilities :

• Database architecture for payment calculation model which is responsible for making over $10MM payments each month.
• Data analysis and implementation of data quality check for a big data warehouse which provides monthly payment report and management briefing to CMS.
• Design and Build enrolment and payment system which is single source of truth for CMS. (using Oracle PL/SQL).
• Build highly secured metadata driven system which ensures data integrity and security.
• Leading a team of 13 people (5 PL/SQL developers, 2 Business Analyst, 1 DBA , 2 UNIX scripting member and 3 Testers.)
• Status reporting of projects from initiation to implementation.
• Responsible for managing adhoc reports, change requests, risks and issues
• Requirement Gathering and creating sample reports for client.
• Creating Test strategy and code review.
• Test planning, Test case/script preparation, Unit Testing, Integration Testing, Test execution.
• Integration with various Teams.

Technical Architect and Business Analyst 

Responsibilities :

• Build Big data system which could be efficiently managed, accessed, updated, and shared with scientists and business users across the enterprise.
• Gathering requirements, Test case creation, Test case execution, Creating Defects, Regression Testing and Performance Testing.
• Schema design for creating a common source data landing system.
• Developing of working Prototypes using big data methodology.
• Worked in Talend Integration Suit and SSIS as a part of ETL process.
• Build signal hug using Data rush query language and Hadoop file system.
• Performance Tuning.
• Integration Testing.

Senior Lead Software Developer 

Responsibilities :

• Requirement analysis and part of solution design team .
• Developing Prototypes for multiple clients to show how SIP works.
• Data Extraction/Transformation and Load using SSIS and Talend integration Suit.
• Rule Engine creation for common spend intelligence perform using data base Queries (Ms SQL server/My SQL).
• Test planning, Test case/script preparation, Unit Testing, Integration Testing, Test execution.

Lead developer and Business Analyst 

• Creating data flow diagram for a module which involves 5 Facts and 10 Dimensions.
• Managing and Building a data mart using Oracle PL/SQL and Oracle warehouse builder to build a rule engine with complex calculations.
• Creating Data mart using Ab Initio.
• Test case creation, Test case execution, Creating Defects, Regression Testing and Performance Testing.
• Analysis, Design and Implementation of Business applications using the Oracle Relational Database Management System (RDBMS).
• Generate ad-hoc reports using OBI Answers.
• Test planning, Test case/script preparation, Unit Testing, Integration Testing, Test execution.
• Coordinating with Business and Integration with various teams to execute UAT Testing.

Senior ETL Developer

• Analysis, Design and Development of Data warehousing solutions and strategies for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio.
• Migrating code from Ab initio to OWB for a customer information database.
• Handling feedback report from customer for a large database.
• Functional Design for a data mart.
• Ensures effective change control procedures and processes are efficiently used to maintain control on scope, schedule and cost.
• Facilitates Post Implementation Reviews and ensures lessons learned are carried forward appropriately.

 ETL Developer

• Analyzing data and create ETL processes into Data warehouse and analytic procedures. 
• Data Profiling, metadata driven Data Integrity test and Quality Analysis on data received from multiple sources systems.
• Oracle warehouse builder,Ab-initio and Oracle PL/SQL Developer in Analysis, Design and Implementation of Business applications .
• Generate ad-hoc reports using OBI Answers.