SUMMARY:

• 18+ years of Information Technology in global (On - Shore & Off-Shore Model), cross-functional & multiple projectized environments for Integration Architecture/Data Warehousing, Software Development and Technology Projects.
• Decade plus Technology experience & Knowledge in Telecommunications, FMCG/Marketing, Manufacturing, Biotechnology/Pharmaceuticals, Finance/Banking/ Insurance, Utilities, Government, Oil & Gas and Security System Integration.
• Ten Plus (10+) years of IT experience in leading Denodo-Informatica-Pentaho Reporting Analytics, Python, OpenR, C#AutoBOT- Development work, Functional Specifications, Design and Implementation of multiple integrated Applications under various hardware and software platforms, OLAP, MIS and OLTP Systems. Worked in different capacities as Data Modeler, Developer, Data Designer, Onsite Coordinator, Project Lead, Team Lead, Module Leader, Tech Lead and programmer in varied data warehousing environments.
• Extensive experience with Data Modeling experience using Luis.ai, Erwin Modeling fior Natural language processing(NLP), Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data SQL modeling & querying skills.
• Excellent working experience with ChatBOT's, Data Virtualization, Integration, Warehousing/ Business intelligence tools using AutoBOT framework, Denodo, Infomatica, Pentaho in data extraction, data quality, data governance, data integration/blending, mining, rounding, analytics, virtualization, reporting, presentation among other core data processing techniques.
• Architected and Created reusable code,mapplets,cubes, etc used by multiple team in multiple BI/DW projects.
• Used different Informatica ETL & Pentaho analytic Cubes, real-time reporting in an efficient manner and as per requirement to gain maximum mileage for deliverables.
• Designed and Developed the Audit Control Components of the Project from both a Source/Target, Traceability and Reporting perspectives.
• Developed and worked with Database, Flat File, Stored Procedures, Views, Packages, Unix & Java Scripts.
• Multiple years of experience in working with dynamic technical professionals/large teams, subsequently creating maps, analytics in Informatica, Pentaho. Interpreting maps in Informatica for ETL map coding/data integration into Pentaho.
• Responsibilities included Project data consolidation, evaluate multiple technology to create BI/DW road-map, strategies, Bottom line responsibility for project execution, ensure project is executed in compliance with the SLA’s and Client and internal processes, Status reporting and issue resolution, conduct process audits, do root cause analysis and apply knowledge to improve productivity and quality.
• Conceptualized, Created and worked with all Data Warehousing documentation relating to New Proposals, Solutions, Design, Development, QA, Change and Production
• Twelve Plus (12+) years of IT experience in Feasibility studies, Scope Definition, Business Requirements Gathering, Business Process Analysis, Estimation, Functional Specifications, Design, Development and Implementation of end-to-end solution Architecture, Data warehousing (DW) Applications under various hardware and software platforms using OLAP, MIS and OLTP (Operational Systems).

TECHNICAL SKILLS:

