SUMMARY

• 9 years of experience in teh Information Technology field, with comprehensive hands - on expertise in data warehouse architecture, data modelling, analysis, design, development, problem solving, operations, performance tuning and technical support of Enterprise Data Warehouse (EDW) and Business Intelligence (BI) solutions using Operational Data Store(ODS), Data Warehouse (DW)/Data Mart (DM), ETL, OLAP applications on Unix platforms.
• Leading large-scale end-to-end application development including data ingestion from heterogeneous data sources including structured/unstructured data sources, various databases and modern cloud-based data sources.
• Comprehensive & in-depth experience in teh Pharmaceutical and Automotive industry with specialization and expertise in Commercial Sales and Marketing domain.
• Expert in providing strategic and advisory solutions to clients and designing end-to-end processes driving architecture, designing an application data model scalable to teh enterprise level and enforcing industry best technical design principals and data governance.
• Proficient in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling using Erwin and Microsoft Visio.
• Extensive experience in using Informatica Power Center 9.x/8.x Designer, Repository Manager, Workflow Manager, Workflow Monitor including performance tuning of Informatica transformations/mappings/sessions/workflows.
• Experience in using SQL, functions, triggers, complex joins, correlated sub-queries, aggregate functions, materialized views, indexing, and performance tuning teh same using explain plan using databases like Netezza and Oracle 11g.
• Experience in generating reports, dashboards and scorecards using Business Objects 4.0 Web Intelligence (WEBI).
• Experience in using scheduling tools like UC4 and Autosys.
• Experience in writing and automation of teh ETL processes using UNIX shell scripting.
• Experience in maintenance and support during QA, Integration Test, UAT, and Production support for Issues/Bug fixes/Defects.
• Excellent team player with very good communication skills and leadership qualities.
• Experience with coordinating and leading onsite-offshore development.

PROFESSIONAL EXPERIENCE

Confidential

Solution Architect

Responsibilities:

• Requirement Analysis - Gather business requirements from process owners and plan required CDM design by using IBM tools and methodologies
• Determine CDM Implementation plan, its optimal size and desired versions by using IBM ETL and Profiling tools.
• Based on Plan, identifying client critical workflows, interfaces between modules, strategizing object orientation methods, client’s manual processes such as DataStage Batch jobs, Data Warehouse Data Collection and converting into automation using E2E solutions.
• Design implementation - Executing structured plan using requirement analysis and implement with scale up capabilities.
• Performing data discovery using Information Analyzer and Data Studio. Designing and Developing DataStage batch jobs and sequences. Create data models and data pipelines to ingest data into IBM DB2 database.
• Developing data dictionary & data model changes as per business requirements and workflow changes using Data modelling and ETL techniques. Implementing custom templates for automation of Batch Jobs, Data flow, alerts, monitoring, reporting using DataStage Designer and Director tools.
• Evaluating architectural aspects of all applications using Standard template, DataStage Best practices, Co-hosting methods, Multiple Component on Single DB.
• Adhere to teh architecture standards set by teh client and implement solutions with industry best practices.
• Responsible in Monitoring Client solutions migrated from various sources, Process enhancement recommendations and reporting solutions
• Project Management and Governance
• Ensure all project governance artifacts exist and are maintained
• Maintain a project on-boarding package and process to ensure all team members are adequately on-boarded
• Conduct teh Project Rapid Start or related project startup activities.
• Manage teh engagement risks, issues and corresponding action plans
• Enhancement Lead for BI Commercial Data warehouse.
• Led teh development staff of 2 resources through a fast paced delivery schedule.
• Delivered DDD Replacement with IntegreChain 867 project under strict timelines.
• Worked with solution architects and business users to evaluate teh impact of source system changes and implement teh modifications.

Confidential

Application Specialist

Responsibilities:

• Application Lead supporting business critical data warehouses comprising of commercial data pertaining to Sales & Activity (CBI), Corporate Accounts (CADI) and Promotional Materials (SVS and PMM).
• Led teh support staff of 10 resources through a lean transformation effort that improved incident and enhancement backlog management, and instituted a process for continuous improvement.
• Support Quarterly Alignment and Targeting process from Data Warehouse and Reporting perspective.
• Proposed and implemented ticketing solution to multiple business departments.
• Working closely with teh business users to understand teh requirements and converting them into project level technical capabilities.

Confidential

Application Development Technical Lead

Responsibilities:

• Spearheaded development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures.
• Performed teh unit testing, system integration testing and assisted business users with acceptance testing.
• Managed automation of file processing as well as all ETL processes within a job workflow.
• Ensured data quality throughout entire ETL process.
• Ensured compliance with regulatory requirements for data transmission, storage, and data access including documentation, testing, and remediation.
• Managed Software Upgrade Testing effort of multiple IT platforms from Data warehouse application perspective.
• Designed and developed efficient Error Handling methods and implemented throughout teh mappings. Responsible for Data quality analysis to determine cleansing requirements.
• Lead a team of 3 resources to analyse, develop, build, and test Sample Activity data including Rep shipments.
• Held weekly internal status review with functional lead and project manager.
• Lead a team of 3 resources to integrate data from Veeva Vault to PMM data warehouse.
• Implemented complex design using HTTP and JAVA transformations in Informatica to pull records from Veeva Vault and load it to teh data warehouse.

Confidential

Application Operations Analyst

Responsibilities:

• Reduced manual effort by developing and automating data load jobs and job-plans on UC4 for CBI with savings of 40 hours per week.
• Used ETL methodology for all data loads and developed mapping specifications and transformation logic to implement business requirements.
• Solving environment amends by identifying and fixing teh problems that are occurring repeatedly in production area and various test environments.
• Developed technical understanding of how teh data flows from file to database, database to database, database to file and file to file.
• Analyzed business data requirements to produce relevant ETL architecture deliverables (source analysis, source to target mappings, ETL flows)
• Developed and deployed ETL job workflow in Informatica with reliable error/exception handling and rollback framework.
• Developed and designed reports using Business Objects - Web Intelligence.
• Developed and executed unit, system tests in development and integration environments.

TECHNICAL SKILLS

Languages: SQL, PL-SQL, UNIX shell scripting.

DWBI tools: Informatica, IBM DataStage, IBM Information Analyzer, IBM DB2, SAP Business Objects, Netezza, Oracle, UC4, Autosys, JIRA, and MS Suite.