SUMMARY

• 10+ years of experience as Data Architect, Business Intelligence & Analytics professional - delivering world class solutions in the area of information/software architecture, enterprise data management, multi-entity Data Warehouse design; spanning across several industries and functional domains such as Retail and Pharmaceuticals; providing effective leadership to heterogeneous team of engineers and business-stakeholders; providing exponential increases in throughput, accuracy and profitability.
• Outstanding ability to define business functions as generalized metadata, enabling systems to provide long-term stability and reliability; vast capacity for absorbing and synthesizing a wealth of detail into a unified, coherent vision and communicating that vision to a diverse audience.
• Hands-on experience in implementing enterprise data management processes, decision support system, strategic and tactical data governance framework, metadata repositories and data quality improvement platforms for Pharmaceutical clients.
• Thoroughly conversant and practitioner of both theoretical and practical concepts of data architecture, data lake, data mining, large-scale data modeling and business requirements gathering in the functional domain of Health Care Analytics.
• Implemented Big Data Solution Architecture for advanced analysis and exploration of data which produced insightful stories and were accepted as actionable strategies for businesses.
• Designed Enterprise architecture used for data aggregation, metrics generation and data retention by Life Science and Pharmaceutical clients.
• Implemented ETL (Extract, Transformation and Load) in large scale data aggregation project to accomplish performance improvement for large amount of data load; by using latest design methodologies and data modeling techniques to support critical business functions e.g. technical audits, reporting and creating dashboards of critical KPI-s such as activity monitoring, market share updates, sales trends etc. built for clients in Life Science and Pharmaceutical industries.
• Integrated structured, semi-structured and unstructured data in a large data lake for Life Science and Pharmaceutical industry.
• Planned, estimated managed and executed critical, multi-million dollar valued simultaneously running projects by using various SDLC processes and methodologies such as Waterfall, Agile etc.
• Provided leadership and guidance to a team of Software Architects, Business Analysts and Data Scientists and helped to achieve desired goal of the organization by upholding values of corporate governance and professionalism.
• Demonstrated thought-leadership in data governance, analytics and business intelligence by building practice assets and, by articulating responses to RFP.
• Managed end-to-end data warehousing projects by handling various tasks including requirements gathering, data profiling, data modeling, technical specifications design, development and implementation.
• Actively involved in Technical Requirement Assessments, Estimations and RFPs along with Client Management engagements for multinational companies.
• Designed and defined a unified enterprise data warehouse with conformed dimensions and following best practices of Kimball involving roles where data analysis, data assessment, data profiling, data transformation, data reconciliation, data improvement, data monitoring, or data presentation drove increased client satisfaction scores and higher adoption of products and services.
• Implemented multiple Performance Tuning activities, which improved the Database and ETL performance significantly
• Evangelist for BI - protect, support, expose and share with others to get more usage and value of the data and help others turn it into knowledge and insight.

TECHNICAL SKILLS

• Informatica PowerCENTER
• Informatica DATA QUALITY (IDQ)
• Informatica Master Data Management
• Teradata Tool
• Python
• Tableau
• Teradata
• DB2
• Oracle EXADATA
• Microsoft SQL server Database
• ER-Studio Modeling Tool
• Microsoft Visio
• ERWIN Modeling Tool
• SAP Business Objects Reporting Tool
• Windows Server OS
• Unix/Linux
• Structured Query Language
• Unix Shell Scripting
• Microsoft Office Suite Advanced Level
• Big Data with Hadoop Architecture HDFS, NoSQL, HBase
• MapReduce, Pig,Hive,Processing Distributed Data with Apache Spark,Oozie etc
• R Programming
• HP QC
• Tidal and Autosys Scheduling tool

PROFESSIONAL EXPERIENCE

Data Quality Architect

Confidential

Responsibilities:

• Working as data quality Architect for SAP implementation.
• Provided a holistic approach to managing data quality across the enterprise with the best practice and architecture of Data Quality for SAP implementation and Migration.
• On boarded the business users to Informatica Data quality program and created a true data-driven environment that supports better business decision making regardless of your data’s size, format, or platform which delivers authoritative, trusted data to all stakeholders in the projects.
• Providing leadership to client teams on using Informatica Data Quality (IDQ) to perform data quality assessment, metrics, building data quality rules.
• Proposed data quality Dashboard using Informatica Data Quality
• Provided roadmap plan for implementation of data profiling, creating score cards, creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
• Expertise in analyzing trend charts from score cards to analyze the threshold which is to be considered in further development
• Designed IDQ process for data validation
• Working Informatica SME for IBM Teva SAP implementation project.
• Working closely with client data lead in providing development statutes, issues resolution, and advice on best practices.

Data Quality Architect

Confidential

Responsibilities:

• Worked as data quality Architect and focusing on improving source systems data for SAP implementation.
• Proposed data quality Dashboard using Informatica Data Quality
• Design and developed ETL process to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Worked on populating the SAP objects like Customer Master, Material Master, Vendor Master etc.
• Designed IDQ process for data validation
• Worked on Data integration from various sources like JDE-AUTO, JDE-IND, Marine, Vessels etc. into SAP
• Created the load readiness reports (LRR) to load into SAP.
• Created the SAP lookup tables for cross reference in Oracle.
• Configured Power Connect for SAP and maintained sap.ini file entries.
• Retrieved data from SAP ECC and installed/configured ABAP code.
• Created the Sap ABAP data dictionaries and mapped underlying relational tables and views.
• Created SAP ABAP data classes and indexes.
• Worked with transparent and pooled tables of SAP ABAP
• Involved in sizing of the integration tool for historical data, data archiving strategy, cache sizes calculations on the server etc.
• Providing architectural and design leadership across several cross-functional development teams, as well as working closely with other architects and project management team.

Information Integration Architect

Confidential

Responsibilities:

• Worked as an Integration Architect and engaged with Arconic to perform a roadmap focusing on CRM organization strategy.
• Conducted workshop with various Arconic leaders to discuss their challenges with regards to business processes, tools, technical systems and change management.
• Identified similarities and differences across the regions and business units and to achieve a better understanding of the current state CRM and systems landscape.
• Established Data Integration Structure and recommendation to maximize Arconic’s use of Salesforce
• Provided the blueprint of Reference Architecture Data Integration model followed by Prioritized and Phased Information Flow, Integration Pattern, Tool Recommendations, Data Governance, Data Model, Master Data Management, Data Quality and Enrichment
• Delivered a Blueprint Report of Findings outlining how Arconic can maximize and capitalize on existing business systems and processes, while incorporating new applications, processes, functionality and integrations, while phasing out deprecated systems.

Information Integration Architect

Confidential

Responsibilities:

• Worked as an Integration Architect in Retail domain in the field of Development & Implementation of New product hierarchy for Oracle Retail Integration.
• Managed the conversion team of ETL developers, database developers by providing architectural solutions for databases, canonical models and orchestration objects for Interfaces on the presentation layer for data conversion efforts.
• Architected and maintained Erwin logical and physical data models of the new product hierarchy.
• Architected Conversion framework and strategy for new product hierarchy from legacy system.
• Designed the Score card, reconciled Reporting solutions for the client and communicated the data conversion scope, integrated with other applications and designed strategy for successfully converting the legacy data to the new product hierarchy for Oracle Retail.
• Initiated Design of ETL architecture solution from functional requirements which is required to be analyzed as a part of the quality assessment process.
• Provided the technical designs for conversion of legacy data to Oracle Retail system.
• Analyzed the source data to determine accuracy and completeness of the source data which would clarify the structure, relationship, content and derivation rules of data.
• Identified the data patterns and designing the unstructured data into required structured data for Oracle Retail system using Informatica data quality tool.
• Helped the client to identify the ETL infrastructure and its limitations.
• Worked as an ETL Informatica and Data Quality SME for the conversion program to implement Oracle Retail system.
• Provided the best practices of Informatica for implementing the data conversion.
• Responsible for development and implementation of ETL Informatica interface.
• Provided architectural and design leadership across several cross-functional development teams, as well as working closely with other architects and project management team.

