SUMMARY

• Eight plus (20+) years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, and Energy Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and Oracle Developer.
• Expertise in working with relational databases such as Oracle, SQL Server 2008/, UDB, MS Access and Teradata.
• Developed solutions in ODI/Informatica (ETL tools) that handle high - volume, high-performance loads.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in installing and integration with Hyperion and Business intelligence applications.
• Experience in Data integration with cloud systems oracle and AWS hardware. Automation scripts to load data into cloud systems.
• Experience in DRM and FDMEE integration tools for OLAP applications. Data Integration with Hyperion (OLAP) and Business Intelligence (OBIEE) applications.
• Experience using SAS Data Mining, SAS Enterprise Data Integration Server and SAS Studio.SAS Programming,
• Generated tables, listings, and graphs using PROC REPORT and PROC GPLOT. Created macros and used existing macros to develop SAS programs for clinical data analysis.
• Produced SAS outputs in RTF, PDF, CSV and HTML formats using Output Delivery System (ODS) facility. Strong Proc SQL experience
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in using Automation Scheduling tools like Autosys and UNIX scheduler.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), SAS Tool, Data stage, ODI

Databases: Oracle 12g/11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata.

Data Modeling tools: Erwin, MS Visio

OLAP Tools: Hyperion 11.1.2.4/11.1.2.1/9.3.1 , OBIEE 10.1.3.4/ 10.1.3.3

Languages: SQL, PL/SQL, UNIX, Shell scripts, DOS Shell, C

Scheduling Tools: Autosys, Control-M

Testing Tools: QTP, WinRunner, LoadRunner, Quality Center, Test Director

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards. Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Design ODI Mappings and Packages to perform ELT data transformations. Modifies existing and creates new ODI deliverables.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mappings to load into staging tables and then to Dimensions and Facts. Master data management, metadata extract for OLAP and Business intelligence applications.
• Design and development of Data integration between OFFSA and Oracle BI/ EPM solutions.
• Documented and maintained OFSAA customizations and apps, Created data models for multiple environments. Resolved application issues and evaluated application processes.
• Provided assistance in starting and stopping of OFSAA services, Implemented requirement modifications in coordination with DBAs. Trouble shooing logs in UNIX environment.
• Used existing ETL standards to develop these mappings. Extensively used SQL* loader to load data from flat files to the databasP tables in Oracle.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Confidential

Data Architect / Data Scientist

Responsibilities:

• Gathered business requirements from Business Analyst.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Developed database in projects with large, diverse, client data source files.
• Worked on the planning and coordination of work activity for projects involving more than 2 million records.
• Experience in SAS programming for auditing data, developing data, performing data validation QA and improve efficiency of SAS programs
• Statistical Analysis and design and developed reports using SAS programming.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Ran SQL queries in Oracle database to analyze and manipulate data.
• Wrote SAS programs to performed ad-hoc analysis and data manipulation.
• Created various SAS Reports, Tables, Graphs and Summary analysis on PMS systems being used in these properties.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Confidential

Data Architect / Data Scientist

Responsibilities:

• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Perform data integration and transformation among various platforms using advanced techniques.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Expert in producing ELT/ETL deliverables on a BI/EDW project deliverables.
• ODI capabilities around changed data capture, Web services, SOA and meta data repositories
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Confidential

Data Integration Lead

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in Oracle Schema.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Conducted code reviews developed by my team mates before moving the code into QA.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Defines strategy for migration approach of ODI objects between environments.
• Automated ODI process to feed from ERP to OBIEE/EPM applications.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in production support.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Confidential

Sr Consultant

Responsibilities:

• Gathering of functional specification for Workforce planning application and formulation of a solution for the clients requirements.
• Design and developed Workforce planning application. Implemented budget and forecast models as per user requirements
• Managed the Region and department Employee transfers, share employee between the departments and designed offshore / smart shore workforce budgeting model using business rules and data forms.
• Business process redevelopment revolving around the new automated data load process and implementing security filters on all planning dimensions and also in Essbase applications.
• Trouble shooting Essbase and planning applications, Writing Calc, load rules, Reports and business Rules.
• Designed various forms for budgeting and forecasting models.
• Supported current P&L Essbase cubes and Reporting ASO Cube. Modified MDX formulas as per user needs
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.

Confidential

Data Integration Lead

Responsibilities:

• Installation and integration of EPM 11.1.1.3 applications.
• Gathering requirements from business customers and translating into IT solutions.
• Integration and configuration of Data relation management (DRM) module in EPM 11.1.1.3 environment.
• Developed a maintenance strategy including daily and weekly backup, disaster recovery, log rotation, system health monitoring, and helpdesk integration.
• Developed backup and Defrag scripts, trouble shooting Essbase log files and performance settings tuning in Essbase CFG file parameters.
• Transferred data from Oracle database as well as MS Excel into SAS for analysis and used filters based on the analysis.
• Used SAS Import/Export Wizard as well as SAS Programming techniques to extract data from Excel.
• Supported day to day activities for Allocations, Income statement and balance sheet applications in ESSBASE 9.3.1

Confidential

Sr. Consultant

Responsibilities:

• Created a project timeline to redesign a Hyperion Enterprise Application
• Assist with business process redevelopment revolving around the new automated data load process
• Developed multiple organizational structures in Hyperion Enterprise to meet the management and legal reporting requirements
• Created new chart of accounts and corresponding formulas to allow for account subtotals and balance sheet roll-forward information
• Maintained Workforce and CapEx planning applications, and also managed forms and financial reports for workforce planning application.
• Implemented Head count functionality in workforce planning application
• Design and maintenance of ASO cube outline and member formulas. Assisting with development of divisional KPI reporting cubes .
• Providing support to end-users for Reporting Template design. Maintaining system and end-user documentation
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.