PROFESSIONAL SUMMARY:

• Almost 8 plus years of IT experience in Full life cycle of Software Development (SDLC) including Business Requirement Gathering & Analysis, System Study, Application Design, Development, Testing, Implementation, System Maintenance, Support and Documentation.
• Proficient using Data Warehousing, Informatica Power Center 9.1/ 8.6.1/7.1, and Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository manager), Knowledge of scheduling tools like Control M, UNIX CRONTAB Scheduler.
• Expert working with Database using Oracle 10g/9i/, MS Access, PL/SQL, Complex Stored Procedures, Triggers, SQL Server.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008/2012.
• Experience in Data Warehouse Development environment using Microsoft DTS, SSIS and SSRS.
• Extensive expertise in SQL Server technologies like MS SQL Server 2005/2008/2008 R2/2012/2014 suite of products like SSRS, SSAS and SSIS including development, deployment, testing and support.
• Good knowledge of Dimensional Data Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Good Knowledge of OLTP and OLAP Concepts and knowledge of Ralph Kimball data warehousing methodologies.
• Have Good Exposure to Teradata DBA utilities Teradata Manager, Work load Manager, index wizard, Stats Wizard and Visual Explain.
• Good knowledge of data profiling concepts and Knowledge on Data Processing, Data Cleansing, Data Validation and Data Archiving Process.
• Extensive experience in Performance Tuning, identifying and resolving performance bottlenecks of targets, sources, mappings, coordinate with DBAs for ETL tuning.
• Solid experience in writing SQL queries, PL/SQL, Stored Procedures, and optimization.
• Complete knowledge of migration process to different environments.
• Experience in mentoring and providing knowledge transfer to team members, support teams and customers.
• Have strong Conceptual and Logical Data Modeling skills and have experience for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Have excellent written and oral communication skills with the ability to communicate appropriately in business and technical situations at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6/7.1

Reporting Tools: OBIEE 10G

Data Modeling Tools: Erwin 3/ 4

Scheduling Tools: Informatica Scheduler, Autosys, DAC, UNIX Crontab

Database Tools: SQL Server Enterprise Manager, SSIS, SSAS, SSRS, BIDS

Data Modeling: Relational, Dimensional (Star, Snowflake Schema)

Oracle Utilities: TOAD, SQL Loader, SQL* PLUS, SQL Developer

Performance: TuningSQL Tuning, Explain Plan, Table Partitioning, Materialized views, Hints, Indexing, and SQL - Trace

RDBMS: Oracle 10g/ 9i, SQL Server 2005/2008/2008 R2/2012/2014, MS Access, Teradata

Environments: Windows NT/98/95/2000/XP, UNIX (Sun Solaris)

Languages: SQL, PL/SQL, C, expose to Java/J2EE, Unix Shell scripting

PROFESSIONAL EXPERIENCE

Sr. SQL Server Developer

Confidential, Brentwood, TN

Responsibilities:

• Use Bulk data movement/ETL to Extract, Transform Load (ETL) development; Design and develop new SQL code as part of an ETL process scalable for transferring more than billion records efficiently
• Converting DTS packages on SQL Server 2000 to SSIS 2016.
• Improve SQL procedures, Window services / .NET programs which transform and load data
• Develop stored procedures functions using T-SQL; Responsible for data profiling, source-target mappings, ETL development
• Responsible for design, development and maintenance of User Authentication and Authorization database solutions
• Provide technical analysis, design specifications and recommendations for User and Application Security; Analyze high volume data sets for data transfer, data integrity and erroneous data
• Developed stored procedures functions using T-SQL; Responsible for data profiling, source-target mappings, ETL development
• Monitor data transfer error logs to analyze errors, infer patterns and identify critical errors; SQL performance tunings and optimization, testing and implementation; Provide business and technical analysis, development and documentation
• Developed detailed technical specifications and ETL documentation in collaboration with application and solution architects; Design and develop ETL code, ETL audit control and scheduling processes and collaborate on testing strategy and testing
• Work in close collaboration with Quality Analysis teams onshore and offshore to provide support for QA environment issues, root cause analysis and recommend solutions.
• Providing Impact Analysis on one of the distribution server

SQL Server Developer

Confidential, Phoenix, AZ

Responsibilities:

• Involved in gathering and understating business requirements.
• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Powercenter 9.1.
• Created and Documented ETL Test Plans, Test Cases, Expected Results, Assumptions and Validations.
• Develop, test and maintain ETL procedures employing both ETL tools and custom PL/SQL.
• Designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Created configuration files to deploy the SSIS packages across all environments.
• Designed SSISPackagesto transfer data from disparate sources to SQL Server using Business Intelligence.
• Converted SSIS code into Informatica mappings, sessions and workflows.Handled versioning and dependencies in Informatica.
• Worked with Data modeler to restructure the data mart according to changes in the model and also worked on changes in the Informatica converting business needs to technical coding.
• Created views, triggers, stored procedures and functions for analyzing data.
• Created and configured the sessions for work flow. Created and maintained parameter files for workflows in UNIX.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules usingT-SQL.
• Worked on Joiner, Aggregator, Update Strategy, Router, Lookup, XML, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Implemented slowly changing dimensions - Type I, II & in different mappings as per the requirements.
• Developed reports using OBIEE answers and dashboards.
• Created data models using Erwinand did changes to existing data models.
• Created tasks, Subject Areas, and Execution plans in DAC.
• Setting dependencies between tasks and executing the Execution plans.
• Created connections for relational, Non-relational and applications in the workflow manager.
• Created mappings using Reusable Transformations and mapplets.
• Created and maintained Technical specification documents.
• Created and maintained production support documents.
• Worked on onsite and offshore team coordination.
• Wrote UNIX shell scripts for handling various files.