Data Warehouse Integration Architect

Confidential

Responsibilities:

• Worked as an Information Integration Architect and consultant in Life Science Sales and Marketing domain in the field of Development & implementation of Business Intelligence and Data Warehouse to stabilize the Commercial Data Warehouse.
• Architected dimensionally secured SSAS cubes to house CAST data along targets, Professionals, Specialties, Jobs and Calendar for all call, target, and Trx and NRx metrics from IMS data. Provided Drill through functionality, to accommodate “what if” scenarios.
• Offered strong combination of business and technical expertise, ensuring steadfast project management from development of initial concept through design and implementation of ETL solutions.
• Provided architectural and design leadership across several cross-functional development teams, as well as work closely with other architects and project management.
• Responsible for all phases of Project Management for accomplishing multiple deliveries.
• Provided rationalization of CDW environment through business and technical analysis to efficiently organize, optimize, cleanse and structure data to meet internal and external business needs.
• Worked on requirement gathering/analysis with the client to bring the different Sales strategic business information of different geographical regions under the single point of Data warehouse.
• Worked with multiple teams to integrate data from multiple source systems like SAP, Siebel, DCH, MARS etc. and third-party vendors like IMS into a Single Data Warehouse system.
• Designed the Architecture of Financial Reporting for the client and provided SAS datasets to the third-party vendor for budget analysis.
• Analyzed the source data to determine accuracy and completeness of the source data which clarified the structure, relationship, content and derivation rules of data.
• Proposed New Customer Account Master Universe of Business Accounts using MDM solution.
• Responsible for Project Planning and coordinating the Oracle Exadata Migration activity.
• Acting as a single of point of contact for any Informatica, Oracle and ETL related issues for multiple teams.
• Implemented multiple Performance Tuning activities, which improved the Database and ETL performance significantly.
• Implemented logical and physical data models of ETL Design solutions using ER/ Studio Tool.
• Completed several technical assessments as per the change requirements of Business.
• Creating, reviewing and providing recommendations on technical procedures, architecture documentation, and engineering decisions.
• Cross-trained other BI team members and groom them with projects and mentoring to build depth and expertise of the team.

Data Warehouse Integration Architect

Confidential

Responsibilities:

• Designed the integration of business entity data to implement MDM hub architecture for HCM Data warehouse.
• Evaluated current data warehouse/ETL environment for implementation of Customer Master (MDM) capability and provided gap assessment.
• Worked with Enterprise Architecture Team to find the gaps and challenges in the evolving commercial model (Symphony) that met the overall enterprise architecture requirements.
• Initiated Design of ETL architecture solution from already existing ETL processes which were required to be analyzed as a part of the quality assessments.
• Responsible for Leading the ETL, Data Quality solutions.
• Implemented ETL solution for 34 different source systems which provided the feeds to a Next Generation HCM model to create effective Customer Master Information.
• Worked as the single of point of contact of client engagement in the domain of Informatica, Oracle and ETL issues for the team.
• Worked as an Expert Designer and developer in Informatica Power Center ETL, IDQ Data Quality Tool and mentored the Team with the development modules.
• Overseen activities for all tasks in Project from planning to delivery and sustaining support to ensure that projects meet established business objectives, time and budget constraints.
• Worked as a Designer/Developer/SME for ETL Implementation for Master Customer Data Management.
• Reverse Engineered ETL Database into Physical Data Models using ER/ Studio Tool.
• Assessed the Source to Target Mappings for reviewing the existing code and data analysis.
• Created Data Flow Diagrams for ETL processes scheduled to run on a daily basis.
• Performed Data Quality assessment to know the hard-coded values and records rejected and reference data.
• Developed Data Lineage Reports in Metadata Manager along with performing the metadata profiling on HCM data.
• Delivered multiple modules on time with high precision and received accolades and awards from the client management team.
• Worked on Performance tuning complex queries, optimizing Informatica workflows.
• Responsible for working with developers to assure design and implementation conforms to internal standards, makes use of best practices and performs well.

