Candidates About

 

Rayan

PROFESSIONAL EXPERIENCE

§  Over 8 years of IT experience with expertise in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems (DSS) involving RDBMS like Oracle, MS SQL server, DB2 and Teradata databases on Windows and UNIX platforms.

§  Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).

§  Experience in developing and maintaining logical and physical Data models for Data Warehouse applications      using tools like Erwin and ER/Studio.

§  Extensively worked with Informatica Power Center, Informatica Power mart.

§  Extensively used Informatica Client Tools – Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.

§  Expertise in implementing complex Business rules by creating robust mappings, Mapplets, shortcuts, reusable transformations using transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.

§  Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from various sources like DB2 UDB, Oracle, Flat files, XML files, Teradata, Sybase and MS SQL Server into Oracle, Teradata, XML, and SQL server targets.

§  Extensive experience in implementing CDC using Informatica Power Exchange 8.x/7. x.

§  Extensively worked with Oracle PL/SQL Stored Procedures, Functions and Triggers and involved in Query Optimization.

§  Extensively worked on Repository Manager, Server Manager, Workflow Manager, and Workflow Monitor.

§  Profound knowledge about the architecture of the Teradata database. Developed Teradata Loading and Unloading utilities like Fast Export, Fast Load, and Multiload (M Load).

§  Documented design procedures, mapping specifications from Source to Target, operating instructions, test plans/procedures and troubleshooting procedure for ease of application maintenance.

§  Extensive knowledge with Teradata SQL Assistant. Developed Teradata BTEQ scripts to Load data from Teradata Staging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements.

§  Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.

§  Strong in UNIX Shell and PERL scripting. Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Maestro, Control-M.

§  Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle.

§  Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

EDUCATION

Bachelors of Engineering in Computer Science from JNTU Kakinada, INDIA.

 

TECHNICAL SKILLS

ETL TOOLS	Informatica 9.x/8.x/7.x, Informatica Power Exchange 7.x/8.x, Power Mart, DataStage 6.x, SQL Server Integration services
OS	Sun Solaris 2.x/7/8, HP-UX, IBM AIX, Unix, Linux, MS-DOS, Windows ME/2000/2003/NT/XP, Exceed (Editor)
DATA BASE	Oracle (6.x/7.x/8.0/8i/9i/10g), Teradata V2R5, Teradata V2R3, DB2, SQL Server, Sybase 11.5, Informix (XPS, 7.x/8.x), MS-Access, XML
PROGRAMMING SKILLS	C++, UNIX Shell Scripting (K-Shell, C-Shell), SQL, PL/SQL, PERL, FORTRAN, HTML, JAVA Script, CSS
DB Tools	SQL*PLUS, SQL*LOADER, SQL*NET, Quest TOAD, SQL Navigator, Oracle Enterprise Manager, Oracle WSGL/Web Tool kit
DM Tools	Erwin, Visio
SCHEDULED Tools	MAESTRO, Autosys

 

PROJECT EXPERIENCE

 

SUNOVION PHARMACEUTICALS, MARLBOROUGH, MA | ETL DEVELOPER | MAR’16 - PRESENT

DESCRIPTION: The Physician Payments Sunshine Act requires manufacturers of drugs, medical devices and biologicals that participate in the U.S. federal health care programs to report certain payments and items of value given to the physicians and teaching hospitals. The Sunshine Rule, officially known as the CMS Open payments program, is intended to increase public awareness of financial relationships between drug and device manufacturers and certain health-care providers. I am part of the transparency reporting team at Pharmaceutical client working as a ETL developer responsible for designing, development and implementing a data warehouse to store the historical information about how the company spends data on physicians and teaching the hospitals.

 

RESPONSIBILITIES:

§  Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners. 

§  Prepared the High-level Design document to provide an overview of the technical design specification system required for Application Enhancements.  

§  Involved in the development of the Conceptual, Logical and Physical data model of the Star Schema using ERWIN.

§  Used Informatica Power Center to create Mappings, Sessions and Workflow for populating the data into land, Stage, Exception, Dimension, Fact and Lookup Tables simultaneously from different source systems (DB and flat files)

§  Extracted data from various Source Systems such as Oracle, Sql Server, Flat Files, Xml Files, Sybase and Db2 as per the requirements and loaded in to the Data Warehouse.

§  Developed several complex mappings using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.

§  Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.

§  Created Persistent Lookup cache modified the look up SQL query and tuned transformations like Aggregator, Joiner and implemented Incremental aggregation for better performance.

§  Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.

§  Used Workflow Monitor to monitor jobs, review & rectify error logs that were generated for each session.

§  Experience with Informatica Data Quality Toolkit, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ.

§  Integrated Informatica Data Quality IDQ with MDM and Created various data quality mapplets in Informatica Data Quality tool and imported them as IDQ cleanse functions.

