SUMMARY

• 7+ years of Software Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support ofData Warehouse Applications.
• Strong experience in development and implementation of business intelligence solutions in Data warehouse/Decision Support Systems using Informatica Power Center 9.1/8.6.1/8.1 - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager, OLTP, OLAP.
• Experience in loading, testing, and migrating data in different environments using Oracle 1og/9i, Oracle PL/SQL, SQL*Plus, SQL*Loader, IBM DB2 8.0/7.0, MS SQL Server 2008
• Strong knowledge of data analysis, metadata, data quality, and data design and reporting.
• Extensive experience in management of large quantities of both structured and unstructured data
• Strong knowledge and implementation of data warehousing concepts including Bill Inman Methodology, Ralph Kimball Methodology, Star Schema, Snow Flake Schema,OLAP, EDW, Data marts, Normalization, Dimension and Fact tables
• Excellent Skills in Application performance tuning, Application testing, Code Reviews & walkthroughs.
• Strong knowledge of Enterprise Application Integration, Web Services and messaging systems, and Business Process Management.
• Worked on Administration of Informatica PowerCenter
• Extensive domain knowledge of Financial, Investment, and Healthcare sector
• Strong experience inError Handling andTroubleshooting Techniquesusing various log files, and debugging Informatica mappings, mapplets, sessions and workflows.
• Excellent analytical skills in understanding the client Organizational Structure
• Proficient in analysis of user requirements and functional specifications
• Strong emphasis in reviewing End-to-End test requirements, assigning appropriate resources, and initiate the End-to-End planning process ensuring client deliverable within committed deadlines
• Implemented performance tuning at mapping, session, and workflow level in Informatica to enhance the performance which reduced the data loading procedure from 24 hours to 7 hours and received client appreciation
• CreatedReusable Tasks including Sessions, Command, EmailandNon-Reusable Tasks including Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control as a part of warning or alert in case if data load fails
• Worked with front end application support team and developed the user interface for clients using Oracle Business Intelligence Enterprise Edition tool
• Proposed and implemented new business logic with client agreement to avoid complete data warehouse collapse
• Achieved numerous client appreciations due to excellence in ETL Informatica development and implementation
• Strong knowledge of developing Business Intelligence Solutions in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Extensive experience in developing Business Intelligence Solutions in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Highly proficient in constructing Triggers, Tables, stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity using T- SQL.
• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
• Experienced in Database design using Normalization Forms, Entity Relationship Design (ERD) Model and application oriented design.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Experienced in migration of Data from Excel, Flat file, Oracle to MS SQL Server using MS SQL Server DTS and SSIS.
• Highly enthusiastic and motivated Informatica developer, excellent team player with strong work ethics, strong initiative and quick learner of new technologies
• Excellent interpersonal and communication skillsin dealing with clients

TECHNICAL SKILLS

Programming Languages: SQL, T-SQL, PL/SQL, C, C++, VB 6.0,Perl, CSS, HTML, XML, UNIX

Databases: SQL Server 2012/ 2008/2005/2000/7.0, Oracle 10g/9i/8.x, DB2, MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: INFORMATICA, SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Data Stage, Import Export Data, Bulk Copy Program (BCP), FACETS.

Version Control: Team Foundation Server (TFS), Visual Source Safe (VSS)

Operating Systems: Windows /98/2000/2003/XP/Vista, Unix.

