SUMMARY

• Highly motivated and energetic, PMP & ITIL Certified Data Warehouse Solution Designer with 10+ years of experience.
• Drive and deliver End to End solution Design and Architecture of large scale Data Warehouse Systems and reporting applications.
• Expertise in Data Warehouse Architecture, analysis, design, development, problem solving, performance tuning and technical support of major Data Warehouses Applications.
• Provided effective Reporting Solutions (Qlikview Dashboards Architecture and Design) from Data Warehouse presentation layer.
• Excellent experience in BI Tools and technologies (Informatica Power Center 9.6/8.x., SQLs, and Unix/Linux Shell Scripting, Control M, Cognos TM1, Qlikview, Mainframe - Cobol, JCL, DB2,VSAM, SAS, Big Data).
• Expert skills in relational and dimensional data modelling combined with strong facilitation and business analysis skills.
• Excellent industry experience with Insurance and Banking (Mortgage banking) domains.
• Translate complex business requirements into scalable technical solutions meeting Data warehousing standards.
• Provide subject matter expertise to support reporting needs for the multiple functional areas.
• Owned and created solution designs, source to target mappings and data architecture documentation for complex information systems.
• Reduced system operational cost by 15% with innovations and best practices.
• Expertise in Project Management related activities, Team Leadership and Mentoring, and Onsite Offshore Coordination.
• Expert in troubleshooting and interfacing complex system with different kind of interfaces over multiple technologies.
• Established data architecture and BI best practices, standards and data models; recommended data warehouse and reporting performance-tuning techniques.
• Mobilized and directed BI professionals and offshore development team of 30+.
• Passionate about learning and implementing new technologies/ideas.

TECHNICAL SKILLS

Tools: Informatica Power Center, IBM DB2 Data Studio, TSO, ISPF, QMF, BMC,, File Aid, JES3, Control-M, Panvalet, HP Service Manager, Ultra Edit, Putty,Microsoft Office Suite, Cognos TM1, Qlikview

Databases: IBM DB2, DB2 Stored Procedure, VSAM

Languages: COBOL,PL/1,JCL,Python, Unix Shell Scripting, SAS

Operating Systems: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Data Warehouse Consultant

Responsibilities:

• Subject Matter Expert and Lead Data Warehouse/ BI Solution Designer for Federated Data Warehouse to provide end to end solution design for Integrated Auto (Quotes and Apps, Agreement and client data).
• Leading the Statement of Work to implement Big Data Hadoop concepts/solutions (HDFS) to existing Data Warehouse applications.
• Participated in the planning process alongside business partners, initiative teams, and component coordinators to identify the appropriate assets to meet business functionality and the high level design associated with the BI/DW portion.
• Responsible for developing Requirements Artifact Package, App Distribution (Data Flow) diagram.
• Worked closely with Data Architect to come up with Logical and Physical models, Source to target mapping, data dictionary, and Meta data.
• Responsible for developing Business Case Lifecycle framework which facilitated the end to end activities from a business idea through the development and implementation of the IT solution for auto and fire sales funnel.
• Created solution design which supported the Business Case Lifecycle and consisted of activities related to High Level Solution Analysis with Business Case Development, High Level Solution Design and Work Packaging. These activities supported and enabled solution development.
• Constructed BI solution designs and iterations to meet business functionality requirements, leverage data assets, and align to the data architecture direction.
• Defined iterations for moving through the BI/DW maturity stages to support both quick time-to-market for business functionality and enterprise consumption.
• Partnered with initiative and solution center technical teams to identify roadmap activities conductive to adopting the Business Intelligence Architecture.
• Constructed BI solution designs and iterations to meet business functionality requirements, leverage data assets, and align to the data architecture direction.
• Defined iterations for moving through the BI/DW maturity stages to support both quick time-to-market for business functionality and enterprise consumption.
• Partnered with initiative and solution center technical teams to identify roadmap activities conductive to adopting the Business Intelligence Architecture and advocates the appropriate use of State Farm’s architectural standards.
• Keeps abreast of new technologies and industry best design techniques and introduces them into the team’s design practices.
• Responsible for design/architecture deliverables which includes - Source to target mapping, Architecture Approach and Design, Organization and system processes, Business Owned Capabilities (Business, Functional, Non-functional, and support), Business Rules and Business Data Elements (Content), IT Solution and Role Authorization model, Business Context Diagram Business Event List, Service Dependency, Interaction Design along with service definition and operations, Integration Design - Integration with Products, Integration services to UI, Conceptual Architecture Model, Application Environment Design/architecture, UI specifications, assets and Prototype, Logical test and system topology, Logical Application Distribution.
• Subject Matter Expert and Lead Data Warehouse/ BI Solution Designer for Federated Data Warehouse to provide end to end solution design for Shoppers data.
• Constructed BI solution designs and iterations to meet business functionality requirements, leverage data assets, and align to the data architecture direction.
• Defined iterations for moving through the BI/DW maturity stages to support both quick time-to-market for business functionality and enterprise consumption.
• Partnered with initiative and solution center technical teams to identify roadmap activities conductive to adopting the Business Intelligence Architecture.
• Keeps abreast of new technologies and industry best design techniques and introduces them into the team’s design practices.
• Establishes partnerships with initiative leadership to foster strong communications and about the BI/DW design techniques.
• Responsible for developing Business Case Lifecycle framework which facilitated the end to end activities from a business idea through the development and implementation of the IT solution for auto and fire sales funnel.
• Created solution design which supported the Business Case Lifecycle and consisted of activities related to High Level Solution Analysis with Business Case Development, High Level Solution Design, and Work Packaging. These activities supported and enabled solution development.
• Subject Matter Expert and Lead Data Warehouse/ BI Solution Designer for Federated Data Warehouse to provide end to end solution design for Auto and Fire Sales Funnel.
• Responsible for developing Business Case Lifecycle framework which facilitated the end to end activities from a business idea through the development and implementation of the IT solution for auto and fire sales funnel.
• Created a flexible data model design that was scalable and reusable, while at the same time emphasizing performance and the enterprise’s business needs. Played an active role in the design of ETL processes to load data from source to staging, atomic and derived layers of DW.
• Responsible for developing and driving the roadmap for enterprise strategies including standardization and modernization of legacy environments, migration and operational optimization strategy.
• Translating business requirements into detailed technical architecture and design. Documenting all technical requirements and design technical solutions utilizing enterprise architecture standards.
• Implementing architectural designs while building solid relationships with stakeholders at all levels.
• Work closely with Strategic Resources, Planning and Analysis, Service Managers and Directors to achieve strategic goals (effective decision making capabilities using analytics data and reporting solutions on qlikview/Cognos TM1.).
• Defined iterations for moving through the BI/DW maturity stages to support both quick time-to-market for business functionality and enterprise consumption.
• Partnered with initiative and solution center technical teams to identify roadmap activities conductive to adopting the Business Intelligence Architecture (BIRA).