§   Used MDM concepts, Methodologies and ability to apply this knowledge in building MDM solutions.

§  Scheduled various daily and monthly ETL loads using Control-M.

§  Responsible for creating UNIX shell scripts to achieve several functional requirements like ftp, Web download files, file validation, archiving, email and scheduled batch jobs using PMCMD.

§  Worked on performance tuning of the ETL processes. Optimized/tuned mappings for better performance and efficiency.

§   Experience using Informatica debugger; push down optimization and Incremental Aggregation

§  Thorough knowledge and experience of Slowly Changing Dimensions for historical data maintenance.

§  Worked on creating partitioning at both database and Informatica for optimal performance.

§  Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.

§  Involved in the administration of the Informatica Repository and in the design and architecture of multiple repositories to support multiple application development areas.

§  Implemented screen door processing for validating and cleansing Flat file sources.

§  Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.

§  Created test cases for carrying out unit testing and part of functional testing.

§  Coordinated with testing team in all three phases of testing including end-to-end testing.

§  Created several reusable transformations, mapplets and shell scripts for code reusability

§  Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.

§  Developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.

§  Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.

§  Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

§  Prepared Run books providing guidelines to trouble shoot the errors occurred during the run time and instructions on how to restart the loads.

§  Implemented solutions to tickets raised by user community.

§  Created Pre-Sql and Post-Sql scripts which need to be run at Informatica level.

§  Coordinated all ETL (Extract, Transformation and loading) activities and enhancements using Agile Methodology.

Environment: Informatica Power Center 9.5, Informatica IDQ 9.6, Informatica cloud, Oracle 11g, XML files, flat files, CSV files, PL/SQL (Stored Procedure, Trigger, Packages), SQL Server, MS Visio, TOAD, Winscp, Putty, Windows 2003/2007, Solaris

UBS, NASHVILLE, TN | ETL DEVELOPER | NOV’2014-FEB’2016

DESCRIPTION: UBS is one of the financial companies in the US with services like Asset Management, Insurance, Personal Banking, Lending and Financing, and Risk Management. The company requires different level of analysis regarding loan amount, type of customers' type of payment schedules, interest rates, defaulters list and the penal interest calculations, etc.  The data warehouse, basically it is a Data Mart as it covers only one domain of the business and captures data from their Historical Database. The main objective of the project was to build an enterprise data warehouse.

 

RESPONSIBILITIES:

§  Member of core ETL team involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate the data from source to the target data warehouse.

§  Implemented dimension model (logical and physical data modeling) in the existing architecture using Erwin.

§  Loaded data from various sources like DB2, SQL Server, Flat files, MS Access into Oracle Data Warehouse.

§  Worked with various Transformations in Informatica PowerCenter like Filter, Aggregator, Joiner, Rank, Route, Sorter, Source Qualifier, and Update Strategy, Expression, Sequence Generator, Sorter and Lookup Transformation.

§  Extensively used SQL Override function in Source Qualifier Transformation.

§  Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads.

§  Developed mapping parameters and variables to support SQL override.

§  Used the Java Runtime Environment to execute generated byte code at run time and Java API using which you can process data or manipulate behavior of Mapping / Session

§  Extensively used Power Center to design multiple mappings with embedded business logic.

§  Developed mappings to load into staging tables and then to Dimensions and Facts.

§  Experience in integration of various data sources definitions like SQL Server, Oracle, Teradata SQL Assistant, MySQL AB, Flat Files, XML and XSDs.

§  Worked with Re-usable objects like Re-Usable Transformation and Mapplets.

§  Responsible for Designing Mappings, Sessions, Workflows, Mapplets, Re-usable transformations, Shortcuts, Performance Tuning, and Error Handling.

§  Responsible for Performance Tuning at the Mapping, Session, Source and the Target Level.

§  Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

§  Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.

§  Scheduled sessions to extract, transform and load data into warehouse database as per Business requirements.

§  Responsible for Unit Testing and Integration testing of mappings and workflows.

§  Involved in developing test plans and test scripts to test the data based on the business requirements.

§  Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.

§  Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.

§  Responsible for migrating the workflows from development to production environment.

§  Estimates and planning of development work using Agile, thereby reducing time on critical projects.

 

Environment: Informatica PowerCenter 8.6.0, Oracle 10g/9i, MS Access, SQL Server, IBM DB2, Flat Files, UNIX Shell Scripts, PL/SQL, Toad v9.1, Oracle SQL Developer 1.5.1, ERWIN 7.2, Telnet, MS Visio, Windows Server 2003 R2, Windows XP.

 

 

APOLLO TYRES LTD, GURGAON, INDIA | DATABASE DEVELOPER | OCT’2013-AUG’2014

