SUMMARY

• Overall 8+ years of professional experience in system analysis, design, development and testing in various domains executed in Client/Server and Data warehouse environments.
• Expert in creating databases and various SQL server objects like schemas, tables, indexes, indexed view as per the specifications and requirements to meet the business functionality.
• Hands on experience in designing the database model and maintain referenced relationships for the data integrity.
• Expertise in creating complex Stored Procedures (Dynamic and static), effective User - Defined functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.
• Hands on experience with analyzing query plans, extended Stored Procedures, managing indexes to provide quick results for Applications.
• Experience in monitoring and tuning the SQL server database performance using tools like SQL Profiler, Index tuning wizard and database engine tuning advisor.
• Designed SSIS Packages to extract data from various data sources such as Oracle, SQL Server, Access database, Excel spreadsheet, xml files and flat files into SQL Server 2008 for further Data Analysis and Reporting.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications
• Experience in Migration using SSIS/DTS Packages and Metadata Management, migrating DTS Packages to SSIS using Packages migration Wizard and knowledge on Storage Management.
• Excellent work experience on creating packages to handle Incremental loads and slowly changing dimensions to update data in data warehouse using SSIS.
• Experience in logging, Error Handling, Check Points, and Package Configuration to provide the dynamic flow off data to load data warehouse.
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like de-fragmentation, re-indexing, and recompiling in OLTP environment
• Expertise in designing Ad-hoc, Drill-Down, Drill-Through, Matrix, Pivot and Tabular reports to match the needs of the end users by interacting directly with Business Analysts.
• Developed various kinds of graphical reports and scorecards/Dashboards to provide the daily/ weekly and monthly reports to provide a better decision making for the current and future years.
• Proficient in deploying reports and creating subscriptions on the report manager and SharePoint site to provide the access to the specific reports to the business users.
• Hands on experience in Microsoft CRM Reports.
• Creating/Modifying/Locking Logins and Users in Sybase Database.
• Created test scripts in T-SQL to validate data staging tables and OLTP tables to validate the data results on DEV/UAT/Prod environment
• Strong Data Warehousing ETL experience of using Informatica 9.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
• Experience in testing ETL experience using Informatica 9.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Business Objects.
• An excellent team member with an ability to perform individually and interpersonal relationship, good communication skills, hardworking and high level of motivation.

TECHNICAL SKILLS

Operating Systems: Windows NT/98/2000/XP, Windows 2008/10/12 Server, UNIX

Databases: MS SQL Server 2000/05/08/12 , Oracle 9i/10g, MS Access, DB2,SAS

Languages: C, C#.Net, VB.Net, HTML, T-SQL, PL/SQL, Shell scripts

ETL Tools: DTS, SSIS (SQL Server Integration Services), SSDT

Tools: /Utilities: Enterprise Manager, OLTP, SSMS (SQL Server Management Studio), Business Intelligence Development Studio (BIDS), DTA, SSAS, SQL Profiler, ER win, Microsoft Office, MS Visio 2003/2007/2010/2012 , MS Project Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

Reporting Services: SQL Server Reporting Services (SSRS), Crystal Reports 2008, Actuate Report

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Senior Data Analyst/ SQL Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Effectively working on Business Requirement documents to Map client data fields with Database columns and prepare the Technical document to build SQL Scripts.
• Created databases and schema objects including tables, indexes and applied constraints, written functions, stored procedures and triggers.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote powershell Scripts for FTP of files from remote server and backup of repository and folder.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: SQL Server 2012, T-SQL, OLTP, Informatica Power Center 9.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, Autosys

Confidential, MA

SQL Developer

Responsibilities:

• Data migration using import and export procedures from Excel to SQL server.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Oracle database
• Excel spreadsheet and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Secured and Configured SSIS packages for deployment to production using Package configurations and Deployment Wizard.
• Created/Modified T-SQL batches, database scripts, indexes, stored procedures, views, tables, and triggers, table-valued and scalar functions.
• Performed optimization of T-SQL stored procedures by analyzing execution plans, creating proper indexes and employing SQL profiler and Database engine tuning advisor in OLTP environment
• Providing SQL Scripts and SSIS Packages and .read me file through the GIT (Open source control system) tool for better speed and efficiency and keep all Environments (Development, Staging, Prod/UAT, Production) in Sink

