SUMMARY

• Over 8 years of SQL database experience in a high transaction and multi - server production environment, current experience with SQL 2012/2008.
• Expert Knowledge of Integration Services (SSIS), Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SSIS services
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
• Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio. Experience in developing UML diagrams including Use Case diagrams, Class diagrams, Interaction diagrams, State diagrams and Deployment diagrams
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
• Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
• Thorough knowledge and experience in Administrating PeopleSoft Server components like PeopleSoft Application Servers, Process Scheduler Servers, Tuxedo, Web logic Servers, PIA (PeopleSoft Internet Architecture), Application Messaging, Integration Broker, Sql server, Application Issues and technical issues, etc.
• Proficiency in migration activities in PeopleSoft.
• Extract queries from an oracle PeopleSoft database to be fed to an analytics module SQL Server Services (DTS, SSIS, SSRS, SSAS)
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• SQL Server 2012/2008/2005/2000 RDBMS database development including T-SQL programming.
• ETL implementation using SQL Server Integration Services (SSIS)
• Developing reports on SSAS & SSRS on SQL Server ( 2012/2008/2005/2000 ).
• Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Experience in creating Pipeline Custom Component such as Error handling to get error description of failure.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Worked on OLAP Data warehouse, Model, Design, Implementation
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Experience in scheduling SSIS packages using SQL Server Agent and BAT file through ESP Scheduling Tool.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in using T-SQL in SQL Server 2000/2005/2008/2012 platform
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in writing complex T-SQL queries using Inner, Outer, Merge and Cross Joins.
• Experience in using Try Catch block introduced in SQL Server 2012/2008/2005.
• Experience in using Transactions blocks in SQL Server 2012/2008/2005.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
• Good Knowledge in managing Data and Transaction log files, Files Groups.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server
• Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential
• Integrity by using Triggers and Primary and Foreign Keys.
• Good knowledge of System Development Life Cycle (SDLC).
• Good in implementing SQL Server Security and Process Control.
• Experience in Creating Roles and Assigning Permissions to the users.
• Good knowledge in SQL Server 2012/2008/2005/2000 Client Server Architecture

TECHNICAL SKILLS

RDBMS/ Database: SQL Server 2000/2005/2008 R2/2012, MS-Access XP/2007, Sybase. ORACLE 10g/9i, PL/SQL

Reporting tools: SQL Server (SSIS, SSAS, SSRS),Crystal Reporting 10.0.

Data Modeling: Microsoft Vision 2000, Erwin 4.0/3.5

Languages: T-SQL, PL/SQL, C#,.NET, ASP.NET, XML, VB.NET, Visual Basic 6.0

GUI: Visual Studio.Net, Visual Studio 6.0/2005

SQL Tools: IDERA Performance Monitor, SSMS, SQL Profiler, DTS, Database Tuning Advisor DTA, IDERA SQL Backup.

Web Design Tools: Dream Weaver CS3, FrontPage 2002, Outlook Express, Adobe Flash

Scripting Languages: Shell scripting, Perl Scripting

Operating Systems: MS-DOS, Windows 2000/XP/NT/Vista, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL/BI Developer

Responsibilities:

• Involved in designing and creating Tables, Views, complex Stored Procedures and Indexes using T-SQL.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Designed and implemented ETL processes with SSIS packages using Heterogeneous data sources and performed transformations using SSIS
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
• Worked on Huge Data Transfers from SQL Server Databases using utilities like DTS, SSIS, BCP, BULK INSERT etc. and used configuration files, Environment variables for production deployment.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Used Unblocking and row transformations for Performance Tuning of SSIS packages.
• Used VB.Net, VB Scripts for loading data using SSIS Packages.
• Worked on both Star and snow flake schemas to build cubes using the fact and dimension tables, perform processing and deployed the cubes to SQL server analysis services database.
• Involved in designing Aggregations and pre-calculations in SSAS 2005/2008/2012/2014.
• Created Measures, KPIs and defined Actions, Translations and Perspectives in Analysis Services.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Involved in writing MDX Queries for Analytical and Reporting purposes.
• Involved in developing and deploying OLAP cubes.
• Data modeling experience (hub and spoke, dimensional, data vault)
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2012/2014).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point Server 2007/SharePoint Server
• Evaluated database performance and performed tuning, backup, restoration and disaster recovery.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS
• Experience in writing DMX queries and statements.
• Experience in Creating Tabular models.

Environment: MS SQL Server 2012/2014, T-SQL, MDX, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS 2008), SQL Server Analysis Services (SSAS), ETL, Business Intelligence Development Studio (BIDS), MS Excel, Advanced Windows 2005 Server, VB Script, Oracle 10g/9i, XML, SharePoint Servers, Erwin.,DMX.

Confidential, Houston, TX

Data Migration Analyst

Responsibilities:

• Perform data migration processes-Complete data migration process to support GCRO activity,create SQL server stored procedures and ad hoc T-SQL scripts to support data migration activities
• Respond to customer inquiries regarding data analysis-Research, analyze, and provide responses to customer regarding data inquiries
• Liaise between 3rdparty data owners and GCRO IT&S teams-Work with stakeholders to understand what data is coming into Confidential and verify data follows GCRO IDMO protocols and governance processes
• Document data sets-Work with data owners to document the business context and associated metadata for incoming data sets
• Support SharePoint data migration- Collaborate with the GCRO SharePoint team to migrate data into Confidential systems
• Provide data migration subject matter expertise-Work closely with the DM team to find solutions for complex data migration activities
• Communication-Effectively communicates with a variety of technical and business stakeholders. Uses available communication channels to send, receive, and interpret complex messages
• Critical thinking-Evaluates multiple options to find the most effective solution for a given problem
• Data Analysis- Effectively queries, searches, and extracts content from relational and unstructured content repositories. Also troubleshoots data issues as they arise
• Data Migration- Able to use Robocopy and/or other standard data migration tools
• Microsoft Office Suite-Creates and updates documents using Microsoft Office applications (e.g. Word, PowerPoint, Excel, Access, Visio)
• Requirements Analysis-Reviews business and technical requirements to find the most appropriate solutions
• SharePoint-Understands how to use and manage SharePoint lists and document libraries
• SQL Server-Understands and uses T-SQL, relational databases, and reporting tools

Environment: Windows NT/2008, MS SQL Server Management Studio 2008 R2, T-SQL, DTS, SSIS, SSRS, Oracle 9i, Rational Rose, SQL*Plus,SQL*Loader, Shell scripts, .NET Framework 4.0, VB.NET, C#.net, Visual Basic 7.0, Visual Studio 2008, AIX 5.3

Confidential, Harrisburg, PA

SQL BI Developer

Responsibilities:

• Primarily responsibilities include Data extraction and Reports development for two applications.
• Dynamically supported business users for given requirements and developed the Packages and Reports accordingly.
• Involved in database design process and data modeling process for the application using Erwin.
• Involved in Data mapping, Column mapping and maintain data dictionaries and Data models.
• Involved in creating, maintaining different SQL Server Objects such as Tables, Procedures, Functions, Views, CTE’s, Triggers etc. according to the Requirements.
• Involved in writing complex SQL Scripts using the excel sheets for loading the data into the maintenance tables, using LinkedIn server.
• Queried against Heterogeneous Data Sources like SQL Server, Oracle, Excel and flat files to retrieve multi-million records for data loads using SSIS 2008.
• Extensively used Event Handlers and Error Handling in SSIS packages and notified process results to various users using send email Task.
• Built complex reports from tables and stored procedures in accordance with business requirements using SSRS 2008.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Created parameters (multivalve, hidden, default etc...) and cascading parameters for the required fields using the report designer in order to see the dropdowns in the end report.
• Involved in Knowledge Transfer to the peers, Documenting of all the Business logic insuring maintenance is easy for the Peers and Responsible for conducting code reviews in my team. Analysis of Business design document.
• Created SSIS packages to load data from excel text files to data warehouse.
• Extensively designed the packages using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Foreach loop Container, File System Task and Script Task in SSIS Designer.
• Used an Execute SQL Task to retrieve the rowset into SSIS Object variable.
• Used Select statement in the execute SQL Task with Full Result set and assign result to Object variable in Result set tab.
• Used a Foreach Loop Container with the Foreach ADO Recordset enumerator to loop over Object typed SSIS variable.
• Created string variables - one for the full source pathname, and one for the full destination pathname and set both to EvaluateAsExpression.
• Used variable properties to write an expression to the source path plus the filename variable into the source pathname variable and similar expression for the destination pathname variable.
• Used File System Task inside the Foreach Loop Container to copy or move files and set the source and destination to variables.
• Implemented various business logic classes in C# and ADO.NET.
• Experience in writing DMX queries and statements

Environment: Windows 7, MS SQL Server 2008/2012, PL-SQL/T-SQL, Business Intelligence Development Studio (BIDS), SSIS,SSRS, Erwin, Oracle 10g/9i, MYSQL, MS Excel, VB Script, XML, Net (Asp .Net,VB.net C# .NET), Erwin 7.3, Team Foundation Server (TFS), Visual SourceSafe (VSS),Visual Studio 2010,DMX.

Confidential, Morris plains, NJ

MSBI Developer

Responsibilities:

• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• 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 Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination system
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Constructed cubes based on data volumes mostly adhering to Star Schema
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Dealt with complex Procedures, Triggers, and Functions etc. Created and optimized Indexes, Views and other scripts for applications.
• Monitored and improved SQL server performance using SQL execution plan and tools such as SQL server Profiler, Database tuning engine.
• Designed and applied entity and attributes description and definition for the models.
• Monitored Scheduled jobs and alerts.
• Developed, monitored and deployed SSIS packages.
• Worked on both Star and snow flake schemas to build cubes using the fact and dimension tables, perform processing and deployed the cubes to SQL server analysis services database.
• Involved in developing and deploying OLAP cubes.
• Analyzed reports and fixed bugs in stored procedures
• Created SQL Server Reports using SSRS 2005.
• Developed Query for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts and used Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Responsible for generating daily reports on the client’s workstation
• Experience in writing DMX queries and statements

Environment: MS SQL Server 2005/2008, Windows XP, Enterprise Manager, T-SQL, ERWIN 4.0, XML, MS PowerPoint, MS Project & Windows 2003 server.SharePoint, Visual Basics, Visual Studio 2008, .Net Framework 3.5, snapshot, Replication, MS Office suite, Integration Services 2005,DMX.

Confidential

SQL Server Developer

Responsibilities:

• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes
• Involved in gathering and analysis of user requirements.
• Create functional and technical specifications for projects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Responsible and for logical and physical design of database.
• Use Crystal Reports to design and develop reports.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Bulk data migration using DTS from flat files.
• Create documentation as required.
• Performance tuning and testing on stored procedures, indexes, and triggers

Environment: MS SQL Server 2005, Windows 2000 server, Crystal Reports, VB.net, Query Analyzer, Enterprise Manager.