SUMMARY

• Over 10 years of experience in data analysis, data modeling, data solution architecture, requirement gathering/analysis and program management.
• Experienced in developing Conceptual, Logical models and Physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERwin and ER/Studio.
• Proficient in both in Bill Inmon and Ralph Kimball methodology of Data Warehouse/Business Intelligence design and architecture
• Modelled 3NF normalized schema to support Enterprise Data Warehouse and demoralized Star/Snowflake schema to support data marts
• Experienced in Data - Extraction, Transformation, Loading (ETL) techniques and produced quality Source To Target (STM) mapping and functional specifications
• Experience with ETL Tools like Informatica and SSIS, Data Governance Tools like SQL Server Master Data Services (MDS), SQL Server Data Quality Service (DQS)
• Strong experience in Project Management using Waterfall/PMBoK and Agile/Scrum methodology with large multi-shore team and P&L accountability
• Well versed in conducting Joint Application Design (JAD), facilitated workshops and brainstorming sessions, Gap analysis, Cost benefit and ROI analysis.
• Experienced in designing metadata based extensible architecture. Hands on experience in T-SQL, Procedures, performance tuning and optimization for business logic implementation.
• Strong customer focus, logical and analytical problem solving skills and drive for the results ensuring successful implementation and support for the projects

TECHNICAL SKILLS

Data Modeling Tools: ERwin, ER/Studio

Relational Data Tools: SQL Server 2005/2008/2012 , SQL Azure/PaaS, Oracle 8i, IBM DB2

Big Data Tools: SQL Server Parallel Data Warehouse (PDW), Hadoop

Project Management: Office 2013, Confidential Project 2013, Confidential Visio, Confidential SharePoint

Reporting Tools: SQL Server Reporting Services (SSRS), Siebel Analytics 7

OLAP Tools: SQL Server Analysis Services (SSAS)

ETL Tools: SQL Server Integration Services (SSIS) and Informatica 9.x

Programming Languages: PL/SQL, T-SQL, HTML

Operating Systems: Windows 7/8, Windows Server 2008/2012, Public Azure/IaaS, UNIX.

Enterprise Solutions: Siebel 6/7, Confidential Dynamics CRM 6

Domains: Legal, Finance, Sales, Services/Call Center

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Senior Data Modeler/Data Solution Architect

Responsibilities:

• Actively participated in requirements identification efforts using brainstorming, facilitated workshop techniques to ensure a holistic understanding of the business goals
• Translated sponsor needs into a formal requirements document by ensuring all requirements are clear, concise, agreeable
• Created the reverse engineered logical model for source systems and legacy reporting and analytics system using ER/Studio
• Performed source data analysis thru the data profiling technique using SQL Server Management Studio
• Modeled the 3NF logical model for Factory and denormalized logical model for data mart using ER/Studio
• Analyzed the business reporting requirements and produced Source To Target (STM) mappings
• Created the functional specification documents covering latency/freshness, security, privacy and retention requirements and reviewed the all the artifacts with business and engineering teams
• Involved in the design and architecture of extensible metadata based self-service ETL platform
• Identified master data entities and proposed the migration of entities to SQL Server Master Data Services
• Investigated the data quality issues in Global Migration data and proposed the options to address it using SQL Server Data Quality Services
• Created the reports and built the dashboards using Power BI suite (Power Query, Power Pivot, Power View and Power Map)
• Assisted the project team troubleshoot business problems and invested the time to identify root causes for the data related errors with recommendation for corrective actions

Environment: ER/Studio, Windows Server 2012, Public Azure/IaaS, SQL Server 2012, SQL PaaS, SSIS, SSAS, SSRS, SQL MDS, SQL DQS, Power BI

Confidential

Senior Data Modeler/Data Solution Architect

Responsibilities:

• Worked with SME’s and other stakeholders to identify core entities, attributes and relationships to build application specific Conceptual, Logical Data Models.
• Modeled the application 3NF logical model for Factory and denormalized model for data mart using ER/Studio
• Used Informatica Analyst and Developer tools to perform extensive data profiling of source systems
• Performed detailed data and system analysis of legacy applications to learn the Budgeting and Forecasting process, which helped in enhancing and establishing credibility with business
• Collaborated with over 23 teams including Engineering, Solution Delivery, Service Engineering, Business Operations while design, execution and delivery of the program
• Interfaced with data modelers from rest of the organization and contributed to Enterprise Conceptual Data Model
• Conceived the extensible metadata based feed file and channel incentive processing engine which reduced the onboarding time, manual effort which saved over $500,000 per year
• Designed the Operational Data Store (ODS) for Budgeting and Forecasting process using patented near-real time BI reporting capability and reduced the data latency to 15 minutes from more than 24 hours
• Analyzed the business requirements and produced Source To Target (STM) mappings, Data Flow/Architecture diagrams
• Led the team of 6 Analysts and Technical Program Managers and produced the functional specifications covering various data/system interfaces, data latency and reporting, security and data publishing requirements
• Investigated production issues, identified root causes and proposed the options to resolve the issues
• Implemented Informatica IDQ tool to validate and certify the feed partner flat files prior to the actual processing in the production environment.
• Worked in multiple finance projects at a given time supporting Budgeting and Forecasting end to end system needs

Environment: ERwin, ER/Studio, Windows Server 2008/2012, SQL Server 2008/2012, Database Mirroring, Informatica IDQ 9.x, Confidential SharePoint Server, Confidential Reporting and Analytics (MSRA)

Confidential

Data Modeler/Systems Analyst

Responsibilities:

• Performed extensive data and system analysis of legacy planning hierarchy management system
• Performed data modeling and systems analysis for organizational wide implementation of Planning hierarchy using SQL Server Master Data Services (MDS)
• Revamped MS Sales data processing to reflect the changes, reducing the manual effort and improving the data quality
• Interfaced with multiple teams and performed detailed data analysis and functional specifications
• Improved the report refresh time and optimized the server performance by 30% by implementing and extending custom SQL Analysis Service Load Balancing capability
• Performed multiple design changes and implementation to MS Sales Core Factory and Data Mart processing
• Maintained and enforced data architecture/administration standards, as well as standardization of column name abbreviations, domains and attributes.
• Performed the reverse engineering and created the MS Sales physical data model for the consumption of the downstream reporting systems.
• Led the capacity planning, scoping related discussion with business and drove the multiple SOX complaint releases to the production
• Evaluated, prototyped and evangelized the 3rd party data mapping tool to store the repository of STMs saving the estimated $250,000 in data lineage and impact analysis cost per year.

Environment: ERwin, Windows Server 2008, SQL Server 2008, SQL Log Shipping, SSAS, Confidential SharePoint Server, Confidential Reporting and Analytics (MSRA)

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Chosen to serve as Sales CRM data SME to work with business and solution management teams during requirement analysis to create quality of requirements
• Actively participated in brainstorming, facilitated workshops to identify the requirements to ensure a holistic understanding of the business goals
• Identified and defined the entities, relationships and attributes in the data model as per the specifications in ERwin after analyzing the database systems currently in use.
• Created the 3NF normalized logical model for integrated Sales Subject Area
• Established and enforced enterprise data warehouse architecture standards, including entity structures, naming conventions, key definition and generation, optimization, etc.
• Performed data analysis and carefully produced the model integrating the Sales CRM data with organization-wide master data store and finance data sets
• Modeled the Type 2 Hybrid Slowly Changed Dimension (SCD) to store Organizations associated with Opportunities supporting the historical data reporting needs
• Developed the Source To Target Mappings (STM) for Opportunity Management and led the effort pertaining to Sales Subject Area to centralize the common business rules in the Enterprise Data Warehouse (EDW)
• Developed Data Mapping, transformation and cleansing rules for the source data in the staging database
• Created the Data Governance dashboards providing the level data freshness and data quality to the business users
• Created action plans to track identified open issues and action items related to the project.
• Worked with the engineering teams to obtain the estimates, creating the schedule and project plans

Environment: ERwin, Windows Server 2008, SQL Server 2008, SSIS, SSAS, Confidential SharePoint Server, Confidential Reporting and Analytics (MSRA)

Confidential

Data Analyst/Systems Analyst

Responsibilities:

• Actively participated in requirements identification efforts. Helped the Solution Manager to translate business needs into a formal requirements document by ensuring all requirements are clear and concise.
• Performed analysis of Key Performance Indicators (KPI) and identified source system, table, columns and related aggregations and rules
• Performed gap analysis between Standard Report requirements v/s MSSales Revenue data mart/cube
• Created the source to target spread sheets, functional specifications, documenting the business logic for every KPI along with threshold and target needs, data integration and security aspects
• Enforced referential integrity in the data model for the consistent relationship between tables and efficient database design.
• Involved in the design and development of Scorecards platform by acquiring the data from various source system SSAS cubes
• Collaborated with engineering teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.

Environment: ERwin, SQL Server 2008, SSAS, Confidential SharePoint Server, Confidential Reporting and Analytics (MSRA)

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Performed source system analysis for MSSales, Siebel CRM, xCAT, Feedstore etc. by performing extensive data profiling
• Identified and defined the core entities, attributes and relationships in the data model as per the specifications in ERwin
• Created application specific 3NF logical data model using ERwin data modeler tool
• Acted as liaison between business and engineering teams and converted the business requirements into functional specifications
• Performed the gap analysis between existing legacy application v/s re-architected new solution to identify the missing functionalities
• Delivered high quality Source to Target mappings, data flow diagrams, data dictionary documents providing details of the design
• Investigated the data issues during the development and stabilization phases of project to identify the root causes and proposed the solutions.
• Led the team of Data Analysts and Technical Program Managers across the geography. Took on additional responsibility of offshore-onshore coordination
• Worked with engineering teams to obtain efforts for the scope of the release and created the project schedule
• Drove the Status and Change Control Board meetings and communication with Product Management teams

Environment: ERwin, Windows Server 2003/2008, SQL Server 2005, SSIS, SSAS, SSRS, Siebel Analytics 7.8, Confidential SharePoint Server, ASP.NET

Confidential

Data Analyst/Siebel Analytics Developer

Responsibilities:

• Identified the core Siebel entities, attributes and relationships and modeled Star and Snow Flake Schema for Sales Pipeline reporting eliminating the data duplication issues existed in the legacy systems
• Created the Source To Target mappings and Functional Specification documentations
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Maintained metadata, naming standards and data mart standards.
• Assisted ETL teams to configure Informatica Power Center mappings to acquire, integrated and load the Siebel CRM data with Feedstore store data into data marts
• Configured Siebel Analytics repository for various Subject Areas of Siebel Sales and Call Center related data and implemented the data security rules
• Performed impact assessment of the upstream source system releases and annual taxonomy changes
• Integrated the Enterprise Reporting Solution with Siebel 7 and enabled windows single-sign on
• Expedited the retirement of legacy data publishing system by collaborating and assisting downstream systems in migration to Siebel Data Store (SDS)
• Performed troubleshooting of data issues occurred due to Siebel Upgrade but surfaced in the reporting environment by working closely with Siebel OLTP team
• Created the Enterprise Reporting Dashboard providing Opportunities and Pipeline related information to the business users

Environment: ERwin, Windows Server 2003, SQL Server 2005, Informatica 6.3, Siebel 7.7, Siebel Analytics 7.7, DTS