PROFESSIONAL SUMMARY:

• 10+ years of IT experience in Design, Analysis, development of software applications and implementation of Data warehousing across Financial, Insurance, pharmaceutical and Telecom Industries.
• Experienced in designing and developing ETL mappings using BI Tools (Informatica Power Center 9.0/8.6.1/8.0/7.1 , BO Crystal Reports & SSIS/SSRS platform. Talend, Hadoop )
• Good knowledge in Data Modeling using data Modelers, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling along with SDLC flow
• Understanding the follow of BI Apps (7.9.6.4) & DAC & Informatica and Administration Aspects as well
• Hands on experience with mappings from varied transformation logics and validations
• Good knowledge in OBIEE functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
• Created cross - tab, drill-down, Charts and sub reports using Crystal Reports for all the reports based on reporting requirements from Business.
• Worked with the Business analysts, end users, Data Modelers and the DBA for requirements gathering, business analysis, testing, and project coordination. Analyzed existing databases and designed & modified existing universes using Designer module.
• Having good Knowledge on Zookeeper, Random Read/write column oriented database like HBase and store data by using different HBase Shell commands.
• Used Sqoop to import data into HDFS and Hive. Used extensive Pig Latin to load & transform (ETL process) supplier's data for our internal customer requirements. Expertise in tuning SQL statements, Procedures, ETL processes and their respective applications to enhance the data load as well as to improve the application response time
• An enthusiastic and project oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
• Excellent communication skills, good organizational skills, self-motivated, positive attitude, ability to work independently or co-operatively in a team.

TECHNICAL SKILLS:

Data Warehousing / ETL: Informatica Power Center 9.0/8.6/7.1, RTM (Reference table manager), ERWIN 7.1/4.1,OLAP, ROLAP, OLTP, SQL *Plus, OLAP Tools, Business Objects XI/6.X/5.X, Crystal Reports 7.0/8.0/9.0/10

Reporting Tools: OBIEE/Siebel Analytics 10.1.3.x, Cognos 8

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop,, Oozie, Flume

Databases: Oracle 10g/9i, PL/SQL, IBM DB2 Teradata, SQL Server, Netezza

Operating Systems: Windows 95/98/2000/2003/ NT/XP, MS DOS, UNIX

Programming: C, C++, SQL, PL/SQL, Java, J2EE, HTML, XML

SQL Tools: SQL * Plus, SQL *Loader, SQL Navigator, TOAD

WORK HISTORY:

Confidential

Senior Systems Analyst

• Developed the Data Models utilizing a service based approach in support of application development as well as analytics.
• Coach project ETL specialists on data acquisition techniques, decision rules and how to apply them
• Periodically review all data content in the BI environment to identify opportunities for improvement of problem avoidance.
• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Uploaded SQL Server 2005 Reporting Services (SSRS) RDL files to SQL Server 2005.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Played a major role in production support of SSAS cube and SSIS jobs.
• Implemented complex conceptual database design and database architect into SQL Server 2005/2008 using various constraints and triggers.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS)
• Extracted data from Oracle and migrated into SQL Server 2005 using SSIS.
• Design various E-R diagrams for different modules by using Erwin and Visio.Loaded data into the cluster from dynamically generated files using Flume and from relational database management systems using Sqoop.
• Performed analysis on the unused user navigation data by loading into HDFS and writing Map Reduce jobs. The analysis provided inputs to the new APM front­end developers and lucent team.
• Wrote Map Reduce jobs using Java API and Pig Latin.
• Loaded the data from Teradata to HDFS using Teradata Hadoop connectors.
• Used Flume to collect, aggregate and store the web log data onto HDFS.
• Wrote Pig scripts to run ETL jobs on the data in HDFS. Used Hive to do analysis on the data and identify different correlations.

Environment: Informatica Power Center 9.1, Hadoop Apache ETL(POC), Oracle 11g, Windows Environment, OBIA, SIEBEL CRM, Mainframe DB2 (Zeke as the scheduler ), MicroStrategy, Cognos

Consultant

Responsibilities:

• Understanding the business requirements and identify the needs for the requirements. Working with the stake holders in documenting the business purpose and support the process for decision making
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).Coordinating the change management and business modeling in the customer’s business processes and organizations.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Developed, deployed, and monitored SSIS Packages
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Analyzed the Custom data & repository objects & did the gap analysis.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Worked in multi user environment in OBIEE.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Copied existing RPDs from Server into the Local machine for testing and tuning of dashboards.

Environment: Informatica Power Center 9.1, OBIEE 11.1.1.6, Oracle 11g, Server 2008/2005,SQL Integration Services(SSIS),SharePoint,OBIA, JDE, Control - M (BMC Scheduler )

Architect /Lead

Responsibilities:

• Prepared High Level Design and Low Level Design based on Functional and Business required documents of the project.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Integrated SQL Server 2008 reporting services with MOSS (Microsoft Office Share Point Server) to automatically deliver reports to the Share Point portal
• Created mapping tables to find out the missing attributes for the ETL process.
• Used the row count transformation and event handlers control flow to populate the special Log tables with high level SSIS package execution results
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server and DB2 Database
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Created SQL Jobs to schedule SSIS Packages
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Worked with slowly changing dimension Type1, Type2, and Type3
• Performance tuning of the process at the mapping level, session level, source level, and the target level
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Prepare test data for positive and negative test scenarios as per the business requirements
• Good Knowledge and Understanding and Hands on Knowledge on SAP BO

