PROFESSIONAL SUMMARY:

• Dynamic, result oriented DW/BI Professional with 11.0 years of I.T experience focused primarily in the areas of BI/DW performing various roles in End to End implementation.
• Functional knowledge encompasses Government, Sales and Marketing, Insurance, Telecom, Retail, Manufacturing and Financial domains.
• Worked extensively on Client server and BI applications & acquired in - depth knowledge of various ETL tools (Informatica, Oracle Warehouse Builder, ODI, Pentaho), Data Modeling Tools (Erwin, Visio, Sybase Power Designer), BI Tools (Micro strategy, OBIEE, SAP Business Objects XI R3.2/ R3.1/R2/ R1/ 6.5 (Designer, Desktop & Web Intelligence Rich Client, Info View, Crystal Reports), Databases (Oracle, Teradata) and Unix Shell Programming.
• Extensive experience as DW/BI Architect - Job functionality involved proposal writing, project estimation, scoping, SOW finalization, warehouse tool evaluation, design, modeling, development and performance optimization of several BI/DW solutions encompassing complete life cycle of implementation. Regular reporting to client and various internal stakeholders and delivery as per quality, time and budgetary norms.
• An agent of change with skills in gathering, analyzing and writing requirements pertaining to a new product/business process, understanding the overall architecture and domain & facilitating seamless implementation of new product/systems/processes to meet changing business scenarios.
• An effective team player with strong communication, relationship management, analytical, coordination and planning skills. Comfort in interacting with people and clients at any level of business for smooth project execution.
• Possesses strong experience in SDLC (Software Development Life Cycle), Agile Methodology. Skilled in OO Analysis and Design, Data Modeling 3rd Normal Form, ER Modeling.
• Deep understanding of Inmon/Kimball methodologies and MDM Processes for establishing single version of truth. Strong ability to appropriately apply these DW/BI Concepts with excellent problem solving and analytical skills to disaggregate and structure problems.
• Providing post-implementation, application maintenance and enhancement support to the business stake holders with regard to the BI/ETL solution.

TECHNICAL SKILLS:

Job Function: Gathering functional specifications, Design of Program Specifications, developing High and low level data flows, creating reports & dashboards, developing data to object level mappings and workflows, Testing, QE & Implementation

Databases: Oracle 11g, Teradata 13.10, SQL Server 2014, DB2, MS Access, HPDM

ETL Tools: Informatica Power Center 9.6, IDQ, IDE, Oracle Warehouse Builder (10g), Pentaho DI, SSIS

Data Modeling: Data Modeling 3rd Normal Form, ODS Data Modeling, Dimensional Modeling (Snowflake and Star Schema), Knowledge of QMS Methodology, CA Erwin Data Modeler 7.3, Sybase Power Designer 16.1.0, Visio Pro 2013/ Office 365

Business Intelligence Tools: Oracle Forms 11g R2, SSRS, SSAS, YOTTA, OBIEE, Micro Strategy 9.2, BusinessObjectsXIR3/6.5.1/5.x (Universe and Report Designer, Web Intelligence), Crystal Reports, XCelsius4.5/2008

Other Tools: TIVOLI, SQL Navigator 6.5, VISIO, ERWIN, TOAD, NEXUS, CITRIX, CONTROL-M (Batch Scheduling), REMEDY and Quality Center (Defect Tracking), VSS and Clear Case (Version Control), Knowledge of QMS Methodology.

Languages: SQl, PL/SQL, T-SQL, C, C++, Java, Java Script, XML, HTML

OS: Linux, UNIX (Shell Scripting) & Microsoft Windows

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Sr. Enterprise Data Warehouse Architect

Responsibilities:

• Understanding the current system - ITS (Integrated tax system) primarily a mainframe-based application system written in COBOL with DB2 planned for migration to Visual Studio .NET based application interface on SQL Server 2014 Database with Integration, Reporting and Analytical capabilities.
• Understand all the current interfaces to be able to articulate the unified data needs.
• Effective interactions with all stake holders and executive team to develop requirements, define, present and implement solutions.
• Identify the operational vs strategic/analytical reporting requirements.
• Designing to interface with the New source System MITS which is a replacement to ITS.
• Implement the best industry practices of enterprise information strategy, enterprise data warehouse, master data management, data integration and transformation, data analysis, data mapping, data governance, and data quality to obtain optimal data and translating it into meaningful and actionable information for making strategic business decisions.
• Prepare Technical Design documents to project the solution approaches, identify the optimal solution and represent in ARB for design approvals.
• Design CDC and historical data retention strategy.
• Identify areas of improvement and be able to make balance recommendations.
• Tool evaluation and be able to recommend a cost effective unified environment setup for the currently diversified source and target application systems.
• Ensure for data quality, Single version of truth, avoid redundancy, and model it right in the first place.
• Identify the current requirements for Oracle Forms developed way back in 2005 and be able to re-write them in COGNOS/any other reporting environment.
• Exercising POCs for the following projects:
• Legacy DWP Decommission
• Migration of Oracle Forms on 10g to 11g
• Rewrite Oracle Forms to COGNOS

Technology/Software: CA Erwin 7.3 (Data Modeler, Data Navigator), Informatica 9.6.0, Oracle 11g, Oracle Forms, MS SQL Server 2014, SSIS, SSRS, SSAS, PL/SQL Programming, HPSM, Agile Principles and Tools, Cognos, Microsoft SharePoint.

Confidential, Durham, NC

Principal DB Engineer/ Database Architect

Responsibilities:

• Closely work with business, delivery & technical stakeholders in developing requirements, and planning for implementation
• Perform analysis and review of Business, Functional and Data Requirements.
• Assess Use cases and Story points using Top Team Client and JIRA for backlog items.
• Practice of Lean and Agile Software development methodologies.
• Define the technical requirements of the solutions.
• ETL & PL/SQL Stored Procedure design & implementation for product and internal tool features.
• Handle data lifecycle and deployment scripts and utilities.
• Great exposure to high volume OLTP Challenges.
• Work with development team to improve application performance by tuning queries.
• Work closely with DBA’s to set-up DB Structures and also ensure performance optimization, restartability and re-usability and avoid redundancy in data.
• Reconciliation and evidence creation for data movement from source systems to target database (DW).
• Close association with APP and Services team to ensure accurate integration of the data tier
• Coordinate receiving sign-offs from various teams across various stages of SDLC
• Attend CAB/Go-No Go Meetings to ensure successful install of the release.
• Coordinate with Business to ensure the business needs are met.
• Coordinate with L3 to close on High Priority defects in production (If any).

Technology/Software: Sybase Power designer 16.1.x, Informatica 9.2.0, Oracle 11gPL/SQL Programming, Unix Scripting, Autosys, Clear Case, GitStash, HPSM, Agile Principles and

Confidential, Houston, TX

Solution Architect

Responsibilities:

• Closely work with business, delivery & technical stakeholders in developing requirements, and planning for implementation
• Apply the knowledge of Data Warehousing and Business Intelligence to design and develop enterprise solutions which are focused on improving specific business processes with Confidential .
• Responsible for the overall solution and its implementation for Mar2014 Release.
• Works with Development and Business team members to build appropriate data views and architecture.
• Experience in Designing, Building and Maintaining the Universes, resolving the issues like loops and Traps using Alias and Context, designing complex objects using @prompt, @ Aggregate aware function.
• Implemented Security Features of Business Objects like row level, object level to make the data secure.
• Define the technical requirements of the solutions.
• Works with team members to manage data within the Data Warehouse/Business Intelligence structures.
• Data profiling
• Work on closing any gaps in requirements to mapping data elements in the EDW (Finance).

Technology/Software: Informatica 9.2.0, SAP BOXI 3.1 (Designer 12.3.0.601, Infoview 12.1.0Web Intelligence), Yotta, DIAL, YMS, HPDM, Neo view, Share point, MDM

Confidential, Madison, WI

Business Intelligence Analyst

Responsibilities:

• Closely work with business, delivery & technical stakeholders in developing requirements, and planning for implementation
• Understanding BRD thoroughly to Prepare and seek approval on technical high level and low level data design documents.
• Working with ERWIN Data Modeler 7.3 version to design the Star Schema Data Model.
• Designing the data model for adding RESUME data pertaining to job seeker into JCS DM.
• Model the data featuring SCD type 1, type 2 dimensions and include DW Plumbing columns.
• Creation of indexes to facilitate performance tuning.
• Creation of reusable data structures namely TIM DIM and PRC CNTRL table for purpose of restartability, CDC and performance optimization.
• Creation of Change Management requests and acts as DBA liaison to get the data model installed in DEV/ACC/PRD environments.
• Was involved in end-to-end development of whole of ETL solution for this project.
• Process Improvement:
• The existing system purges and reloads data on weekly basis and doesn’t pull incremental data. In this context, Designed and developed a prototype for facilitating CDC pull of data on daily basis which minimizes the load time and provides stake holders with most recent data which is near to real-time. Most performance optimized code. The prototype is successful in implementation and same is followed in adding RESUME data to JCS DM.
• Retired the legacy Argent scheduler jobs and converted all of them to run on Control-M.
• Creation of Data Lineage document from the Metadata repository using Meta data queries. This document is of value addition to business stake holders in mapping the Object from Report all the way back to Legacy application screens.
• Create and present High level & low-level ETL flow design.
• Reconciliation and evidence creation for data movement from source systems to target database (DW).
• Own Creation of mappings, sessions, workflows using Informatica 9.1
• Own Creation and use of control-m scripts to automate workflows on production for one-time/daily and weekly loads.
• Conducting reviews (design & code self/peer reviews)
• Provide Guidance to 2 FTEs of Confidential with Informatica 9.1 and help them up to pace with developer’s experience.
• Involved in Interactions with end users regularly for requirements gathering.
• Involved in designing and developing Database Views, Universe Design as well as report development to suit the Business Requirements in Business Objects.
• Analyzed all tables and created various indexes to enhance query performance.
• Created Cascaded Prompts, conditions at Universe level for various reports to specify the reporting parameters as per business requirements.
• Designed and Created Contexts for resolving Loops as well as fan and chasm traps in the Universes.
• Worked on enhancing the Performance of SQL Queries in Oracle.
• Worked with the business directly to make sure reports are meeting the Business requirements.
• Involved in testing for reports that were already developed to make sure the reports contain correct data.

Technology/Software: Informatica 9.1.0, SAP BOXI 3.1 (Designer 12.3.0.601, Infoview 12.1.0Web Intelligence), Oracle 10g/11g, Windows, BMC Control-M 7.0.000(Control-M EM, DesktopReporting Facility), CA Erwin 7.3 (Data Modeler, Data Navigator), Tivoli 6.0NT, SQL Navigator

Confidential, Austin, TX

Business Intelligence Analyst

Responsibilities:

• Solely responsible for maintaining the entire business objects environment.
• Experienced in Micro Strategy suite of toolset (Architect, Desktop, Web)
• Create Micro Strategy Dashboard and Scorecards
• Created reports as per the User requirement using the Universes as the main data Providers
• The reports were generated using Business Objects functionality such as Prompts, Filters,Was involved in end-to-end development of whole of ETL solution for this project.
• Closely work with business, delivery & technical stakeholders in developing requirements, assessing technology, and planning for implementation
• Understanding BRD thoroughly to Prepare SRS to seek approval on technical high level and low level design of application.
• Involve in data modeling of the DB objects (Star Schema)
• Reconciliation and evidence creation for data movement from source systems to target database (DW).
• Work with Business users to establish data patterns - IDE
• Cleansing, fixing duplicate issues and bad data issues using IDQ
• Create and present High level & low-level ETL flow design.
• Involved in coding of mappings, sessions, workflows using Informatica 8.6 version along with rest 3 member team.
• Own Creation and use of control-m scripts to automate workflows on production for one-time/daily and weekly loads.
• Used Teradata utilities extensively TPUMP, FastLoad, MLoad to Load the data from the flat files.
• Conducting reviews (design & code reviews) in ARB and DW/BI forums to seek consensus on design and code for GRR Application.

Technology/Software: Business Objects XIR3.2/3.1 (Designer, Web intelligenceCrystal Xcelsius4.5, Xcelsius 2008), Crystal Reports XI/10, Micro Strategy 9.2, Informatica 9.0Teradata, UNIX, Windows, MDM, CA Erwin 7.1

Confidential, NY

Business Intelligence Analyst

Responsibilities:

• Ensure Team cohesiveness and completeness in correct understanding of the requirements and design from ETL Perspective.
• Reusable component & detailed technical design
• Documenting the High and Low level design.
• Conducting reviews (design & code reviews)
• Informatica coding, test cases preparation, unit & integration testing.
• Reconciliation and evidence creation.
• Involve in Dev & QA testing.
• Migration of the system to QA and UAT phase.
• Troubleshooting of problems in QA and UAT phase.
• Update all the project related documents in VSS, the project-tracking tool.
• Have a constant follow-up whether the defects for each task is been logged on to the defect tracking system.

Technology/Software: Informatica 8.6, UNIX, DB2, Oracle9i, Perl, Eagle 9x

Confidential

ETL Developer

Responsibilities:

• Ensure Team cohesiveness and completeness in correct understanding of the requirements and design.
• Ensure team coordination while development and review activity.
• Reusable component & detailed technical design
• Documenting the High and Low level design.
• Conducting reviews (design & code reviews)
• Informatica coding, test cases preparation, unit & integration testing
• Reconciliation and evidence creation.
• Involved in Dev & QA testing.

Technology/Software: Informatica 8.1, Oracle10g, UNIX, Seibel Analytics Reports

Confidential

Developer/Analyst

Responsibilities:

• Involved in detailed technical design
• Coding the Mappings in OWB to load data into the Staging, ODS and ADS.
• Scheduling the Unix Scripts to Load data into staging.
• Creation of Sessions and Process flows to schedule these mappings.
• Design and Creation of Unit Test cases
• Performing Unit testing and Integrated Testing.
• Reconciliation and evidence creation.
• Designing the Reports for Business Analysis.
• Involved in QA & UAT testing. Handled issues, performed analysis on these issues and initiated interaction with client and business users to see that results cater to their requirements. If necessary, performed quick & minor code fixes upon Client’s requirement.

Technology/SoftwarePL/SQL, Oracle 9i, Siebel, Oracle Warehouse Builder, Crystal Reports

Confidential

ETL Designer

Responsibilities:

• Involved in detailed technical design
• Design of Mappings employing various transformations, filters, joiners, SQL overrides etc to load data from multiple databases into Warehouses
• Scheduling the Unix Scripts to Load data into staging.
• Creation of Sessions and Workflows to schedule these mappings.
• Creation of Unit Test cases
• Perform unit testing of these Workflows from source to staging and staging to Warehouse of data warehouse
• Reconciliation and evidence creation.

Technology/Software: Informatica 6.2.2, SQL server 2000, DB2 UDB version 7, UNIX shell scripts, Maestro scheduler.