SUMMARY

• Solution - oriented Data warehousing and Business Intelligence Architect offering 16 plus years of experience in IT industry participating in Analysis, Design, Construction and implementation of End to End Data warehousing and business intelligence solutions.
• As a Senior Advisor member of the Enterprise Data Warehouse team responsible for application development for the EDW Team. Accountable for designing comprehensive solutions that meet business requirements and incrementally moving the data warehouse to the future state.
• Assisting the team with the technical direction for the design, development, testing, implementation and maintenance of data warehouse solutions.
• Extensive experience as a DWH Solution Architect (BI Technical Lead) focused on Design, develop, and deploy Business Intelligence (BI) and Data Warehouse solutions for various clients and Informatica Power Center, BI report writing using IBM Cognos 8/Cognos 10X/ Cognos 11x. Microsoft Data Tools (SSIS, SSRS, SSAS).
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Development, Informatica Repository Manager and Informatica Server Manager, Workflow Manager & Workflow Monitor.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Extensive experience in Analyzing the OLTP modeling and carry out suitable data model for Data warehouse using Star Schema.
• Expertise in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise datastores within a metadata repository.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Extensive experience in Modeling iterations (Schematic/ Logical/ Physical) Forward and reverse-engineering process using ERWIN tools.
• Extensive Experience in MDM Design and Implementation.
• Expertise in applying ESA strategies to visualize the portfolios current & future state.
• Expertise in evaluating the ESA strategies by using gartner’s TIME.
• Experience in addressing Performance related issues.
• Experience in schema designing for data marts, data transformation and data integration.
• Experience in cognos OLAP modelling and development of cognos Power play cubes.
• Good exposure in SSIS/ Informatica Power Center by defining Source, Staging, Target Mapping design.
• Involved in ETL testing iterations by evaluating the Source to Staging mappings and Staging to Target Mappings.
• Good exposure in Cognos model designing using Framework manager and OLAP modelling in Cognos Power Play Transformer and SSAS.
• Worked with Analysis Studio and report studio to develop multi-dimensional reporting and reports based on daily\weekly forecast requirement.
• Designed Transformer model, created PowerCube's, Dimensions, Levels, Measures, Categories, User Classes using PowerPlay Transformer.
• Used Transformer to handle large Data Sources, for easier integration of cube builds and Data Warehouse updates, to get increased Performance, for scheduled cube creation, for faster processing.
• Designed SSAS Tabular Model by identifying the customizing Dimension and Facts using SQL and Model and apply the calculation based on the requirements and trained the super user for the SelfBI.
• Guided the business, top management, development team about Fast Analytics. So there is at least 50% wait/ dependency on traditional DWH reports
• Experience with Cognos/ Database upgrade iterations.
• Lead the Upgrade activities like Database/ ETL/ Reports coordinating with the customer support for hot fixes.
• Designed 360 degree Customer view to understand the behaviors and identify areas of revenue opportunity.
• Involved in defining the use case patterns on Hadoop for Pharmacy Channels.
• Possess the ability to analyze customer requirements and transform them into technical design specifications.
• Experience in production support with quick turn-around time for hot fixes.
• Good command over Oracle, SqlServer, teradata and DB2 databases with experience in transforming use cases into database designs, identifying facts and dimensions to populate demoralization data set.
• Partner with the Project Management to ensure alignment of plans with what is being delivered and utilize configuration management and software release experience as well as change management concepts to drive the success of the projects.
• Partner with senior leaders to understand and communicate the business needs to translate them into IT requirements.
• Quick Learner and Good Listener.
• Excellent Team player/ Good Customer interaction skills.

TECHNICAL SKILLS

Data Warehouse Tools: SQL Server Data Tools (SSIS, SSRS, SSAS), Cognos 7.4/Cognos 8.4/Cognos 10.1, 10.1.2Cognos 11x, Informatica 7.1/ 9X, Data Stage 8X, ProClarity Desktop Client 4.0.

Fast Analytics: Tabeleau, Power BI

Databases: Oracle 9i/10g, DB2 8.1, Tera Data, SQL Server

Modeling Tool: CA Erwin Data modeler, Aqua Data Studio, Idera

METHODOLOGY: Inman/ Kimball/ Delivery Methodology Agile

Framework: Gartner’s TIME (Tolerate, Invest, Migrate, Eliminate)

TECHNOLOGY: OLTP/ OLAP/ MDM/ Hadoop

CRM Mobile: E.piphany Mobile Application 6.5.2

Web Tools: HTML

Application Server: Tomcat

Operating Systems: UNIX, Windows

Configuration/ Migration: HP ALM, Tortoise SVN, TFS, Service Now

PROFESSIONAL EXPERIENCE

DWH Architect

Confidential

Responsibilities:

• Understanding the existing pain issues and the guidewire data flow.
• Draft the road map to fix the existing guidewire OLAP dataset. Data Visualization & Business Gaps issues in Claim Center| Policy Center| Billing Center.
• Involve in Streamlining the Billing Center Cash Receivables/ Account Receivables/ Unapplied Processed/ Unapplied Open/ Disbursement/ Non Zero.
• Guiding the eight-member team to streamline & progress on all the open Data Integration & Data Visualization issues.
• Involved in creating new/ update the existing Mappings using Informatica Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Involve in Agile activities Sprint| Stand-up| Daily Show & Tell| Work-ion-progress .
• Updating the management on teams estimate timelines and the agile progress report to overcome the unexpected surprises.

Environment: Oracle, Informatica, Cognos, SVN, Rally.

DWH Architect

Confidential

Responsibilities:

• Confidential was supported by IBM and I was hired as a consultant to stream line the Customer Insight Subject Area.
• Client was using Excel grid to calculate the outcome, the challenge is the data was not well connected.
• Involved in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Involved in Data Integration/ Data Visualization Architect & Development Activities.
• Transformed the excel source to Dimensional Modeling using Informatica especially for the Self BI.
• Extensively worked in ETL mappings, Transformations and Loading using Informatica Power Center
• Closely worked with the OLTP technology team to extract the data from the third-party dataset to Confidential data lake.
• Involved in defining and framing the OLAP Dimensional modeling and Cognos metadata model (Framework Manager) extensively for the Self BI.
• Automated the whole ETL (Integration), Report Solution with zero manual intervention and from now all the top-level management will have the access to the Cognos portal to get the clear Insight on customer survey.
• Involved in Cognos metadata design (Framework manager).
• Involved in end to end Customer Insight Iterations requirement gathering, design, development, testing, build.
• I have completed the task in the given short time frame and the report solution added more values to the business by understanding the clear insight of the Confidential valued customer feedback survey.

Environment: IBM DB2, Informatica, Cognos 11x, TFS, Service Now.

DWH Architect Data Wrangler Assignment

Confidential

Responsibilities:

• Involved in framing the data wrangler frame work to simplify the data integration, reports data visualization.
• Defined the data wrangler methodologies to perform transformation using Trifacta.
• Involved in Trifacta/ Data Visualization Testing iterations.
• Generated the data visualization source using Trifacta for Desktop Tableau to address the fast analytics/ self bi stream.
• Added more values to the big data dataset to simplify the complexity of data integration, data visualization.

Environment: Orcale, SQL Server, IBM DB2, DataStage,Trifacta, Tableau, Cognos 11x, TFS, Service Now

DWH Architect

Confidential

Responsibilities:

• Understanding the Existing & Proposed System.
• Involved in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Involved in ETL/ Report Testing & Reconciliation efforts.
• Constantly evaluate the System Enhancement Requirement (SER) open tickets to review DODD application portfolio excel gird against two primary measures; business value and IT quality
• Define the Dataflow and Suitable Architecture for Self BI.
• Convert the Business Requirement to Technical Specifications for the defined Subject Areas.
• Define Vault Model for the BI Environment and share the dataflow design with the ETL team.
• Involved in SSIS, SSRS, SSAS Roadmaps, Design and Delivery Strategies.
• Derive the Business SQL Scripts and Coordinate with the Management/Admin/ Development/ Release team to be in sync with the development outcome.
• Evaluate/ Define the Microsoft SSIS ETL Design.
• Evaluate/ Define the Microsoft SSIS SRS Design.
• Evaluate/ Define the Microsoft SSIS MDX/ Model/ SSAS Design.
• Evaluate/ Define Cognos (FM) Metadata Model OLTP Design.
• Evaluate/ Define Cognos (FM) Metadata Model OLAP (DMR) Design.
• Evaluate/ Define Cognos CAFÉ, SSAS for financial team.
• Generate Dynamic Data Dictionary to ensure to record the validation/ non-validations descriptions.
• Evaluate/ Define the Unit Test Checklist for Requirements/ Design & Development.
• Largely involved in defining ETL SQL’s and Worked with the interface team like other state agencies Medicaid, Job and Family Services.
• Address ETL/ Reports Performance issues.
• Evaluate & Define Data Governance activities.
• Involved in Daily Morning Scrum Stand ups & the Evening Show and Tell. Weekly two Work in Progress Meetings to update the status of the sprint task.
• Involved in defining DODD IT MODERNIZATION by evaluating the existing application portfolio and by tracking the open/ closed tickets.
• Involved in recommending the Line of Business-Critical Dataset visualization in Desktop Power BI for the top-level management during the peak hours.
• POC - Involved in transforming the structured dataset to Mongo DB and visualized data by using high-performance statistical computation and fast analytics Tableau and Power BI.
• Involved in coordinating the team and track down the task level to evaluate the PBI storyline with the development outcome and guide the team to stay on time delivery.
• Updating the management on teams estimate timelines and the agile progress report to overcome the unexpected surprises.

Environment: Sql Server, Sql Server Data Tools, Cognos, Tableau, TFS, Service Now