EXPERIENCE SUMMARY:

• 13 years of IT experience in Data ware and Business Intelligence projects with domain experience in Healthcare, Banking and Financial Services, Insurance industry.
• Data warehouse and Business Intelligence lead
• Work experience in ETL, BI, Data Modeling in multiple data warehouse projects
• Responsible for Enterprise Reporting Solutions and Architecture
• Experience in requirements, analysis, design, development and maintenance of Extract Transform Load (ETL) and Business Intelligence applications.
• Experience in SSIS, Informatica Powercenter, SSRS, Business Objects 4.0, Xcelsius, Crystal Reports, Hadoop, Hive, IBM Information Data Architect (IDA), Erwin, SCRIBE
• Experience in working setting up Single Sign using windows AD Authentication, create users, groups, connections, security
• Proficient in using the SQL Programming language in the ETL application which includes Stored Procedures, Indexes, Views, User Defined Functions and Triggers. Have worked on performance tuning for stored procedures
• Knowledge and experience of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design and architecture
• Designed and Developed Data Model, Process to Data Model interaction, Information Architecture, Impact Analysis
• Experience in Data modeling: Dimensional Model, Conceptual, Logical and Physical data model
• Hands - on experience loading data from source files to HDFS using Hadoop Sqoop. Accessing data via Hive database
• Knowledge in SCRIBE Insight and worked on mappings, transformations to move data from flat files to SQL server database
• Experience in writing Stored Procedures, Materialized Views, Materialized Query Tables (MQT) and Triggers to implement the business logics of database in Oracle/DB2/SQL Server
• Project Management skills delivering multiple offshore and onsite projects on time with available resources
• Worked on multiple Agile projects

TECHNICAL SKILLS:

ETL Tools: SSIS 2012, Informatica Powercenter 9.6.1, Hadoop, SCRIBE Insight

Reporting Tools: Business Objects (6.x, XI R2, XI R3, XI 4.0), Crystal Reports (10/11(XI)/12(2008)), Dashboards 4

Data Modeling Tools: IBM Information Data Architect 7.5.3.1, Erwin Data Modeler 7.2, Dezign5

Operating Systems: Windows 2010, Mainframes OS/400, Unix

Databases & Tools: Oracle 11g/10g, SQL Server 2012/2008, Teradata 14.10.05.09 , IBM DB2 8.1.7, Hive, TOAD, Teradata SQL Assistant

Programming Languages: VB, PL/SQL, Unix Shell Script

Other Tools: MS Project Professional, Test Director 8.0/Quality Center, MS Access, MS Excel, MS PowerPoint, MS Visio

PROJECT EXPERIENCE:

Confidential, Dayton

Technology: Microsoft Project, Hadoop, Hive, Informatica 9.6.1, SSIS, SSRS, SQL Server 2012, Teradata, Erwin

Technical project manager

Responsibilities:

• Responsible for Big data development and testing
• Worked extensively on Solution Design, Development of ETL framework for various projects within Pharmacy and Medical Management area.
• Created new Informatica mappings for reporting and downstream needs
• Created SSIS package for operational reporting, external vendors, state regulatory reports
• Design database tables in the EDW
• Developed SSRS reports and published them to end users
• Experience creating multiple complex stored procedures for multiple business rules
• Automate the generic format downstream file generation for various parameters/rules
• Implemented ETL Audit, Balance and Control mechanism for all SSIS packages
• Executed and worked in agile project management process
• Provided weekly status reports, utilization report to all stake holders

Confidential, Newport Beach

Technology: SSIS, SQL Server 2012, Erwin

Lead Data warehouse expert

Responsibilities:

• Understand the existing sources to the Finance data mart in ADW
• Data profiling, data modeling, ETL solution
• Gather the business requirements and reporting needs
• Identify and document the pain points from business and gaps on the ADW
• Provide overall technical solution, roadmap, effort estimates, standards and best practices to be followed for upgrading the data mart
• Worked to create a new SOW (statement of work) for the recommended approach with scope, roadmap, high level solution, cost estimates
• Create the billing and invoice for the project

Confidential

Technology: Informatica, Business Objects XI 4.0, Crystal Reports XI/2008, Dashboards 4, Information Design Tool, Universe Design Tool, Query as a Web Service Designer, Oracle 11g PL/SQL

Data warehouse Project Manager

Responsibilities:

• Setup quality and code review process
• Project management, resource management and team management
• Working as offshore technical lead on requirement, design and development
• Developed Universe, Crystal reports, Dashboards, Information Spaces & Exploration view sets, Query as Web Services.
• Worked on IDT (Information Design Tool) with Business Layer, Data Foundation using designer and IDT, Explorer tool with Information Spaces and Exploration views sets
• Review Informatica mappings
• Review PL/SQL ETL scripts
• Review all deliverables to ensure good quality before delivering to customer
• Delivered all the reports with high quality on time
• Provided weekly status reports, utilization report and metrics to customer
• Interview and hire new resources to the team
• Create forecasts/roadmap for the project. Generate billing and invoice for the project at the end of every month
• Worked on multiple project proposals, SOW preparation and contract amendment for resources.