• Hands on Techno-Functional Data Integration ETL Development and working extensively in developing & working with Executives, Managers, Contracting Services, Operations Center, data architect, business analyst, trainer, data quality analyst, decision support developer, DBA and ETL Developers.
• Responsible for Team Development of new Informatica mappings and workflows, Pentaho to pre-process Inbound Feed Data to Staging, EDW and Data Mart and subsequently to OutBound Client Feeds/Reports.
• Architected, Defined & Designed ETL mappings and workflows on Individual and Collective requirements.
• Developed ETL (Extract, Transformation, Load) processes on both Teradata, DB2 and Oracle using RDBMS utilities such as Multiload, Fast Load, Fastexport,BulkLoad.
• Worked with Shell scripting Control files in informatica for Oracle and Teradata for Informatica Variable Sessions.
• Created creative approach and technical solution to problems related to extracting Data from an EDW.
• Extensively used Pentaho & Informatica to create and modify source and target definitions, mappings, transformations, connections, etc.
• Analyzed, Designed, interfacing and developing Customer Dimensions, Provider Profiles, Claim/s display from a EDW, Data Mart and Reporting perspective within Pentaho 6.0, Cognos 7.4 & Informatica 9.6/8.5
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for extract feeds in efficient manner.
• Extensive Unix Scripting to Schedule Jobs, Encrypt Feeds, CatchUp on missed/failed Jobs in Production, Etc.
• Ten Plus (10+) years of IT experience in working on Multi-Million Dollar Integration Data Modeling/Architecture BI Practice Projects with global teams.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business need
• Fine-tuned existing Pentaho analytics & Informatica mappings for Performance Optimization.
• Customized data by adding calculations, summaries and functions.
• Worked with Quality Analysis Team, Created Test Cases and Performed Unit testing, integration testing and validated the data including thorough usage of Mercury Test Director.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Created tasks, workflows and work lets using workflow manager
• Used the Informatica command line utility pmcmd to schedule and control sessions and batches.
• Involved in identifying bugs in existing pentaho mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs
• Fine-tuned existing Informatica mappings for Performance Optimization
• Handled Incremental loading using persistent mapping variables
• Performed Repository Administration tasks (Creating Repositories, Users, Assigning privileges, creating backups and recovery)
• Customized data by adding calculations, summaries and functions.
• Utilized asset management, social analytics applications for central analysis and decision-support platform to cover asset classes and instrument types. This included intuitive position analysis and investment-simulation capabilities, with risk and performance metrics for simulations and strategies.
• Twelve plus (12+) years of strong BI & Datawarehousing experience in building and managing various data warehousing/data marts using products such as PowerCenter, PowerMart, PowerConnect, Expertise with Informatica 9.X/ 8.5/8.1/7.1/7.0/6.1/6.2.1/5.1/4.7/1.7 , PowerConnect tools for SAP/Mainframes/Siebel/Sybase, PowerAnalyzer, Metadata Reporter, Metadata Exchange for Data models, Pentaho, Hadoop, HBase, Hive, Autosys, Control M.
• Excellent working experience with Business intelligence reporting tools using Siebel Analytics, Cognos Series 7.0/6.0 and Business Objects XI/ 6.5/6.0/5.0/3.0 , Crystal Reports, Pentaho, Big Data, Hadoop, Qlikview, SAS, BO Developer Suite 6.0/5.0, MetaData Reporter.
• Experience in various ETL Architecture, Design & Development projects including testing, and production support teams in the process of developing and managing the enterprise data warehouse (EDW), MPP Data Stores, DM, finance data warehouse (FDW). 24/7 production support.
• Nine plus (9+) years of strong Data warehousing experience in building and managing various data warehousing/data marts from OLTP/Scratch using Informatica products such as PowerCenter, PowerMart, PowerConnect, PowerAnalyzer, and Power Exchange, PowerConnect tools for SAP/Mainframes/Siebel/Sybase, DataStage, Metadata Exchange for Data models, Autosys, Control M, Maestro.
• Experience with Dimensional Data Modeling experience using Data modeling, Erwin Modeling (ERwin 4.5/4.0/3.5.5/3.5.2 ) Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling
• Excellent working experience with Business intelligence database using TOAD, SQL Developer, DB2, ANSI SQL, Etc. Executing & Coordinating for performance tuning at SQL with different DB related resources.
• Experience in various ETL Architecture, Design & Development projects including testing, and production support teams in the process of developing and managing the enterprise data warehouse (EDW) for Loyalty and Awards, Email/Chain Marketing, finance data warehouse, Risk Regulatory compliance, data surveillance, online trading, Fair Market Value, Telecom-OSS, Assets, Country Population data, etc
• Responsibilities included ensuring project is executed in compliance with the SLA’s, Client internal processes and adherence to processes as CMMi, ISO, ITIL, etc. Status reporting and issue resolution, conduct process audits, do root cause analysis and apply knowledge to improve productivity and quality, Risk and mitigation plans, People Management, Conducting Interviews, Appraisals and arrange Trainings.
• Wrote PL/SQL Procedures, Packages, UNIX and ASP Scripts for Reporting, CatchUp and Update the EDW.
• 18+ Years of experience in using Informatica, Pentaho 6.0, Denodo, eRWIN, MS Visio, Amazon Redshift, Oracle 10g/9i/8i/8.0/7.x, Azure, MS SQL Server 7.0/6.5, MySQL, MS Access ‘97/7.0, Data Warehousing, ASP .Net/ 3.0/2.0, C# 2015, Visual Basic .Net, COM/DCOM, Active - X, VBScript, Java Script, IIS Python, OpenR, Microsoft Project, Sharepoint, CMMi, ISO, Microsoft FrontPage 2000/98SOA, HTTPS, EAI, IBM DB2, Analytics, SPSS, Crystal Reports, MS Office, Samba Server, KDE Windows,Outlook Express, Telecommunication & Biotechnology Packages, Linux, Unix, Win 95/98/NT 4.0. Java Script, IIS 4.0, HTML 4.0, DHTML,Data Warehousing,GPS/GIS, OBIEE 11x.