DESCRIPTION: The project was developed for the shipment department in Apollo tyres. The Project main objective was to process sales request and to place backorder request if the requested item is not in the inventory. I was involved in developing forms, reports, triggers, SQL-Loader scripts and tuning SQL statement. I also helped in design and testing phase of the project.

 

RESPONSIBILITIES:

• Wrote scope and requirement documents after discussion with customers

§  Assisted in developing the data models

• Developed Forms, Reports, PL/SQL programs for integrated fleet management and Inventory control system.
• Involved in developing interactive forms and customization of screens using Oracle Forms

§  Involved in creating the database objects, populating the tables using SQL-Loader, writing data loading and creating data validation procedures and packages

§  Wrote triggers and stored procedures for various activities using PL/SQL.

§  Assisted in tuning the SQL statements for improving response time.

§  Involved in building, debugging and running forms.

§  Involved in manual testing of the forms

• Assisted with the development of testing strategy that included unit testing & integration testing.

§  Involved in the planning, attending the meetings, setting up the security, menu design, screen layout, screen design, development, documentation and creating reports.

Environment: Oracle 8i, Windows 2003 server, SQL*Plus, SQL, PL/SQL, SQL*Loader.

 

JNET TECHNOLOGIES, HYDERABAD, INDIA | DATABASE DEVELOPER | JAN’2013-SEP’2013

DESCRIPTION: JNET is an offshore software development company that offers programming, design, and consulting services to a wide range of industries and business areas. Working with you continuously, we can execute a project from a mere concept to the final, polished solution. Our highest quality services are driven by the customer's comfort, cost benefits, schedule and budget targets, and confidentiality and security issues.

 

RESPONSIBILITIES:

§  As an Oracle implementation team member, worked on writing custom forms and custom tuning the reports.

§  Worked as a technical support for a team that involved technical & quality reviews of program codes and PL/SQL blocks for optimization and maintaining standards & guidelines.

§  Loading the data using Oracle SQL* Loader.

§  Developed Database Triggers to enforce complicated business logic and integrity constraints, and to enhance data security at database level.

§  Developed Custom forms to view edit the data in custom interface tables and event handling tables using template forms.

§  Completed database architecture including developing stored procedures and functions to create shortcuts to frequently repeated tasks.

§  Promoted the new code to production through unit and system testing.

 

Environment: Oracle 8i, Windows 2003 server, SQL*Plus, SQL, PL/SQL, SQL*Loader.

 

 

VALUE IT LABS LTD., HYDERABAD, INDIA | JR DATABASE DEVELOPER | JAN’2012- NOV’2012

DESCRIPTION: Contract Accounting System consisted of three modules i.e. Tender, Project Analysis and Financial Accounting. It deals with the construction business activities and includes the process flow from the tender stage to billing. Tender module includes capturing the details from the customers, sending quotations to sub-contractors along with the activity and sub activity details. Project analysis includes the project initiation, project revision and work order generation and Financial Accounting includes payments, receipts and generation of usual Financial Accounting reports such as cash flow statement, Trial Balance, Balance Sheet and other necessary reports.

 

RESPONSIBILITIES:

§  Study and analysis of the System

§  Involved in creating tables, views, queries and stored procedures.

§  Interacted with functional users for developing application specifications

§  Was responsible for the development of Tender module, Project Analysis and part of Financial Accounting.

§  Performed tuning of queries.

§  PL/SQL codes have been used extensively for the creation of forms and reports.

§  PL/SQL Scripts (Stored procedures and Functions) have been used for application Development.

§  Involved in Integration and Acceptance testing.

§  Debugging of internal code for the forms and reports is done.

Developed forms and reports in the Finance – Accounts Payable module for an information system using Oracle 6.0, SQL*Forms 3.0.

 

Environment: Oracle 8i, Oracle 8.0.5, Oracle Forms, Developer 2000

 

APOLLO HEALTH STREET, HYDERABAD, INDIA | JR DATABASE DEVELOPER | MAY’2010- DEC’2011

DESCRIPTION: Apollo is offering individuals, employers and Medicare beneficiaries a variety of consumer-driven health care and insurance products. Specialty operations include behavioral health, dental and vision, life insurance, and complete pharmacy and medical management through its wholly owned subsidiary, Prescription Solutions. Common Portal is a web application, it provides members & providers information, eligibility, benefits, claims, health programs, doctor Information, prescription Information etc. on line.

 

RESPONSIBILITIES:

§  Developed and Modified PLSQL Scripts like Procedures, Functions, Packages, Triggers etc. based on the technical Documents.

§  Loading the data using Oracle SQL* Loader.

§  Involved in fine tuning the scripts

§  Creation of schema Objects, granting of roles and privileges to the users, create and compile procedures etc.

§  Generating Daily, Weekly, Monthly Reports.

 

Environment: Oracle 7.3, Windows 2000 server, SQL, PL/SQL, SQL*Loader.