Atasi Chhotaray

Phone No: 309-***-****

Summary

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadline.

Experience in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center 10.1/9.0/8.6/8.5/8.1.1/ (Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Oracle,SQL,PL/SQL, Control M.

Advanced Knowledge of Oracle PL/SQL programming, stored procedures & functions, indexes, views, materialized views, triggers, cursors and tuning the SQL query.

Experience in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in creating and scheduling workflows.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Query Re-write.

Good Knowledge on logical and physical Data modelling using normalizing techniques. Created Tables, Views, Constraints, Index (B-tree, Bitmap and Function Based).

Developed Complex Database objects like Stored procedures, Functions, Packages and Triggers using SQL and Pl/SQL.

Expertise in Dynamic SQL, Collections and Exception Handling Experience in SQL performance tuning using Cost-Based optimization.

Effectively training, motivating and mentoring the team members irrespective of any circumstances. Involved in various oracle proposal related task.

Experience in Production support and production defects solving.

Experience in Oracle workflow script to initiate job and monitoring the job completions.

Experience in writing SQL script for Ad-hoc reporting considering performance.

Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics.

Expertise at designing tables in Hive, PIG, MYSQL using SQOOP and processing data like importing and exporting of databases to the HDFS.

Expertise in developing Pig Latin Script and Hive Query Language.

Expertise in Autosys Job scheduler.

Technical Skills

RDBMS

Oracle 12c/11g/10g/9i/8i/, MS SQL Server 2008/2000/7.0/6.5, SQL, PL/SQL, SQL*Plus, SQL*Loader .

DW/ETL Tools

Informatica Power Center 9.0/10.1/ (Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), ETL, OLAP, OLTP, Control M, Autosys

Reporting Tools

Business Objects XI R3-R2-R1/6.5/6.0/5.1/5.0, Oracle Report Builder.

Languages

SQL, PL/SQL, Shell Scripting

Database Tools

Pl/SQL Developer, TOAD

Data Modeling

Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, FACT and Dimensions Tables, Oracle Designer.

Educational Qualification

BE in Electrical Engineering from University College of Engineering Burla, Odisha.

Work Experience

Client : Mercedes-Benz Financial Services, Farmington Hills,MI

Jan 2020 to Till Date

Informatica Developer

Mercedes-Benz Financial Services USA LLC, a business unit of Daimler Mobility AG, provides brand-specific financing and leasing products, as well as insurance services to customers who choose Mercedes-Benz vehicles.

Responsibilities:

Designed and implemented ETL mappings to extract and transform data from various sources and also actively involved in analyzing business requirements.

Involved in scheduling the workflows through Autosys Job Scheduler.

Monitored the jobs daily and involved in production support.

Designed and developed Functional and Technical Specification Documents.

Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.

Proficient in using Informatica workflow Design, Workflow monitor.

Extensive experience in debugging mappings. Identifies bugs in existing mappings by analyzing the data flow, evaluated transformations and looking at errors in session and workflow logs

Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.

Created Mapplets and used them in different mappings.

Developed Oracle PL/SQL for Data Import/Export.

Involved in Tuning Informatica Mappings and Sessions for Optimum Performance.

Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse.

Strong in writing SQL Joins Queries, Index,Partition,Sequence, materialized view, Unions and object creation.

Worked with Dimensional Data warehouses in Star, created slowly changing dimensions (SCD) Type1/2 dimension mappings.

Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.

Excellent in coding using SQL, SQL*Plus, PL/SQL,Collection, Procedures/Functions, Triggers and Packages.

Deliberated and developed UNIX shell scripts for creating, dropping tables which are used for scheduling the jobs.

Widely used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters, FTP Session Parameters and Source-Target Application Connection parameters.

Used FTP connection browser available in Informatica Workflow Manager to FTP the flat files into different environment.

Used Windows Scripting and PMCMD command to interact with Informatica Server from command mode.

Environment: Informatica Power Center 10.1, Oracle 12c, UNIX, SQL*Plus, PL/SQL, TOAD, SQL Server2005.

Client : Blue Care Network, Southfield MI

Mar 2019 to Dec 2019

Informatica Developer/Tester

Blue Care Network of Michigan is a health maintenance organization which includes almost 6,000 primary care physicians, over 23,000 specialists and most of the state's leading hospitals and provides quality health care benefits.

Responsibilities:

Designed and implemented ETL mappings to extract and transform data from various sources and also actively involved in analyzing business requirements.

Designed and developed Functional and Technical Specification Documents.

Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.

Proficient in using Informatica workflow Design, Workflow monitor.

Extensive experience in debugging mappings. Identifies bugs in existing mappings by analyzing the data flow, evaluated transformations and looking at errors in session and workflow logs

Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.

Created Mapplets and used them in different mappings.

Developed Oracle PL/SQL for Data Import/Export.

Involved in Tuning Informatica Mappings and Sessions for Optimum Performance.

Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse.

Strong in writing SQL Joins Queries, Index,Partition,Sequence, materialized view, Unions and object creation.

Worked with Dimensional Data warehouses in Star, created slowly changing dimensions (SCD) Type1/2 dimension mappings.

Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.

Excellent in coding using SQL, SQL*Plus, PL/SQL,Collection, Procedures/Functions, Triggers and Packages.

Deliberated and developed UNIX shell scripts for creating, dropping tables which are used for scheduling the jobs.

Widely used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters, FTP Session Parameters and Source-Target Application Connection parameters.

Used FTP connection browser available in Informatica Workflow Manager to FTP the flat files into different environment.

Used Windows Scripting and PMCMD command to interact with Informatica Server from command mode.

Involved in scheduling the workflows through Autosys Job Scheduler.

Monitored the jobs daily and involved in production support.

Environment: Informatica Power Center 8.6/8.1, Oracle 10g/9i, UNIX, SQL*Plus, Business Objects XI 3.0, Windows7/XP, TOAD, SQL Server2005.

Company :Tata Consultancy Services Limited (TCS)

Client :Nielsen, India

Oct 2014 to Sept 2016

Sr ETL Informatica Developer

Project: NISP-Offshore

Project Description: Nielsen is a retailed based organization that enables companies to understand consumer’s behaviour. It sells data and insights around the world to many clients, collecting the data from local markets, consolidating information together and that information is scatter in local markets. It is divided to into two parts buy and watch (television etc.). NISP is a Post-factory, multi-country, multi-category, multi-source data integration service Platform .Data from various sources or clients comes in the form of files of different format like xls, sds, flat, infact files. In NISP those information are collected, consolidated and calculated, harmonized to give reports that is used by the clients (PepsiCo, nestle, coke, unilever etc) to generate insights.

Responsibilities:

Involved in design documentation as per client requirements.

Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center (9.x).

Excellent understanding of transactional and dimensional data modelling, Data Warehousing concepts, Star Schema modelling, Fact and Dimensions Modelling.

Extensively worked on Informatica Power Center Components such as Mapping and Mapplet Designer, Repository Manager, Workflow Manager, Workflow Monitor.

Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.

Made use of parameter files, mapping parameters, mapping variables and session variables.

Experience in identifying and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance.

Extensive experience in debugging mappings. Identifies bugs in existing mappings by analysing the data flow, evaluated transformations and looking at errors in session and workflow logs.

Proficient in using Informatica workflow manager, Workflow monitor.

Involved in writing Packages, Functions, stored procedures, cursors according to coding standards.

Involved in Development work using Dynamic SQL, Records and PL/SQL Tables.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Involved in Workflow design, mapping and monitoring workflow staring from file loading to output data generation as per client requirement for business analysis.

Involved in ETL process testing.

Involved in all critical tasks and delivered successfully.

Involved in Performance Tuning for developed code to meet the client SLA.

Facilitating the business team in getting the sign-off for the agreed business processes.

Involved in Unit Test plan preparation and Execution.

Involved in Production roll out plan and post-production support with monitoring production behaviour and fixing priority issues.

Developed PL/SQL triggers for automatic creation of primary keys. Created PL/SQL stored procedures, functions, Packages and called them as activity inside the workflow scripts.

Partitioned the fact tables and materialized views to enhance performance. Extensively used bulk collections in PL/SQL objects for improve performance.

Created records, tables, collections (nested tables and arrays) for improving query performance by reducing Context switching.

Handled errors using exception handling and tracking error in the log table for further debugging using pragma autonomous transaction.

Writing Hive, Pig Queries for reporting.

Used Hive and created Hive tables and involved in data loading.

Used Sqoop to import data into HDFS and Hive from other data systems.

Tools/Technologies: Oracle SQL, PL/SQ, Hadoop Bigdata (PIG, SQOOP, HIVE), Informatica Power Center 9.x

Company :Tata Consultancy Services Limited (TCS)

Client :Standard Bank of South Africa Limited, India

Nov 2013 to Dec 2013

Senior Developer

Project: SBSA CIB-SIT Build-Offshore

Project Description: The Standard Bank of South Africa Limited is one of South Africa's largest financial services groups. It operates in 32 countries around the world, including 19 in Africa.

The program is to set up a new testing environment. TCS responsibility is to set up database supporting banking application, deploying existing application in new environment with integration testing.

Responsibilities:

Monitoring Work assigned to team.

Prepared Test design of Oracle Applications.

New SIT(Testing) environment set up with database design & deploying banking Oracle applications.

Extensively worked on Informatica Power Center Components such as Mapping and Mapplet Designer, Repository Manager, Workflow Manager, Workflow Monitor.

Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.

Testing deployed code to full fill business requirements.

Control M job testing and fixing job run issue in new testing environment.

Fixing issues in database objects to support new environment set up.

Performance testing of the deployed banking oracle application.

Solving client issues.

Tools/Technologies: Oracle SQL, PL/SQ, Oracle Forms & Reports 10g, Control M tool, Unix.

Company :Tata Consultancy Services Limited (TCS)

Client :Tata Communication Limited, Hyderabad, India

Feb 2013 to Sep 2013

Senior Developer

Project: Geneva (IRB) Telecom Billing System

Project Description: Tata Communications Limited (TCL) is the dominant telecommunications Services provider of a new world of communications (Providing Internet Service).

Responsibilities:

Work Plan Allocation for Release CRs.

Involvement in Generic Product CR Development.

Prepared Test design of Custom modules.

Designing of database creating Procedures, Functions, Triggers, Cursor required for these modules.

Testing Developed Billing CR.

Requirement and Risk Analysis based on Design Documents.

Development of CR using PL/SQL & IRB billing tool.

Unit and performance testing of the developed CR.

Solving client issues.

Solving defect raised by the testing team on the developed CR.

Tools/Technologies: IRB 4.3, Oracle SQL, PL/SQL.

Company :Tata Consultancy Services Limited (TCS)

Client:STC, Hyderabad, India

Aug 2011 to Dec 2012

Test Analyst

Project: BCCS IRB Upgrade & Siebel Analytics, BO (Business Objects)

Project Description: Saudi Telecom Company (STC) is the dominant telecommunications services provider in the Kingdom of Saudi Arabia. STC’s service offerings include fixed line and 3G wireless telephony, data services and other value-added services. With offices all over Saudi Arabia and the headquarters at Riyadh, STC has a wide existence across Arab nation. The program is to upgrade the existing billing system IRB from V2.2 to V5.17. TCS responsibility is to implement the upgrade changes in the custom modules and give support to Convergys during the billing system upgrade & Providing Billing Report & Siebel Report to Client using Siebel Analytics Tool.

Responsibilities:

IRB billing report development.

Helping Migration team in migrating reports using BO XI R2(Business Objects)

Data Modelling.

QUALITY Management

Solving defect raised by the testing team on the developed CR.

Tools/Technologies: IRB 5.2, Oracle PL/SQL Developer, QC, Siebel Analytics, Informatica Power Center 8.

Company :Tata Consultancy Services Limited (TCS)

Client :BSNL, Hyderabad, India

July 2008 to November 2010

Developer

Project: BSNL CDR Project

Project Description: To integrate CRM(Siebel) with Kenan Billing System to create an order/account for the customer. Application Programming interface (API) deals with the integration of CRM and kenan billing in order to create an account for the customer in kenan database and store the billing information.

Responsibilities:

Understand the client requirement. Estimation of effort for the requirements.

Develop the API’s for the integration between CRM and billing.

Develop Web Services to call the Kenan API’s and deploy them on the Oracle Application Server.

Designing of database creating Procedures, Functions, Triggers, Cursor required for these modules.

Tools/Technologies: Kenan Billing, Oracle PL/SQL Developer, QC

Company :Tata Consultancy Services Limited (TCS)

Client :Procter and Gamble, Hyderabad, India

Oct 2005 to June 2008

Developer

Project: P&G

Project Description: Procter and Gamble has worldwide operations in the business areas like Manufacturing, Distribution, etc. P&G markets approximately 300 brands to nearly five billion consumers in over 140 countries .The project is a Data Ware House Project using STAR Schema, it is aimed at developing new reports, scripts to build temporary tables, performance tuning, developing excel macros which help in displaying the report in a good format and enhancing the various reports that have been developed as part of the Data Delivery System of P&G. Menu feature, Drill down facility and special calculations and graphs will be provided in the Excel Macro.

Responsibilities:

Understanding the client requirements, analysis and study of impact.

Design and Development of reports

Bug fixing.

Designing of database creating Procedures, Functions, Triggers, Cursor required for these modules.

Preparation of test cases and carrying out Unit Testing.

Development of aggregation scripts (shell scripts) to aggregate the data in the fact tables and create report specific temporary tables and performance tuning of Queries.

Knowledge sharing at project level.

Development of Macros to populate the report in excel sheets.

Tools/Technologies: Oracle Reports 6i, Formatter, Oracle 8i.

Contact this candidate