SUMMARY:

• 18+ years of expertise in BI/Data/Data warehousing Architecture
• Expertise and profound knowledge in multiple domains Financial, Insurance, Travel etc...
• Part of Microsoft team to design Confidential .
• Managed multiple BI small scale to large scale projects within scope, budget and time
• Extensive expertise on work distribution in onsite - offshore model
• Expertise in managing scope creeps, risk factors and generating organization assets
• Managed a team of 5-25 people for various projects for the company
• Played a Data Architect / DW Architect / ETL Architect and BI Architect roles. involved in the complete SDLC of DW projects comprising of requirements gathering, Data Cleansing, Data Validation, Data Profiling, data modeling
• Excellent knowledge on data warehousing concepts - Confidential Schema
• Gathered requirements based on understanding the clients business and KPIs/Metrics that are tracked, by conducting interviews with users, studying existing reports
• Identified Business entities and Followed Bottom-Up approach to suggest Logical data model ( Confidential ).
• Conducted Dimension modeling workshops to present the dimensional model and analysis pattern to the Business Users based on the requirements gathered
• Transferred the logical data model to Physical data model ( Confidential ) to organize the data into table/columns

TECHNICAL SKILLS:

Operating System: Windows 2003/NT/XP/Linux

Programming Languages: PL SQL

Databases & Tools: SQL Server 2000/2005, Oracle 9i/10g/11g, Teradata

Other Utilities: Cognos7.2/8.x/10.x, BO XI, Informatica 5.x /6.x/7.x/8.x/9.x, Informatica Confidential

Big data: Microsoft Confidential, Hadoop, Hive, Sqoop, HDFS, MapReduce, Microsoft PDW and informatica cloud.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Technical project manager

Responsibilities:

• Part of Microsoft team to design Confidential .
• Designed a process to do file ingestion and enrichment to Hadoop
• Suggested and designed informatica cloud and sqoop to bring data from salesforce web application to Hadoop.
• Managed multiple BI small scale to large scale projects within scope, budget and time
• Extensive expertise on work distribution in onsite-offshore model
• Expertise in managing scope creeps, risk factors and generating organization assets
• Managed a team of 5-25 people for various projects for the company

Confidential, Monterey Park, CA

Technical project manager

Responsibilities:

• Working on Confidential ’s Risk analyst Application and extracting data elements for management reporting and providing data to downstream.
• Confidential ’s Risk analyst tool stores the data into vertical format and it needs to be extracted through pivot queries.
• Under Confidential process and Confidential financial reports.
• Confidential (Comprehensive Capital analysis and review) report generated every quarter to submit to federal.
• Analyze the Confidential requirement and other requirements to come out with design document.
• Suggested and implemented scalable solution.
• Reporting solution developed using Informatica Power center and Informatica Confidential .
• Designed and developed Informatica mapping to achieve the business logic.
• Reviewed Informatica mappings what got delivered from offshore.
• Imported objects to create physical data model.
• Created mapping to achieve logical data model.
• Prepared test cases and tested all the mapping and captured test results.
• Came out with validation methods to verify source and targets.(Counts and sum)
• Played the role of onsite co-coordinator role in the onsite/offshore model
• Have a good understanding about customer, exposure and collateral.

Confidential, Owings Mill, MD

DW/ETL Informatica Architect

Responsibilities:

• Implemented Tier 1 Business rule in the mapping. Tier 1 validation is rules for data within a data element (is data element is valid date or valid number and valid char)
• Implemented Tier 2 Business rule in the mapping. Tier 2 validation is rules for data within a T-MSIS file.( is start data is less than end date, Total count equal to sum of line count)
• Developed a common stored procedure for all the file claim file types tier 1 and tier 2 validation and called from informatica mapping by passing file type as a parameter.(Claim OT/Claim LT/Claim IP/Claim RX)
• Analysed the new requirement and change request (CR) to come out decision to go for new mapping or modifying existing mapping.
• Developed data conversion mappings from MSIS DB2 to Confidential Oracle. Created unit test scripts and Set up source data and unit tested the mappings.
• Created Label in Repository manager to migrate code from Dev to QA.
• Created and modified Linux scripts and promoted from DEV to QA environments using SFTP.
• Prepared Mapping Document.

Environment: Informatica PowerCenter 9.x,, Oracle 11g, Linux.

Confidential, Milford Mill, MD

DW/ETL Informatica Architect

Responsibilities:

• Analyzed and rationalized all the existing reports which are currently produced by the mainframe system and came out with unique numbers of attributes and unique number of metrics.
• Identified all required Dimensions and facts based the on rationalization of the reports.
• Designed a logical and physical data model which is scalable.
• Suggested and used Confidential for the data model design.
• Developed and followed naming conventions (Like ID, Names, Indicators, Flags) and come out with standard lengths of the attributes and metrics to ensure consistency of data model.
• Came out with ETL strategy and designed ETL best practices.
• Designed and developed informatica mapping to achieve the business logic.
• Designed slowly changing dimension based on the level of history which was required for the users.
• Came out with validation methods to verify source and targets.(Counts and sum)
• Reports are produced and published through Microstrategy.
• Analyzed the new requirement and change request (CR) to come out decision to go for new mapping or modifying existing mapping.
• Analyzed the Trouble Ticket (TT) and came out with a quick turnaround
• Developed and modified existing and new mappings. Based on the change request.
• Created unit test scripts and Set up source data and unit tested the mappings.
• Created Label in Repository manager to migrate code from Dev to QA.
• Created and modified oracle packages which is called from mappings.
• Created and modified Linux scripts and promoted from DEV to QA environments using SFTP.
• Generated output files and send the files to mainframe using NDM Linux scripts.
• Prepared Mapping Document
• Prepared PTCS (Preliminary Test case summaries) to test microstrategy reports.
• Written complex queries to verify the reports results.
• Prepared PTE (Preliminary Test evidence) and captured all the queries and output in the PTEs.