PROFESSIONAL EXPERIENCE:

Confidential

SR.AI/BI/DW CONSULTANT/ARCHITECT

Technologies - BOT framework, C#, DENODO, PENTAHO, INFORMATICA, AMAZON REDSHIFT, ORACLE EBS, HYPERION, ESSABSE,DATA SCIENCE, OPEN-R, PYTHON, UNIX.

• Responsibilities included Project BI/DW solutioning, Client DW investigations and implementation of Data Virtualization & real-time reporting, Bottom line responsibility for execution, ensure project is executed in compliance with the SLA’s and Client and internal processes, Status reporting and issue resolution, conduct process audits, do root cause analysis and apply knowledge to improve productivity and quality.
• Installation & Administration of Denodo 6.0, Informatica 9X, Pentaho includes for Unix & Windows, Server & Client, Domain & Node, Roles, Services, License's.
• Architected, performance tuned & delivered Denodo-Penatho solution using Suite including Scheduler, VDP, DI, Workbench, used adhoc reporting, User Console, CTools,Reporting designer & metadata.
• Conceptualized, Analyzed and Architected Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for extracting data in efficient manner.
• Architected and Created reusable Mapplets, used by complete team in all Mappings for the current project/s.
• Advised, Scheduled and Used different Informatica transformations in an efficient manner and as per requirement to gain maximum mileage for deliverables.
• Designed and Developed the Audit Control Components of the Project from both a Source/Target, Traceability and Reporting perspectives.
• Worked with with multiple teams for Business Denodo data virtualization,Database, Flat File, Stored Procedures, Views, Packages, Unix Scripts.
• Conceptualized, Created and worked with all Data Warehousing documentation relating to New Proposals, Solutions, Design, Development, QA, Change and Production.

Confidential

SR.DW ETL CONSULTANT/MODELER

Technologies - OBIEE, INFORMATICA, DENODO, JDE, ORACLE EBS, MDM, QLIKVIEW, UNIX.

• Created Data Model using Data modeling techniques, Visio, Star Schema vs Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling
• Created creative approach and technical solution to problems related to extracting Data from EDW, Data quality, Data Governance using Informatica 9.x
• Provided specialist domain, product, technology, and project management advise to support customers and Sales & Market Development as required.
• Fine-tuned existing code for optimum performance using data virtualization, integration techniques on both(unix, java, sql scripts) & tool based (Informatica, Denodo, OBIEE) techniques.
• Customized data by adding calculations, summaries and functions.
• Worked with Quality Analysis Team, Created Test Cases and Performed Unit testing, integration testing and validated the data.
• Involved in identifying bugs in existing code by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs
• Hands-on experience with Informatica PowerCenter, Data Governance, Data Profiler, specifically mapplets, advanced transformations, reusable sessions, worklets and scheduling
• Provided guidance to existing Team members on Informatica best practices, environment setup and architecture.
• Evaluated, Installed, delivered Data Integration, Business Intelligence solution's using Denodo, Informatica, OBIEE, MDM, JDE and Qlikview platform.
• Interviewing, Defining and Managing Contractors and Employees as and when required.
• Validated solutions met agreed requirements and customer expectations, were maintainable and met documented and agreed criteria. Worked with Test Manager and ensured that all solutions were adequately tested (functional, non-functional, performance and integration tested) before User Acceptance Testing.
• Contributed extensively towards improvement of System Development Life Cycle, procedures and standards to improve IT’s capabilities, assisting the quality management team in continual process, quality and productivity improvement.

Confidential

DEVELOPMENT LEAD

• Mahavir Research Center/LabDB.Com/MDS Pharma
• Banking and Financial Management System (BMS)
• Hospital Management System (HMS)
• MATT CAMRON AND LUXURY TRADING(Multipe Clnt-Svr e-COMMERCE & SATELLITE NAVIGATION (Including Trimble) Projects