Confidential, Malvern, Pennsylvania.

Technology: Business Objects XI 4.0, SQL Server

Responsibilities:

• Agile project with daily stand up meeting, Scrum planning meetings, Sprint retrospective
• Provide demo at the end of each two week sprint
• Technical lead responsible for reporting solution
• Setup a quality and review process
• Worked on BO admin tasks to create users, groups, connections and security
• Achieved Single Sign on in BO from the Java Web application using trusted authentication
• Worked extensively on Solution Design, Development of Universe, Reports & Dashboards
• Review all deliverables from offshore
• Provided sizing estimates for the production system
• Delivered all the reports with high quality on time
• Created weekly status reports and metrics

Confidential

Technology: SSIS, Business Objects XI R3, Crystal Reports 2011, Oracle 10g, CareRadius

Technical lead

Responsibilities:

• Worked extensively on Solution Design, Development of Reports & Letters
• Used the capabilities of Crystal reports to extract all Business needs for generating letters. e.g. data validation, business validation of letter fields
• Responsible for Universe design. Two complex universes 1. Utilization Management, 2. Case Management
• Responsible for Package and Stored Procedure design & development for Crystal reports (Letters)
• Worked as an SME on the CareRadius application and provided feedback / suggestions on improvement of the system
• Delivered all the reports & letters with high quality on time
• Worked on Stored Procedures and SSIS packages to build the letters rules engine and support front end to correct error records
• Created weekly status reports and metrics

Confidential, Hartford

Technology: IBM Information Data Architect, SQL Server 2008

Information Architect

Responsibilities:

• Understand Business requirements and study the impact on new/existing applications and provide estimates, solution, design for Data Model
• Responsible for creating process to data model interaction, Conceptual model, Logical model and Physical data model
• Create Mapping documentation, Access path requirements, Model diagrams
• Created weekly status reports and metrics

Confidential, Hartford

Technology: SSIS, Business Objects XI R3, Oracle 10g, SQL Server 2005, Dezign5, Planview 10

SME

Responsibilities:

• Interacting with business users, senior managers, senior executives to obtain requirements and provide solution on scorecards and reports.
• Scorecards are used by Program Managers and senior executives to execute the business effectively.
• Responsible for requirement suggestion, recommendation and solution design
• Responsible for creating Data Model for reporting tables
• Develop SSIS packages using stored procedures to build the new reporting data mart
• Responsible for design and development of reports
• Responsible for BO Universe design
• Performance and fine tuning of SQL
• Design and mentor a new data mart for Release Management universe (Metadata). Release management universe is widely used by the senior management to handle all the project releases throughout Confidential .
• Working as an onsite coordinator for execution of requirement, design and solution with the offshore team
• Created weekly status reports and metrics

Confidential, Los Angeles

Technology: Business Objects XI R3, Erwin Data Modeler 7.2, IBM DB2 8.1.7, Mainframes OS/400, Quality Center

Lead reports developer and onsite coordinator

Responsibilities:

• Preparation of Data Model artifacts - Logical/Physical Data Model using ERWIN tool and data dictionary
• Implementing DDL/DML Scripts in IBM DB2 8.1
• Performance tuning and query optimization
• Consolidation of Valid values from five Business units
• Created Materialized Query tables using DB2 8.1 which are then used in Business Objects reports to improve performance
• Created Mainframes job and scheduled them to populate reporting tables.
• Requirement analysis and design of Business Objects Universe and Reports
• Worked as an onsite coordinator for execution of the requirements with the offshore team
• Created status reports, metrics and presentations

Confidential, Irvine

Technology: Business Objects XI R2, Crystal Reports 10, Oracle 9i/10g, Informatica, SQL Developer, Quality Center

Responsibilities:

• Interacting with business users to obtain requirements for Business Objects reports and create functional specification for requirements
• Responsible for architecture of the reporting solution
• Developing EPM based Analytics and Dashboards
• Responsible for design and unit test plan creation
• Working as an onsite coordinator for execution of the requirements with the offshore team
• Scheduling and monitoring reports
• Created status reports, metrics and presentations
• Involved in admin activities such as assigning user privileges and migrations from one environment to another
• Worked with business users to support UAT
• Performed complete case study on BO XI R3 features and presented it to Client
• Extracting and loading of data from flat file, Oracle sources to oracle database (target warehouse) using transformations in the mappings.
• Analysis of certain existing mappings, which were producing errors and modifying them to produce correct results

Confidential

Technology: Business Objects 6.1a, Crystal Reports 10, Oracle 9i, TOAD, PeopleSoft CRM 8.8, Test Director 8.0

Responsibilities:

• Requirement analysis
• Development and Maintenance of the Business Object Reports and Universe
• Development of Stored procedures for using them in Business Object Reports
• Preparation of the functional design document with information and data flow across the application
• Delivery of the developed technical designs to the client
• Prepare test plan and Test Procedures for the Reports
• Unit Testing of the Reports and Review of the Test Results
• Collect and Monitor Metrics Related to Productivity and Quality
• Worked on Prolite for Project task creation, allocation and collection of metric. Attended few internal audits.
• Trained and Lead a team of size 4 at offshore for project delivery