SUMMARY:

• Senior Informatica/MSBI Developer with 10 years of experience
• Microsoft Certified Technology Specialist Professional with demonstrated work experience in developing and implementing business technology applications, systems integration and testing solutions with in - depth domain knowledge of industries like Life Science, Healthcare, Insurance etc., and skills including, but not limited to, software analysis, design and development.
• Technical expertise in Informatica Power Center Tools, Microsoft Technologies such as MS SQL SERVER 2005, 2008 R2, 2012, 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Oracle 10g,11g, Trizetto FACETS.
• Worked extensively on designing and development of the backend database objects Like: Entity Relationship Diagram, Tables, Table Types, Stored Procedures, User defined functions, Triggers, Views etc. to support the development and testing of web based and windows applications
• Strong accomplished experience in Informatica, SSIS and SSRS development in a data mart environment and Unix Shell scripting.

  Proficient in SSIS, MS SQL server and SQL programming.

• Certified from Big Data University on Big Data Fundamentals.
• Experience in creating the backend SQL Server jobs and schedulers using SQL Agent, Dollar Universe, Cisco TIDAL and Control M enterprise job schedulers.
• Good expertise in query tuning and optimizing database code and developing batch processing.
• Strong knowledge of Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile Scrum.
• 2+ years of experience in Agile Development Model (Scrum). Current project is being worked using Agile SDLC model.
• Hands on work experience in Informatica Power Center ETL tools like Designer, Workflow Manager, Workflow Monitor and Repository.
• Experience in Trizetto FACETs on Healthcare billing and enrollment module.
• Hands On experience on Red Gate tool for the comparison of database objects and data across different servers and environments. Also used this tool as data generator to provide some test data to support application development.
• Experience in scheduling jobs in Tidal enterprise job scheduling tool.
• Interacted with the team members to analyze and understand the issues to fix it in the system.
• Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions coupled with excellent communication and interpersonal skills.
• Experience in working with EDI 834 and EDI 837 transactions
• Experience working in Tableau for reports development and publish using Tableau Desktop and Tableau server.
• Effective in working independently and collaboratively in teams.

TECHNICAL SKILLS:

Programming Languages: T-SQL, PL/SQL, Oracle

Software s: MS- SQL Server 2005/2008/2012/2014, SSIS, SSRS, Oracle 10g, 11g, C#, ASP.NET, Unix shell scripting

IDE: VS2012, VS2010, VS2008

Version Control: Team Foundation Server, VSS, Tortoise SVN

Database/ETL Tools: SQL Query Analyzer, Management Studio, Query Editor, SQL Profiler, TOAD, Trizetto FACETS, Informatica Designer, Informatica Workflow Manager, Informatica Workflow Monitor, Informatica Data Validation Option (DVO), SQL Agent, Red Gate and $Universe, Cisco Tidal and Control M enterprise job scheduling Tools, Enterprise JIRA, Confluence - Team Collaboration Software by Atlassian, Zephyr Test Management Tool, IBM- Rational Team Concert (RTC), CTU Code Deployment Tool, Unix Scripting, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, VA

Senior Informatica/MSBI Developer

Environment:: Informatica Power Center Tools, SQL Server 2014/2012, SQL Server Integration Services (SSIS), Business Intelligence Development Studio, Visual Studio 2012/2013, FACETS, Tidal and SQL Server Reporting Services (SSRS).

Responsibilities:

• Worked on developing an ETL process for the Billing and Finance modules such as Power Account Reconciliation (PRF), Delinquency Letters extract for the State to send Delinquency Letters to members, Invoicing extract Pay No Pay, App day extract and Legacy Indiana members billing load from Central Region FACETS to GBD FACETS, 820 Payment Intake receipts and refunds.
• Worked on Medicaid Data Migration Project which involved Medicaid data from Legacy Central Facets to GBD Facets.
• All the aforementioned processes are built with complex Informatica Mappings, Data Quality and Workflows as well as SSIS Packages
• Design and develop AGP custom tables, stored procedures and Triggers in Oracle and SQL server
• Develop LINUX scripts to automate the load process
• Working closely with business analysts and transform business requirements into Database designs and develop user stories and acceptance criteria
• Working on performance tuning for the existing stored procedures
• Scheduling jobs using Tidal enterprise job scheduling tool and deploying them to QA and PROD
• Working on Trizetto FACETS UI and Database in Billing and Finance modules
• Worked on generating Invoice and Delinquency letters out from FACETs database and transfer the flat files to external letters and bills printing vendors(TransCentra)
• Worked on creating End User Operational reports using SSRS with subscriptions as required
• All these process I developed above were tested by business team in QA and there was not even a single defect found post QA deployment. Received an appreciation notes from both solution architects and business analyst
• Created a code review template document for Informatica, SSIS and SSRS and shared among the team members to make sure all developed codes are peer reviewed before migrating to higher environments
• Being the active developer in the scrum team with Agile software development model
• Created a comprehensive coding standards and naming conventions document for the team to follow and got appreciated by Database Architects and managers.
• Analyze, design, program, debug, and modify complex software enhancement features and/or new software products
• Manage technical development of software from inception through user acceptance, including projects which affect multiple departments
• Preparing the different levels of reporting needs such as summary, detail, relative time and hierarchical relationships
• Resolving technical and/or business problems, and continuous improvement to data design, reports and/or processes
• Perform data analysis and mapping for data integration
• Perform code reviews, assist with refactoring, and provide guidance and mentoring to other development engineers