Environment: MS SQL Server 2012/2008R2, T-SQL, OLTP, SSIS-2012, Visual Studio 2012, MS Office 2010/2013, VISIO 2010, Red Gate Tools

Confidential, RI

SQL Developer

Responsibilities:

• Worked closely with Business Analysts and Application Developers to produce all required documentation.
• Create functional and technical specifications for projects
• Involved in gathering and analysis of user requirements.
• Create documentation as required.
• Migrating Sources from Mainframes to SQL Server.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various tasks and transformations such as ExecuteSQLTask, Execute Process Task, Send Mail Task, FTP task
• Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Involved in troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created automated reports using SSRS (SQL Server Reporting Services)
• Created Column Store indexes on dimension and fact tables in the OLTP database to enhance read operation
• Develop Database Queries required to accomplish the application development.

Environment: MS SQL Server 2012/2008R2, SSIS-2012, SSRS, T-SQL, OLTP, Visual Studio 2012,MS Office 2010/2013, VISIO 2010, SQL Query Analyzer.

Confidential, NE

SQL Developer

Responsibilities:

• Migrated data from SQL Server 2008 to SQL Server 2012 environment.
• Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data.
• Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Developed scripts to migrate data from multiple sources.
• Maintained the security, integrity and availability of SQL Server.
• Performed data extraction and migration activities for populating test (or non-production) and customer databases.
• Created Sequence in SQL Server 2012 to insert same identity value in multiple tables as per the business rules on OLTP database
• Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
• Tuned complex SQL Queries.
• Developed, implemented, and executed a quality assurance program and quality control standards for all ETL (SSIS) activities. Performed regular data consistency, quality and reliability checks.
• Designing data models, contributed to the overall design and implementation of the data warehouse. Participated in all data warehouse planning and execution.
• Responsible for implementing and maintaining commercial ETL application(s) and integrating them into the data warehouse environment (SSIS).

Environment: MS SQL Server 2012/2008R2, SSIS-2012, SSRS, Visual Studio 2012, Red Gate, Agent Ransack, VS 2008, PowerShell Scripting.

Confidential, St. Louis, MO

Data Analyst

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Designed new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development environment
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.
• Good understanding of source to target data mapping and Business rules associated with the ETL

Environment: Informatica 9.1, Oracle 11g, SQL server 2008 R2, SQL, T-SQL, PL/SQL, Toad 10.6, SQL Loader, OLTP, Tidal Enterprise Scheduler 5.3.1, Flat files.

Confidential, Detroit MI

Database Engineer

Responsibilities:

• Worked closely with development, QA and architecture teams
• Responsible for physical database design and implementing performance tuning
• Assist writing complex stored procedures
• Enhance database applications in an ever changing environment
• Perform code and design reviews
• Meet with management to ensure satisfaction with the data collection, presentation, and other efforts
• Developed and implemented ETL processes using SSIS for data conversion from multiple data sources of legacy system data to target database schema.
• Provided logging and data auditing for packages to show number of records process and data errors.
• Create SSIS packages to deploy packages between development, testing and production.
• Developed, implemented, and executed a quality assurance program and quality control standards for all ETL (SSIS) activities. Performed regular data consistency, quality and reliability checks.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operationalDrill-throughandDrill-downreports usingSSRS.
• Developed different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved withQuery Optimizationto increase the performance of the Report.
• Developed Reports for business end users usingReport Builderwith updating Statistics.

Environment: 80 SERVERS, 1000+ DATABASES, 2+ TB OF DATA, Server 2000/20 R2 Enterprise, BIDS, MSMS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS),Red Gate, Microsoft office share point portal server 2003 .NET, C#, ASP.NET.

Confidential, Bradenton FL

SQL Server Developer (SSIS)

Responsibilities:

• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
• Implemented incremental loading as per the daily changes in source database and applied event handlers and checkpoints.
• Interacted with analysts to review requirements and design specification documents.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Created different user level groups, and assigned appropriate permission level to the database. This made sure that only the right person with enough authority would be able to see the customer Information.
• Performed Data validations against data warehouse using Microsoft Excel.
• Extracted the data from MS Access database to SQL server database warehouse using SSIS.
• Worked on the script components in SSIS using VB script for getting latest files and ETL logging areas.

Environment: 260 SERVERS, 1000+ DATABASES, 2+ TB OF DATA, Oracle, Server 2000/2005/2008 Enterprise, BIDS, SSMS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS).

Confidential, Plano TX

SQL Server Developer

Responsibilities:

• Migrated data from the various databases and transformed it by creating SSIS Packages looking at slowly changing dimensions.
• Incorporating business logic to perform ETL operations using SSIS, SQL Loader while converting from web trends to SQL Server.
• Implemented incremental loading as per the daily changes in source database and applied event handlers, checkpoints and error logging on the failure of packages.
• Configured packages to operate them on testing and production environments and scheduled jobs to run the packages and created configuration files to execute package in multiple environments.
• Generated daily, weekly and monthly Ad-hoc reports in SQL Server Reporting Service (SSRS) on the products, cash inflow and the meetings held by the end users.
• Generated analytical reports of market research data and existing customer data using SSRS and reported to the Marketing Department.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reports to the end users.
• Making daily basis reports as per user requirement using MS Reporting Services.
• Created different user level groups, and assigned appropriate permission level to the database.
• This made sure that only the right person with enough authority would be able to see the customer Information.
• Involved in creating Cubes in SSAS (MDX) to generate reports to analyze the data.
• Working with database administrators to ensure available resources, both target and source systems.
• Communicated statuses with data warehouse and business intelligence teams and assisted in resolving data-related problems.
• Master working in OLTP & OLAP environments using SSIS, SSRS and SSAS cubes that include QA
• Production and development, implemented and maintained database schema and Entity relationship (ERD) diagrams (using ERWIN) from business requirements.
• Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using SQL Server Analysis Services (SSAS).
• Used SQL server Profiler to apply traces on the stored procedures and queries and rebuild them to improve the performance.
• Designing data models, contributed to the overall design and implementation of the data warehouse. Participated in all data warehouse planning and execution.
• Worked on Actuate Report Development which involves scripting and Actuate Report Server.

Environment: Oracle, Server 2000/2005/2008 Enterprise, BIDS, MSMS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS), SSAS, Enterprise Manager, Microsoft office share point portal server 2003 .NET, C#, ASP.NET, Red gate, Informatica, SharePoint, BizTalk, VB.Net, BO, AutoSys etc.

Confidential, San Antonio TX

SQL Server Developer

Responsibilities:

• Worked on iteration basis to make sure the deliverables are achieved on time.
• Involved in the meetings with business users to design the business required document for the enhancements proposed.
• Designed, altered the existing schemas to enhance the functionality of the portfolio tracking system.
• Generated Weekly, Monthly and Yearly reports for time reporting systems (TRS).
• Worked on various complex stored procedures on back end to calculate budget data and provide actual and forecast information for all global domains.
• Involved in developing SSIS configuration and developed the SSIS Framework.
• Enhancing the existing functionality to display more qualitative data to the business.
• Worked on enhancing DB scripts for the actuals and forecast budget data screens to determine the flow of money across various global projects.
• Performed the activities on production servers to deploy the changes made during the iteration.
• Coordinated with production support and DBA team in refreshing the existing Database instances from the production servers.
• Provided the data as required for the front end developers to restructure the existing presence of the UI Screen.
• Capture various metrics of SAS helpdesk tickets
• Conducted analysis and generated tables, listings and graphs using SAS
• Provide SAS the capability to connect with additional datasets.
• Involved on using MS Excel Formulas like Look Up, Conditional, Date and Time, Conversion, text to validate data.

Environment: Microsoft Windows 2003 Advanced Server, SAS, Microsoft SQL Server 2005 Management Studio, Microsoft SQL Server 2000 Enterprise Edition, Microsoft Visual Basic 6.0, Hardware: Compaq Proliant 8500 Server.