SUMMARY

• Extensive 8 years of experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2005/2008/R2/2012.
• Involved in hard coding of Complex Queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T - SQL.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard and SSIS,.
• Experience in providing Confidential, Error handling by using Event Handler, and Custom Confidential for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services).and calculate the metrics that were revealed in the functional analysis.
• Experience in creating datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Expertise in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Excellent communication and interpersonal skills and has ability to handle multiple tasks; can take initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS

Technical Skills: MS SQL Server Integration Services 2012/R2/2008/2005, SQL, T-SQL, Visual Basic, ASP.Net, Microsoft Visio, HTML, XHTML, XML, CSS, JavaScript, AJAX, MS SQL Server 2005/2008/2008R2/2012, Oracle 10g, MS Access, MS DOS, WinNT/2000/2003/XP, PowerShell, Arc-GIS, MapPoint 2010.

PROJECTS SUMMARY

Confidential, NYC, NY

MS SQL Server Developer/ SSRS/SSIS Developer

Responsibilities:

• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Used different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Control Flows, which include tasks and containers that execute when the package runs. Organized tasks in sequences and in loops during creation of package in SSIS.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables. .
• Used Event Handlers for Custom Confidential using Complex Store Procedures for various events (On warning, On Pre and Post Execution, On Task Failed etc.)
• Developed SSAS Cubes and export them out as pivot tables in Excel for data analysis
• Developed the packages with monitoring features and Confidential so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Configuration files for changing variables and setting the priority levels for those transcripts based on the level of urgency / requirement.
• Created OLAP models based on Dimensions and Facts for efficient loads of data.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Developed MDX Queries in order to perform drilldown reports and for calculating measures and dimensions.
• Used PowerShell to monitor database information and made modifications.
• Used SharePoint-PerformancePoint Services to create rich dashboards, aggregating content from multiple sources and displaying it in a web browser.
• Implemented perspectives and KPI using calculated measures based on requirements.
• Identified and defined the datasets for Report generation.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using Reporting Services.
• Supported ASP.NET team to build a credit card payment system prototype for a private bank.

Environment: MS SQL Server 2008R2/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Reporting Services (SSRS 2008), SQL Server Analysis Services (SSAS), SharePoint 2013, Business Intelligence Development Studio (BIDS), MS Excel.

Confidential, Winston Salem, NC

SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Responsible for creating reports based on the requirements using SSRS 2008 R2/2012. Worked on generating reports using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet. Created complicated reports like parameter based reports, graphical reports, excel reports, drill-down chart and tabular report using SSRS2008 R2/2012.
• Continuously interacted with users to gather the business requirements.
• Created design specification documents for the new reports developed through SSRS.
• Published ad-hoc reports through Report Manager.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
• Data Driven Subscription both Email And Windows File Sharing.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.
• Fine-tuned existing reports by running execution plan on queries and identifying tables that need indexes
• Provided database technical support to ASP.NET application developing team to optimize existing Auto Insurance Query System. Troubleshot slow issues and optimized data access in SQL server.
• Involved to build Customer Information Management System with application developing team, provided supports on connection between front end and database (data access).
• Designed and Created databases, tables, views, stored procedures and triggers.
• Modified existing database by adding tables and relationships.
• Creating Star and Snow Flake Schema design using Visio, defining relations between tables
• (Primary keys, foreign keys).
• Designed, modified and troubleshoot SSIS packages.
• Utilized SSIS Checkpoint, Loading Dimension with the SSIS slowly changing Dimension Wizard and used different SSIS Control Flows.
• Created ETL in DTS packages by using Data Transform Task, VBScript task, SQL task and send Email task to migrate data from different functional databases into SQL Server 2008R2/2012.
• Created notifications, alerts to let support team know in case there are any failures.
• Migrated database from SQL server 2008 R2 to SQL Server 2012 using both Copy Database Wizard and Detach&Attach method.
• Configured Error and Event Handling: Precedence Constraints, Break Points, Check Points,

Environment: MS SQL Server 2008R2/2012, Management Studio(SSMS), ETL, ASP.NET, Crystal Reports9.0, Data Modeling, OLAP, Data warehousing, T-SQL, DB2, SSAS, SSIS, SSRS 2008 R2/2012, ASP.NET.

Confidential, Columbus, OH

MS SQL Developer/ETL Developer

Responsibilities:

• Involved in designing, reviewing, and creating Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Optimized Query Performance, Session Performance and Reliability.
• Designed Extract Transform Load (ETL) process to populate the data warehouse using SSIS
• Loaded Data to the Interface tables from multiple data sources such as MS Access, Oracle, Text files and Excel Spreadsheets using SSIS.
• Applied various data transformations such as SCD (Slowly Changing Dimension) to maintain the history of the data, Aggregate, Sort, Multicasting, Conditional Split and Derived column.
• Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.
• Generated Reports using Expressions and Functions for the reports using SSRS 2008.
• Generated Snapshot, Drill Down, and parameterized reports using SSRS
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler/Analyzer, Management Studio, Import/Export Wizard, Excel,Arc-GIS 10.0, Map Point 2010 .

SQL Server/BI Developer

Responsibilities:

• Involved in installation and configuration of SQL Server 2005/2008 with latest Service Packs.
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.
• Developed ETL's using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Script Task, Flat file Source, Flat file Destination, Conditional Split.
• Designed, administrated and developed Star Schema Data marts
• Experience in creating multiple reports (SSRS) in Drill mode using tables, crosses tabs and charts.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.

Environment: SQL Server 2005/08, SSRS, SSAS, Oracle 10g, Visual Studio, MsVisio2003/2007, MS Project.

Confidential, AR

SQL Server Developer

Responsibilities:

• Involved in ER diagrams and mapping the data into database objects.
• Design of the Database and the Tables.
• Build table relationships and wrote Stored Procedure's to clean the existing data.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery,
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Involved in Job scheduling and alerts.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Designed and implemented user log in and security.
• Involved in requirement gathering, analysis, design, development, change management, deployment and User Training.

Environment: SQL Server 2005 Enterprise Edition, .NET Framework-SQL, SQL Server 2005, SSIS 2005, SSRS, SSAS, Windows 2003 Advance Server, MS Excel, MS Access, Visual Studio 2005