SUMMARY:

• Eleven years of IT experience with over six years of technical lead and Managerial experience in Telecom and Healthcare Data warehouse projects
• Extensive experience in software size estimation, cost and resource estimation, due diligence study, preparation of statement of work, project management skills, technical presentation and client liaison
• Worked as a solution architect for two years to understand and reengineer the client process to fix the performance bottlenecks
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications
• ETL Experience of using informatica 8.6.1/9.1/10 Power Center client tools such as Mapping designer, Repository Manager, workflow Manager/Monitor and server tools such as Informatica Server manager. Experience in using other ETL tools such as Oracle warehouse builder.
• Expertise in Conceptual data modelling, Enterprise Data Modelling, Logical Data Modelling, Physical Data Modelling, Enterprise Data Warehouse design, DataMart design, Data Quality, Master Data Management and Data Governance.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin.
• Expertise in working with relational databases such as Oracle 12c/11g/10g/9i/8x and medium exposure to SQL server 2008/2005
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using Oracle PL/SQL and SQL Server
• Strong Expertise in performance fine tuning of applications that runs on database especially Oracle and very strong experience in writing and analyzing complex SQL queries.
• Experience in scheduling tools like Automic for automating Informatica workflows, Shell/Perl scripts and SQL scripts.
• Extensive experience in writing UNIX shell scripts, Windowsbatch scripting and automation of the ETL processes using UNIX shell scripting.
• Worked extensively with concepts like slowly changing dimension
• Excellent documentation skills for Database design document and Technical design document
• Experience in implementing Quality Processes like ISO 9001:2000/Audits.
• Hands - on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, writing technical design document, data mapping, build and deployment, unit testing, systems integration and user acceptance testing
• Having tremendous interest in Hadoop technologies and undergoing self-learning sessions on HIVE, Scoop technologies.
• Working on Proof of concept of converting our Data mart to Data Lake using Hadoop. HIVE and Scoop are used for Data Conversion.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX/LINUX/SOLARIS, MS-DOS

ETL Tools: Informatica Power Center 10/9.1/8.6 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server) and Oracle warehouse builder

Databases: Oracle 12c/11g/10g/9i/8i, MS SQL Server 2008/2005

Data modelling tools: Erwin, MS Visio

Languages: SQL, PL/SQL, UNIX Shell scripts, Perl

Scheduling Tools: Automic

Configuration Management tools: Star Team, Tortoise SVN and WinCvs

Other tools used: Oracle SQL Developer, Toad, Putty, Winscp, MS Visio, beyond compare, Microsoft SQL server

PROFESSIONAL EXPERIENCE:

Confidential, Ann Arbor, MI

Solution Architect

Responsibilities:

• Serve as subject matter expert for HDP Platform
• Work with Product Management and Development Management to recommend Process improvements, quality improvements, assist Product Management in gathering requirements/analysis and approach to solving business issues
• Designed and Implemented Automation of ETL jobs and housekeeping activities in Data warehouse
• Designed and Implemented compression of Oracle Partitions and tablespace transportation for archival activities of warehouse
• Developed PL/SQL blocks for complex data conversion logics that are not performant using ETL tools like Informatica.
• Mentor the team in technical areas and architecture
• Identify and provide technical solutions to pain point areas within the application
• Release, Resource, Capacity and Iteration planning
• Perform Design and Delivery review
• Manage the project quantitatively
• Conduct Internal Release Audit before every release
• Conduct Configuration Audit and Retrospective Meetings
• Manage the skill and knowledge of the team

Environment: Informatica 8.6.1/9.1/10, Oracle 11g R2, Automic for Scheduling, Red Hat 6.5 for ETL Server and Solaris 5.10 Linux for Database Server, Perl, UNIX shell scripts, Oracle PL/SQL including advanced concepts like Tablespace transportation and Dynamic Partition Exchange, IBM Transformation Extender 8.3

Confidential, Collegeville, PA

Technical Lead

Responsibilities:

• Requirement Analysis and System Functional Analysis
• Involved in Data modeling of Intelligence systems Data Marts
• Mentor the team in technical areas and architecture
• Help team write the stored procedures to transform and load the aggregated information for application CLS and PBI.
• Conduct design review meetings with the stakeholders and make sure the delivered results are in accordance with the design and client expectations. This helped us identify critical issues in User Acceptance Layer.
• Played a major role in successful production implementation of the project.
• Documenting the entire process to support team and stake holders
• Manage the skill and knowledge of the team
• Involved in Unit testing by preparing the test cases.

Environment: Oracle 11g, Netezza and UNIX

Confidential

Senior Consultant

Responsibilities:

• Involved in design phase to capture business requirements.
• Worked in the development of OWB maps which includes the data staging and data clashing.
• Managed and led the Team of 16 and helped them for technical expertise
• Interacted with Confidential Business and helped them in resolving Data integrity issues

Environment: Oracle 10g, Oracle Warehouse builder, Oracle APEX and UNIX shell scripts

Confidential

Senior software Engineer

Responsibilities:

• Involved in OLTP Data modeling activities for SIM, Details mentioned above
• Worked as a Data modeler to in corporate business functionality to Siebel data model for CMF projects.
• Leading the team as a senior Data modeler and Data base engineer in gathering business requirements.

Environment: Oracle 10g, ERwin Data Modeler.

Confidential

Senior software Engineer

Responsibilities:

• Wrote low level design documents from High level requirements documents after doing detailed system study
• Guided Team during the implementation phase
• Wrote PL/SQL Procedures to Order and Services data from upstream systems to Common Data Model
• Fine-tuned slow performing queries and stored procedures
• Worked with DBAs and analyzed stats pack reports

Environment: Oracle 9i, UNIX Shell scripts, PL/SQL Developer tool

Confidential

Senior software Engineer

Responsibilities:

• Involved in Knowledge transfer of DUA application from Infosys to Virtusa
• Client co-ordination from onshore on each deliverables
• Implemented low level designs by writing PL/SQL procedures
• Requirements gathering and preparation of low-level design documents
• Guided Team during the implementation phase
• Fine-tuned slow performing queries and stored procedures
• Helped offshore team when they needed technical assistance

Environment: Oracle 9i, UNIX Shell scripts, PL/SQL Developer tool

Confidential

Software Engineer

Responsibilities:

• Involved in Knowledge transfer of Product Build application.
• Offshore and Offshore coordination
• Wrote PL/SQL wrapper procedures
• Handled Production and Critical issues
• Fine-tuned slow performing stored procedures
• Helped offshore team when they needed technical assistance

Environment: Oracle 9i, PL/SQL Developer tool, Remedy Ticketing tool

Confidential

Software Engineer

Responsibilities:

• Primarily involved as a database engineer
• Proactively involved in critical development activities
• Helped in LIVE deployment activities
• Managing code consistency from development to LIVE environment

Environment: Oracle 9i, PL/SQL Developer tool, J2EE

Confidential

Associate software Engineer

Responsibilities:

• Proactively involved in development activities like preparing DW reports
• Worked as a DB engineer in SQL Server for a Banking client
• Helped TEAM by conducting knowledge sharing session on Informatica ETL tool

Environment: Cognos, Informatica, SQL Server