IDE & BI Tools: SQL Query Analyzer, SWIFT Tool, ERwin, SQL Enterprise Manager, SQL Server Management Studio (SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio (BIDS), Power Pivot.

Design Methodologies: Logical and Physical Database Design, UML (Unified Modeling Language), Database Design and Normalization, Data Modeling, 1.1 using Rational Rose.

Other Software: MS Office 2007/2003/2000, Adobe Professional, SharePoint, Autosys, Serena ChangeMan, Harvest Version Control

PROFESSIONAL EXPERIENCE

SQL Server (SSIS/SSRS) Developer

Confidential, Denver, CO

Responsibilities:

• Analyzed user requirements and Provided the task breakdown and estimation, cost of the development
• Created new schema and database objects
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access and Excel.
• Read data from various sources and integrated together for storing it into a datamart using Informatica.
• Created and incorporated business logic using complex Mappings, Mapplets and Reusable Transformations
• Developed Slowly Changing Dimension (SCD) Type 1, Type 2, and Type 3 mappings to incorporate ETL logic
• Loaded and tested data in Dev, Test, QA, and Production environments
• Kept record of all deliverables and maintained coding standards
• Developed Unit Test cases based on real time scenarios to test the implemented ETL logic in Informatica
• Designed and developed database solutions based on functional requirements. Designed and developed SSIS (ETL) packages to Validate, Extract, Transform and Load data from OLTP system to the Data warehouse.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages
• Configured Reporting Services in SQL Server 2012.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, recovery and Disaster recovery procedures.
• Planned the complete Back-up of various databases for disaster recovery scenarios.
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Created different Parameterized Reports (SSRS 2008/2012) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into databases.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations, Suggested backup strategies.
• Co-ordinated with Client and managed work among the team members for On-Time delivery

SQL Server Developer

Confidential, New York, NY

Responsibilities:

• Analysed, Designed & Created of database objects to incorporate the business logic
• Extensively involved in requirements gathering, writing ETL Specs and preparing design documents
• Read Oracle tables using Informatica tool.
• Developed complex Mappings, Mapplets and Reusable Transformations to facilitate daily changes of Data into Oracle.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Used various transformation including lookup, joiner, sequence generator, router, filter, rank, aggregator etc.
• Developed Slowly Changing Dimension (SCD) type 1 and type 2 dimensions
• Parameterized mapping, session, and workflow to achieve flexibility.
• Automated Parameter file using Informatica mappings
• Created tasks including Decision, Event Wait, Event Raise, Timer, and Email to achieve timely data loads and report the data processing failures
• Developed and implemented unit test cases
• Created Weekly, Monthly and Yearly Business Monitoring reports
• Coordinated with Autosys team to schedule Autosys jobs
• Extensively worked on Informatica versioning like check in, check out, purge object version to view version history and maintain version control of the objects
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
• Migrated the data from an Access database to SQL Server 2008.
• Fetch the data from Oracle 10g by creating a linked server and use SQL Server to query Oracle database.
• Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
• Created tables, temporary tables, table variables, indexes, procedures, views and triggers for automating various tasks in TSQL.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard and SQL Sentry plan explorer.
• Developed forms on share-point to show data from data-sources to Clients and enabling them to edit the data and update the data in the data-sources and allowing inserting data into the data-sources.
• Created reports on to Share-Point and Report Server and set the data-driven subscriptions for these reports.
• Created the documents and packages in Team Foundation Server as a version control.
• Fine-tuned SQL queries for maximum efficiency and performance.
• Configured the report viewing security for various users at various levels using Report Manager.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.

SQL Developer

Confidential, Pittsburg,PA

Responsibilities:

• Gathered the business requirements from the end user of business
• Found the requirement gap and resolved them by having discussion with clients
• Generated Data Profiles and analyzed of source system data and created schema objects, rules and granted roles to the users. Used SQL Profiler to debug T-SQL and slow running queries.
• Found the risk and issue during the requirement and design phase
• Provided support in preparing the ETL Architecture for the project
• Designed the integration of the ETL process from source landing server to the load process
• Designed the ETL low level design document and unit test cases
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes).
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Implemented Auditing using triggers. Monitored the Database Performance using execution plans and Index tuning.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Wrote Ad-Hoc T-SQL queries for analysis purposes
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Tuned the Informatica mappings for optimal load performance.
• Extracted the source data to feed the staging, Operational and warehouse tables using Informatica Server manager.
• Investigated, analyzed, and documented the design as well as business related defects
• Migrated the code into QA environment using Informatica workflow designer objects including different workflows, series and parallel dependability sessions
• Conducted the User Acceptance Testing from the end user.
• Resolved the defect which has been identified for the period of UAT and system testing
• Deployed the ETL code into production

SQL Developer

Confidential

Responsibilities:

• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager
• Created complex mapping designs using various tools in Informatica Designer such as Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance
• Extensively used workflow variables, mapping parameters and mapping variables
• Developed the architecture and performance tuning for enhanced processing of data flow
• Developed the complete flow with the ETL design documents for the project
• Prepared migration document to move the mappings from development to testing and then to production repositories
• Designed and Developed Database Objects Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed tested and implemented Referential Integrity rules and regulations through constraints, triggers, views and partitioned views.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse.
• Created SSIS package to load data from Flat File to Data warehouse using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension
• Develop SQL Scripts to dynamically manipulate data and generate well-formatted reports based on user requirements.
• Test, modify and/or debug internally developed reports and stored-procedures.
• Designed and developed the required SQL stored procedures and database functions using SQL Server 2008.
• Involved in performance testing. Involved in performance tuning, query optimization Involved in Import and Export of data between various sources and destinations using SSIS, BCP and Bulk Insert.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports
• Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services
• Created jobs using SQL Server Agent and generated SSRS (SQL Server Reporting Services) reports as a part of each job.
• Involved in the implementation of Performance Point Server (PPS).
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through AutoSys.