Lead ETL Designer

Confidential

Responsibilities:

• Worked as an ETL Designer, ETL Developer/SME for Activity Reporting Area. Worked as the First Onsite Coordinator from Confidential who was responsible to setup the entire Production Support team for Confidential .
• Coordinated with the Client to accomplish multiple deliveries.
• Responsible for new requirement analysis and changes of Activity reporting solutions and Dashboard.
• Completed several Technical Assessments for any kind of changes required by Business.
• Worked as Team Lead for Activity Dashboard and Market Share dashboard. Apart from that, designed the ETL and data mart. Successfully delivered the modules on time with multiple iterative changes requested by the Business.
• Expert in Informatica Data Quality Tool. Used it extensively to profile the heterogeneous sources for data quality trend analysis and apply the Rules to standardize the source data for processing the Master Data.
• Worked as a Data Modeler and Designer for Coaching Reporting Area.
• Was the single of point of contact for any Informatica, Teradata and ETL related issues and queries for the team.
• Implemented multiple Performance Tuning activities, which improved the ETL performance significantly.
• Implemented multiple Deployments on Production on time.
• Worked as the Production Support Lead and was responsible for planning the work distribution among team members.
• Understood the Confidential - Confidential production support agreement.
• Structured the daily and weekly Status Report which was approved by business. Production support team sends them till date.
• Successfully rolled out Activity and Sales solution on production and business started using new BI application.
• Mentored the offshore team regarding the Confidential change control application and ISM application.
• Responsible for Siperian MDM Hub solution and its jobs.

Senior ETL Designer

Confidential

Responsibilities:

• Worked on multiple modules like Essbase Cube, Post Audit Release, and Tax Data Retention & Reporting for the client.
• Worked with the Finance team and analyzed data through multiple data dimensions to compare both budget and actual information with data in Matrix reporting using Essbase cube.
• Provided phased releases of enhancements that enabled Post Audit to save time, save resources, and improve quality.
• Responsible for tuning complex queries and redirecting data access to data available in Teradata databases.
• Worked with multiple teams to reduce the current and future tax payments by increasing availability and accuracy of information and data to support Sales & Use Tax audits and compliance support.
• Worked on Informatica solutions which electronically retains Sales data & uses Tax sensitive data in the Enterprise Data Warehouse/Tax Data Universe for the required length of time (7 years) and provides the necessary reporting capabilities to support audit defense.
• Built a reusable component using BTEQ and KSH scripts and implemented using Maestro.
• Worked in this project as a Teradata Developer to build TPT scripts to extract the data and ksh Scripts to automate the process.
• Used Informatica solutions to automate the entire process.
• Built sftp ksh scripts, different ksh scripts which automated the module.
• Worked as an Informatica Developer as well as a Teradata Developer to build BTEQ scripts and FLOAD Scripts.
• Implemented different data quality checks using Informatica.
• Proposed innovative design solutions to automate the entire process.
• Reduced the total time of data extraction from the oracle source table with performance tuning.
• Implemented scripts for capturing delta records from the source table using Informatica mapping successfully.
• Exposure to the business concepts and modules of Confidential during implementation of the project.

ETL Developer

Confidential

Responsibilities:

• Worked as an ETL Developer and helped to design the Warehouse using snowflake schema.
• Designed and configured Informatica 7.1.
• Worked on the network configuration for MS-SQL 2005, Informatica and Business Objects to work as a centralized system.
• Worked on the complete solution which consisted of various stages like designing or building the Data Warehouse, configuring ETL process to load the data into the Data warehouse and Building the Universe in BO to generate the reports for Analysis.
• Analyzed and implemented the asset building capability on Retail Domain.