Sathya Bodicherla

Email: ac2tt7@r.postjobfree.com Phone: 469-***-****

Professional Summary:

Have 5 Years of Professional IT experience especially in PLSQL/TSQL, ETL and SSRS reporting development.

Have good experience in database design and development of applications with Business Intelligence (BI) tools using Oracle SQL, Informatica 9.1/9.5, MS SQL Server 2012/2014, Integration Services (SSIS), Reporting Services 2012/2014 (SSRS).

Extensive experience with SQL Stored Procedures, Functions, Packages, Tables, Views, Complex SQL Queries, Indexes, Triggers, Functions, SQL Performance Tuning.

Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and flat files like fixed width and delimited.

Extensively used ETL methodology for supporting Data Extraction, transformation and loading, in a corporate-wide-ETL Solution using Informatica Power Center BI tool and SSIS Data tools.

Experienced in data cleansing, validation and testing while developing ETL and reporting solutions and for both backend and front end applications as well.

Have good knowledge of ASP.NET/C# solutions, Web services and BI Tools like Power BI.

Process oriented and has excellent understanding of SDLC process, have ability to learn things quickly and implement.

Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.

Technical Skills:

ETL

Informatica 9.1/9.5, SSIS 2012/2014/2016

Data Modeling

Relational Data Modeling, Dimensional Data Modeling, Star Schema, Snow-Flake Modeling, Fact and Dimensions Tables, Erwin 7.0, SSAS

Databases & Tools

Oracle 11g/10g/9i, MS SQL Server 2012/2014

Reporting Tools

SSRS 2014/2016

Languages

SQL, PL/SQL, T-SQL, UNIX Shell Scripting

Web

CSS, HTML, XML, Web Services(WSDL), SOAP

Schedulers / Querying tools

Quest Software TOAD, Oracle SQL Developer, MS Visual Studio, SQL Server Management Studio, SQL*Loader

Testing Tool

Mercury/HP Quality Center 9.2

Certification:

Microsoft Certified Professional – Querying MS SQL Server tools 2012

Education:

Bachelor of Technology in Computer Science from Acharya Nagarjuna University, India.

Post Graduate Diploma in Management specialized in HR and Business Intelligence from Siva Sivani Management Institute, India

Detailed Work Experience:

ETL Developer

Care Experience, Dallas, TX (April 2016 – Present)

Responsibilities:

Involved in preparing ETL technical specification document and analyzed approaches to work with different source systems like flat files and SQL Server database.

Supported and maintain their existing Informatica Power Center Workflow manager sessions and workflows to run the logic embedded in the mappings.

Extensively involved in creating, enhancing and maintaining several activities of Data Warehouse for modifying target tables as per requirement.

Worked on the performance tuning of existing sessions and mappings.

Generated shell scripts for automated daily load processes.

Creating deployment groups to migrate mappings, sessions, and common objects from development to test and to production.

Worked on migrating Informatica ETL’s to SSIS packages.

Prepared documentation for business data flow from source to targets and also for the migration of ETL’s from Informatica to SQL Server SSIS packages.

Debugging, Troubleshooting, Optimization and performance tuning for ETL process.

Developed complex SQL queries using Case statements, Sub queries and Joins in PL/SQL, created complex SQL stored procedures and functions to meet the user requirements.

Created new databases for the new clients and set up database objects like tables, indexes, procedures and functions in development and production environment and tuned the database performance by updating statistics, restoring and backing logs.

Experienced in user acceptance testing and worked on data cleaning from the patient survey application database.

Troubleshoot the existing data loads and fixed the bugs quickly as per tickets opened by reporting users.

Highly collaborated with manager and team members along with daily stand up meetings and worked under the Agile process.

Worked under the HIPAA Compliance

Technologies/Tools: Informatica 9.5, Oracle, Microsoft SQL Server Data tools 2014/2016, Microsoft SQL Server Management Studio, MS Office 365, Smartsheet

ETL Developer

TVA, Chattanooga, Tennessee (Mar 2013 – Feb 2016)

Responsibilities:

Highly experienced in analyzing requirements, designing and developing ETL solution.

Expert in documenting technical specifications and the business data flow from source to targets.

Developed Informatica conversion mappings according to the business rules and imported it through Mapping Architect Visio.

Developed various complex Informatica mappings, mapplets and reusable transformations for loading data into data warehouse.

Worked and supported Maximo and Primevera near real time projects by loading source data into staging tables by using CDC Power Exchange loggers.

Implemented SCD Type1 and Type2 method in ETL mapping to load data into EDW.

Created different transformations like Expression, Sorter, Aggregator, Router, Filter, Lookup, Sequence Generator, XML Generator, XML Parser, Webservices, SQL, Joiner and Update Strategy transformations for loading the data into the targets.

Created web services request-response mappings by importing source and target definition using WSDL file.

Created conversion scripts using Oracle SQL queries, functions and stored procedures, test cases and plans before ETL migrations.

Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.

Experienced in migrating mappings, sessions, workflows and common objects from development to acceptance and to production.

Have exposure in building SSIS packages to create ETL process and load data into SQL Server database for some of the SSRS Reporting requirements.

Created SQL Jobs to execute SSIS packages and publish data on the web server.

Deploying, Scheduling and Monitoring SSIS Packages in the development, acceptance and production environments.

Debugging, Troubleshooting, Optimization and performance tuning for SSIS packages.

Created new database objects like procedures, functions, packages, triggers, indexes and views using T-SQL in development and production environment for SQL server 2008/2012.

Responsible in handling on-call production support to fix the incidents on timely manner.

Extensively used debugger tool to fix bugs and defects.

Technologies/Tools: Informatica 9.1/9.5, MS SQL Server Integration Services 2008/2012, T-SQL, MS SQL Server Reporting Services 2008/2012/2014, Microsoft Visual Studio 2008/2010, Windows XP, Unix.

SQL Developer

DSR Management Inc., Chicago (Oct 2012 – Feb 2013)

Responsibilities:

Analyzed gathered requirements from the client and translated the business design into technical design with the assistance of the lead developers

Developed complex PL/SQL procedures and functions to load the data from external accounting system database into CATS database.

Created database objects such as tables, views, synonyms, indexes, sequences and database links as well procedures as per the business requirements.

Extensively used user-defined exception handling in PL/SQL.

Performed SQL tuning with analyzing explain plans, creating necessary indexes and removing unwanted indexes.

Replication functionality was utilized to make replica of database tables to ensure reporting database always had current data.

Troubleshooting production problems and worked effectively with other team members to identify and address problem.

Technologies/Tools: Oracle, SQL Server 2008, DDL/DML, PL/SQL, SQL Loader, ASP .Net, C#, Windows NT

Contact this candidate