Environment: SSIS, SSRS, B2B, Informatica, MDM, Erwin 4.x,BO Teradata (v2R5, 12, UNIX, CSV, XML,COBOL, DB2,JIRA,MS Server

Consultant

Responsibilities:

• Working as ETL Architect to implement the MDM for “CUSTOMER”, “SUPPLIER”, “ITEM” and “RMI (Raw Material Inventory) dimensions and maintain the Golden (De-Duplicated Data) in to the EDW.
• Deeply involved in Data architecture principles.
• Extensively involved in Data Cleansing activities and Data Mapping activities by working closely with Source systems subject matter experts.
• Extensively involved in creating several Data Mapping documents for Source and target tables. These are mainly used as input to the Data Modelers, ETL development to create Mappings and Metadata Creation in EDW environments.
• Partner with the Application Lead, Development Lead, and System Designer in application and transaction design.
• Ensured data deliverables are created for the project (conceptual model, logical model, physical model, data flow diagram, data topology, data mapping, detailed data access design, etc
• Ensured all SQL go through reviews and that the correct procedures are in place and team members understand their responsibility as review
• Deeply involved working with AP,AR,OM,GL,INV,SCOM informatica integrated with Oracle EBS
• Involved in defining and preparing EDW Framework to implement the MDM and integrate the Golden (De-Duplicated) Master Data in to the EDW.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse
• Documenting the details of the source feed systems by creating to one to one mapping doc that helps developers creating ETL routines for loading data from source to the staging area.
• Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications.
• Used DAC to schedule, monitor the daily loads Worked with Demand management, Supply Chain& Order Management using EBS
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.

Environment: Informatica Power Center/Power mart 8.6,Powerexchange Teradata, OBIEE, Oracle 10g, T- SQL, SQL/PLSQL, UNIX Shell Programming, TOAD, Erwin 4.0 and Windows NT,DAC,EBS, N etezza

Sr. Informatica Consultant

Responsibilities:

• Participated in requirement meetings with Business Analysts and End Users to understand analytical needs, assisted in documenting these requirements, resolving ambiguities.
• Analyzed the functional specifications provided by the data architect and created technical specs documents for all the tasks.
• Worked on design and development of Custom Informatica mappings, workflows to load data into staging area, data warehouse for Oracle OBIA
• Created new mappings, modified existing mappings, sessions, workflows to comply with the new architecture.
• Analyzed and created various Fact and Dimensions tables.
• Implemented various Slowly Changing Dimensions (SCD - Type I & II) as per the requirements.
• Worked heavily on production support and fixing the issues to ensure data marts are online under SLA.
• Performed repository backups and managed folders, user access, connection variables for dev, sys, UAT and production.
• Worked with OBIEE developers to assist them in the development of various reports.
• Worked with manage the Execution Sequence Dynamic generation of subject areas and execution plans
• Worked with JDE Supply Chain Management - Dynamic settings for parallelism and load balancing
• Intelligent task queue engine based on user-defined and computed scores
• Index management for ETL and query performance with DAC
• Developed Feature Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects within OBIEE.Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Implemented Dynamic Navigation to allow the system to pass parameters from the summary dashboards to the details dashboards. Restart from any point of failure with DAC

Environment: Informatica power Center 8.1, SQL Server 2005, Oracle, Erwin, OBIEE, and PL/SQL,Cognos 8,DB2,DAC, Ntezza

ETL/Report Developer

Resp onsibilities:

• Provided Technical support to the team as the ETL developer. Addressed best practices and productivity enhancing issues.
• Worked on designing and developing the Quality stage.
• Loaded data into load, staging and lookup tables. Staging area was implemented using flat files.
• Created jobs in Data Stage to import data from heterogeneous data sources like Oracle 9i, Text files and SQL Server.
• Generation of Surrogate IDs for the dimensions in the fact table for indexed and faster access of data in server jobs.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Created different Data sources and Created model using different Data Sources and created packages and published to the cognos portal.
• Created Drill Through reports and Conditional Formatting by using Report Studio.
• Involved in migration of cognos 8.0 version from cognos 7.3 versions.
• Extensively worked on complex reports using tabular sets, child tabular models, drill through reports, master detail reports, conditional prompts. Developed Multi Page Reports.
• Created user groups, Roles to implement the Cognos security using Access manager.
• Customized Cognos Connection Portal to personalize the homepage.
• Created the documentation for cubes & Reports. Testing and Validating the Reports.
• People Soft ERP is used to store all the source data and Decision Stream as well as Microsoft Integration Services (SSIS) is used to extract, transform and load between the source and the target databases.
• Involved in analyzing the cardinality between query subjects.
• Customized data by adding Calculations, Filters, Prompts and Governor Settings.

Environment: DATASTAGE Power Centre 8.1.1, Oracle 10g/9i, Business Objects XI R2, Web Intelligence 2.5, PL/SQL, TOAD, SQL*Plus, Erwin, Windows, UNIX, Cognos,Datastage

Informatica Developer

Responsibilities:

• Perform ETL test scenarios by writing SQL scripts with consideration of Business scenarios.
• Tuned sources, targets, mappings and sessions to improve the performance of data load Systems Exclusively work on ETL test case scenarios with business functionality and generated the
• Reports for business users, Create manual and automated tests by conducting functionality testing, regression testing.
• Work closely with the project team in planning, coordination and implementing QA methodology Agile Environment.
• Analyze and help in modifying the Use Cases and created the Test cases based on them.
• Use Quality center to track, analyze and document defects.
• Reporting and tracking defects using test management.
• Involved in developing Entry & Exit criteria and defined the pass and fail standards.
• Perform Positive & Negative Testing.
• Participate in various meetings and discuss Enhancement and Modification Request issues (Change Requests).
• Perform Functional, Smoke, Integration, and System testing of Data warehouse application.

Environment: Informatica Power Center 7.1, Erwin 3.5, Cognos, SQL Server DB2, Oracle 9i/8i, SQL Loader, TOAD, UNIX, Win NT,Datastage