Environment: Informatica PowerCenter 9.x,, Oracle 11g, Linux., Microstrategy 9.3.1

Confidential, Indianapolis

ETL Informatica /BI Cognos Architect

Responsibilities:

• Analyzed the new requirement and change request (CR) to come out decision to go for new mapping or modifying existing mapping.
• Prepared Mapping Document and Designed and developed new informatica mappings.
• Modified existing mapping based on the change request.
• Prepared understanding document and assigned mappings development work to the team.
• Fixings Performance issues of exiting mappings
• Created unit test scripts and unit tested mappings all the mappings.
• Migrated the code between environments ( DEV/QA)
• Monitor Jobs using Workload Automation tool / Fixing if any failures.
• Co-coordinating with Source team who sends the source files.
• Rationalized all the existing reports and identified unique number of attributes and measures.
• Developed centralized package to bring all the attributes and measures for all the countries.
• Designed and developed 4 layers BI Architecture in the FM Model. (Import, Model, Business and Presentation.)
• FM model designed from Operation data source and Dimensional modeling taken place in the model layer.
• Designed and developed global calculations and filters in the model level.
• Introduced data level security in framework manager model.
• Created Prompts, calculations, Conditions, Filters and complex reports in report studio.
• Identified all the possible combination of test cases, reviewed all the reports
• Played the role of onsite co-coordinator role in the onsite/offshore model.

Environment: Informatica PowerCenter 9.x, Cognos 8.4/ Cognos 10.x, Oracle 11g

Confidential, Denver

ETL Informatica Architect

Responsibilities:

• Prepared Requirement document for Service image which includes all the system extraction criteria.
• Suggested and designed all the target schemas in the migration factory.(Legacy Source schema / Unified schema / End State Schema)
• Created a detailed design document to have ETL Framework / Source to target mapping details and acceptance and approvals.
• Prepared and followed Informatica best practices for coding, connections, repository folder structure and file folder structures.
• Prepared Mapping document and developed Informatica mapping
• Created unit test scripts and unit tested mappings all the mappings.

Environment: Informatica PowerCenter 9.x, Oracle 11g, Linux

ETL Informatica/ Cognos Architect

Confidential, Somerset, NJ

Responsibilities:

• Suggested and Designed a data mart and identified the Facts/Dimensions for data mart
• Suggested and designed stat schema and Created Logical and Physical data models.
• Designed the folder structures and naming standard for mapping /session/workflow.
• Suggested and implemented ETL Informatica standard for performance
• Created Functional requirement document (FRD)
• Created Mapping Documents for ETL
• Developed and tested mappings
• Prepared unit test cases and captured test scripts.
• Suggested and Designed Business Intelligence solution dashboards.
• Suggested, Designed and Developed Framework Model
• Designed and developed 4 layers BI Architecture in the FM Model. (Import, Model, Business and Presentation.)
• Designed and developed global calculations and filters in the model level.
• Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models.
• Analyzed business requirement and Design report template.
• Designed, Developed and Implemented an Enterprise Wide Reporting system using Cognos 8.
• Created Prompts, calculations, Conditions & Filters
• Identified all the possible combination of test cases, reviewed all the reports
• Suggested resources plan and identified required skills.
• Played an onsite co-coordinator to gather report requirement from business analyst team, understand the data marts from database team, managed the offshore team to deliver the project and delivered reports to QA team.

Environment: Informatica Power Center 8.x /Cognos 8.2 / Cognos 8.4 / Cognos 10.x, Oracle 10g

ETL Informatica / Cognos Architect

Confidential, Hartford, CT

Responsibilities:

• Analysis of source system and identified the Facts/Dimensions for data mart
• Creating Logical and Physical data models
• Created Functional requirement document (FRD)
• Created Mapping Documents for ETL
• Developed and tested mappings
• Suggested, Designed and Developed Framework Model
• Designed and developed 4 layers BI Architecture in the FM Model. (Import, Model, Business and Presentation.)
• Designed and developed global calculations and filters in the model level.
• Analyzed business requirement and Design report template.
• Identified Risks well in advance and brought to client management attention.
• Played an onsite co-coordinator to gather report requirement from business analyst team, understand the data marts from database team, managed the offshore team to deliver the project and delivered reports to QA team.
• Identified all the possible combination of test cases, reviewed all the reports and delivered

Environment: Informatica PowerCenter 8.x/ Cognos 8.2 / Cognos 8.4, Teradata