Technologies: Informatica Power Center 9.1, SQL Integration Services (SSIS), Erwin, OBIEE 10G, DAC 10G, Oracle 11g, UNIX, Shell scripting, Toad, Windows.

SQL Server Developer

Confidential, Charlotte, NC

Responsibilities:

• Designed and developed ETL mappings to load data from SQL Server, Oracle, Copy books and Flat File System of records into Oracle and Teradata database using Informatica PowerCenter version 9.6.1.
• Closely worked with Data Analysts and Data modelers to understand the Business Requirements and data elements.
• Worked with Java based Offshore Team to design and build an automation framework which automatically generates ETL informatica Workflows (XML Files) using Informatica Java API.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created Unix Scripts for record count and delimiter count validation of flat file sources.
• Used Autosys for Scheduling the Informatica Workflows.
• Involved in creating the Functional Specification Documents.
• Extensively used informatica debugger to figure out the problems in mappings.
• Used SQL Developer for writing and executing Complex Queries.
• Created Mapping parameters and variables and used them in different parameter files.
• Coordination with offshore ETL team included assigning daily task, mentoring and getting status updates.

Environment: Informatica 9.6.1, SQL Server 2005/2008, Oracle 11g, UNIX, Autosys.

Metadata Manager

Confidential

Responsibilities:

• Involved in creating the Business Glossaries which includes the Business Terms, Attributes and Business Rules.
• Worked on creating the lineages to check the flow from source to target, which contains the information of informatica workflows, source files, and source and target databases.
• Involved in upgrade from 9.1 to 9.6.1
• Worked on Informatica Analyst tool which is a new feature for creating and updating Confidential as part of 9.6.1
• Hands on creating custom resource file.
• Performed Migration of databases from SQL 2000 to SQL 2005 using SSIS
• Loading Confidential into Metadata Manager.
• Linking Business metadata to Technical Metadata.
• Performed loads on databases and informatica servers to see the updates.

Environment: Informatica Metadata Manager 9.1/9.6.1, SSIS, Informatica Analyst tool 9.6.1

Confidential

SQL Database Developer

Responsibilities:

• Worked closely with the Applications Development and Project Management teams coordinating, scheduling and implementing.
• Participated in the entire Software Development Life Cycle (SDLC) phases including Data Analysis, Design, Coding, Testing and Deployments.
• Translated business, and functional requirements into technical document specifications.
• Extensively worked on Informatica Designer, Workflow Manager, and Workflow Monitor.
• Created expedited, emergency and standard RFC for code changes in Production.
• Created ETL mappings and Mapplets to extract data from source systems into Oracle.
• Created different transformations for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table
• Worked on connected and unconnected lookups.
• Analyzed/Profiled the source data and involved in the gap analysis and implemented rules to cleanse the data.
• Designed Logical & Physical Data Modelling using different tools such as Erwin.
• Created different shell scripts and used them as pre/post session commands
• Implemented error logging logic to capture the rejected/wrong data in the mapping for further analysis.
• Create/Maintain database stored procedures, functions, packages, views, types, tables.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Used Autosys for scheduling the jobs
• Used Unix shell scripts for invoking Teradata utilities Fload and MLoad
• Produced a Unit test Document, which captures the test conditions and scripts, expected/actual results
• Created Measures in Teradata, and these measures in different aggregation levels
• Closely worked with Business Objects (BO) team to ensure proper data in the reports
• Designed and Developed the Informatica workflows/sessions to extract from Flat Files, transform and load the data into Oracle.

Environment: Informatica 8.6, Oracle 11g, Teradata, Autosys, Erwin, SQL Developer and UNIX.

Confidential

Database Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications in the development.
• As a member of data warehouse design team, assisted in creating fact and dimension tables based on requirement of the project.
• Extensively involved in ETL code using Informatica tool in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Informatica Designer to create complex mappings from Business requirements.
• Created various transformations like filter, router, lookups, stored procedure, joiner, update strategy, expressions and aggregator to pipeline data to Data Warehouse/Data Marts and monitored the Daily and Weekly Loads.
• Created Mappings, Mapplets, Sessions and Workflows using Informatica Power Center 8.6.
• Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
• Created reusable Mapplets and transformations in Informatica.
• Worked with health payer related data such as customers, policy, policy transactions, claims.
• Generated weekly and monthly report status for the number of incidents handled by the support team.
• Extensively used multiple data providers for building reports.
• Involved in documenting the changes to the universe and reports functionality.
• Used combined query functions, sub queries, Grouping, Custom sorts.
• Performed Unit Testing and worked with the end user at various stages of the test cycles.

Environment: Informatica PowerCenter 8.6, Oracle 9i, SQL* Loader, HP UNIX.