Confidential

Responsibilities:

• Subject Matter Expert and Lead Data Warehouse/ BI Solution Designer for Federated Data Warehouse to provide end to end solution design for Auto and Fire Sales Funnel.
• Provided end to end solution for complex data migration efforts (migration from Legacy system to modern technology) using BI tools (Informatica, Linux/Shell scripting, Cognos TM1 and Qlikview).
• Created source to target mapping.
• Analyzed complex applications built in SAS and migrated it to Linux/Informatica platform.
• Dimensional database design. Launched an initiative to redesign existing ETL and heavily snowflaked data warehouse into a more modern, functional, user friendly, star design and efficient SSIS-driven ETL utilizing parallelism and in memory transformations, architected reporting solutions involving a variety of data sources, including DB2, XML, CSV and Flat files.
• Responsible for developing Requirements Artifact Package, App Distribution (Data Flow) diagram.
• Worked closely with Data Architect to come up with Logical and Physical models, Source to target mapping, data dictionary, and Meta data.
• Responsible for developing Business Case Lifecycle framework which facilitated the end to end activities from a business idea through the development and implementation of the IT solution for auto and fire sales funnel.
• Defined iterations for moving through the BI/DW maturity stages to support both quick time-to-market for business functionality and enterprise consumption.
• Partnered with initiative and solution center technical teams to identify roadmap activities conductive to adopting the Business Intelligence Architecture (BIRA).
• Subject Matter Expert and Lead Data Warehouse/ BI Architect for Federated Data Warehouse for Auto and Fire lines of businesses.
• Provided end to end solution for complex data migration efforts (migration from Legacy system to modern technology) using BI tools (Informatica, Linux/Shell scripting, Cognos TM1 and Qlikview).
• Analyzed complex applications built in SAS and migrated it to Linux/Informatica platform.
• Dimensional database design. Launched an initiative to redesign existing ETL and heavily snowflaked data warehouse into a more modern, functional, user friendly, star design and efficient SSIS-driven ETL utilizing parallelism and in memory transformations, architected reporting solutions involving a variety of data sources, including DB2, XML, CSV and Flat files.
• Leading and mentoring 17 offshore resources and 4 onshore resources as a service lead.
• Created a flexible data model design that was scalable and reusable, while at the same time emphasizing performance and the enterprise’s business needs. Played an active role in the design of ETL processes to load data from source to staging, atomic and derived layers of DW.
• Responsible for developing and driving the roadmap for enterprise strategies including standardization and modernization of legacy environments, migration and operational optimization strategy.Translating business requirements into detailed technical architecture and design. Documenting all technical requirements and design technical solutions utilizing enterprise architecture standards.
• Implementing architectural designs while building solid relationships with stakeholders at all levels.
• Closely work with client to understand the entire State Farm’s business and system architecture.
• Analyze the ETL and Mainframe processes, create low level design documents and work towards the performance tuning.
• Provide production support for the applications after analyzing and documenting.
• Build and train the team to support the applications.
• Involved in studying the business requirement develops the mapping specifications from the business requirements and the data modelling.
• Documented business requirements, discussed issues to be resolved and translated user input into ETL design documents.
• Design and develop ETL mappings, packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Extracted data from Relational Tables and Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Expression, XML, Normalizer and Update Strategy.
• Extensively worked on Informatica performance tuning. Used partitioning techniques at the session level to improve the performance.
• Worked with MQTs designs.
• Leading the design team for mainframe to Informatica migration efforts.

Confidential

System Analyst, Tech and Module Lead

Responsibilities:

• Analyzed the specifications provided by the client.
• Identified the areas requiring modification /enhancement.
• Prepared design documents.
• Involved in the walk through phases for each module prior to development.
• Performed Impact Analysis, Coding, Testing and Reviews.
• Reviewed and promoted code changes.
• Delivered the modules for Pre-Quality and Quality testing.
• Provided application production support.
• Worked towards end to end completion (Documentation, Coding, Testing and Production support) of various modules.