Confidential, Nashville, TN

Senior Informatica/MSBI Developer

Environment:: Informatica Power Center Tools, SQL Server 2012/2014, SQL Server Integration Services (SSIS), Business Intelligence Development Studio, Visual Studio 2013, SQL Agent, Red Gate and SQL Server Reporting Services (SSRS).

Responsibilities:

• Collaborating with business users to understand and deliver their reporting needs
• Converted business requirements into Report design document
• Created complex Informatica mappings and workflows to transfer the data from OLTP to OLAP database for reporting
• Creating Stored Procedures to be used to generate the reports
• Assisting the QA team in creating and validating reporting parameters and deliverables
• Created and shared the BI reports best practices document to the team members in short span of time
• Tuned long running Informatica workflows for better performance
• Created Informatica mappings with almost all the transformations involved
• Worked on creating reusable Informatica tasks which was leveraged across the teams
• Experience with Tableau for presentation layer and dashboards
• Developing complex stored procedures, SSIS packages and SSRS reports
• Extracted data from various sources like SQL Server 2012/2014, Oracle, CSV, Excel and Text file from Client servers and through FTP.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and long running queries by checking appropriate changes to Transaction Isolation levels
• Manage existing data models and create/modify models to meet new functional requirements.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Created SSIS packages to extract data from external systems with various transformations used.

Confidential, Louisville, KY

Senior SQL/SSIS Developer

Environment:: Informatica Power Center Tools, SQL Server 2012/2008, SQL Server Integration Services (SSIS), Business Intelligence Development Studio, Visual Studio 2010/2008, Informatica Power Center, Red Gate and

Responsibilities:

• Used Microsoft SQL server technology extensively for data retrieving, querying, storage and manipulation.
• Involved in creating multiple parameterized stored procedures which were used by external services to map with the UI.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Working experience in SQL Server Integration Services and Informatica mappings and workflows creation for complex ETL process. Worked on ETL and server maintenance packages
• Hands on experience in using Red Gate tool for Data compare and DB objects compare to synchronize two database environments. Generating DB scripts for Production Turn for Enterprise releases.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Worked in creating configuration files to deploy the SSIS packages across all environments.
• Involved in the Conversion of SSIS packages from SSIS 2008 to SSIS 2012.
• Designed SSIS Packages to transfer data as nightly ETL from flat files to SQL Server using Business Intelligence Development Studio.
• Provided effective Resolution and resolved the incident for the customer within the time line allotted and Daily SCRUM meeting with client.
• Performed unit testing and integration testing by applying test cases and also written test cases by using Test Driven Methodologies.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Working with the business users team for User Acceptance testing and ensuring that all the UAT test cases are successful
• Also had hands On Database Administration activities
• Extensively worked on query performance tuning and following best practices in the database objects development and maintenance.
• Worked in scheduling SQL jobs in SQL Agent and $Universe job scheduling tool with SSIS 2012 packages.

Confidential

Senior Database Developer and Junior DBA

Environment: SQL Server 2008, Oracle 10g, Oracle E-Business Suite, SSIS, DTS

Responsibilities:

• Managing and Creating Database objects like Stored Procedures and Functions for Contract Inbound and Outbound processes
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Optimized query performance by creating indexes.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles and grant privileges to users and roles.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL.
• Involved in Database Tuning to make sure there is no DB locks and waits for complex queries.
• Implemented Database Mirroring, Database Snapshots.
• Creating logins, users and configuring permissions and assigning roles to users
• Taking weekly database backup and schedules job using SQL Agent.
• Involved in Backing up and Restoring of databases in development environments.
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
• Created DTS Package to transfer data from the Oracle source database.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.

Confidential, Fort Worth,TX

Environment: SQL Server 2008, SSIS, SSRS

Responsibilities:

• Participated in Requirement Gathering sessions with end users

• Created Technical Design for the application working alongside with Infrastructure team
• Involved in application development, Peer reviews and Unit Testing
• Responsible for writing Stored Procedures .
• Responsible for ETL operations within the Engineering groups including client feeds and Data ware house systems.
• Created SSIS packages to transfer data between OLTP and OLAP databases
• Creating and Managing Database Objects like tables, triggers, Indexed Views and configured Database Mail for notifications.
• Providing SQL database support to the application developers.
• Create d Entity Relationship (ER) Diagrams to the proposed database models