SUMMARY

• Over 8 years of IT experience in Data Design and Development on Microsoft SQL Server 2012/2008R2/2008, T - SQL, Performance Tuning, Troubleshooting, SSIS Package Configuration, SSRS,SSAS and Data-warehousing.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well versed in ERWIN.
• Excellent Knowledge in creating databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User Defined data types, Cursors, Triggers and Indexes using T-SQL.
• Experience in creating indexed views, complex stored procedures, TEMPeffective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Good understanding of (SDLC) software development life cycle process methodologies and principals.
• Good noledge of Scrum process methodologies and principals.
• Strong technical noledge in MS SQL Server development including Microsoft Integration Services Performance tuning, Reporting, Microsoft Analysis Services, Designing logical/physical databases and Troubleshooting.
• Good Knowledge about Extracting, Transforming and Loading (ETL) data using Import/Export Wizard and SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS/SSIS Packages and Backup/Restore of a database.
• Developing reports on SSRS on SQL Server (2000/2005/2008 ).
• Experience wif Adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill Through, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Involved in SQL Server 2008 OLAP database development including KPIs, Data mining, working wif changing dimensions.
• Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

PROFESSIONAL EXPERIENCE

Confidential, Carpentersville, IL

MS BI Developer

Responsibilities:

• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Developed highly optimized stored procedures, functions, and database views to implement the business logic and also created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created and maintained data flow diagrams for existing and future ETL processes.
• Designed, deployed, and maintained complex canned reports using SQL Server 2012 Reporting Services (SSRS).
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Created SSRS reports which contain Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.
• Developed various operational Drill-through, Drill-down and linked reports using SSRS 2008R2.
• Converted all the reports form SSRS 2008R2 to SSRS 2012 and maintained all the updated versions in TFS.

Environment: Windows server 2012, SharePoint, MS SQL Server-2012/2008R2, TFS, Oracle DB 10g, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Performance Point Sever.

Confidential, New York, NY

SQL Server Developer

Responsibilities:

• Formulate designs and/or design recommendations which meet various requirements; balancing the goals and constraints of existing solutions.
• Convert business requirements into actionable technical requirements for the project.
• Worked on 3 terabytes of data warehousing storage, wif multiple years of historical data.
• Provide technical solutions wifin BI team in the design process for the project.
• Designed and Built ETL packages to migrate data from different source systems using Data vault modeling concept.
• Design and build reporting and analysis tools that halp streamline the business and make reporting, analyzing, planning, and forecasting more efficient.
• Worked on ETL Load SSIS Packages, report / cube creation and data visualization including dashboards and reports leveraging charts (Pivot tables), gauges and drill-through.
• Created SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
• Support team projects wif technical expertise wif all aspects of the solution design and implementation, including requirements definition, data acquisition processes, data modeling, process automation, escalation procedures, construction, and deployment.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Present and propose solutions, and alternatives, to requirements wif an eye to scalability, flexibility, ease of maintenance and time to delivery, which often requires a phased approach and understanding of release schedules.
• Created SQL Server Traces in SQL Server Profiler, to collects a variety of information about SQL Server connections, stored procedures and Transact-SQL statements.
• Created complex stored procedures, triggers, cursors, views, user-defined functions, SQL Server Traces in SQL Server Profiler to collect a variety of information about SQL Server transactions, server performances and Transact-SQL (T-SQL) statements.

Environment: SQL Server 2012/2008R2, Oracle, SSIS, SSRS, SSAS, MDX, C#, Visual Studio 2010, Excel 2013/2010, Tableau 8.0

Confidential, Englewood, NJ

MS SQL Server Developer/ BI Developer

Responsibilities:

• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformations constraints.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Developed report specifications, created and modified reports using SSRS 2012.
• Created OLAP Cubes from the integrated data and generated reports on those cubes.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Worked on error handling a module consisting of data from bank, transactions, currencies, countries, master and static.
• Implemented multidimensional cubes wif MDX calculations to support analysis needs and fast data retrieval.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Used Microsoft SharePoint Server to provide a framework for web application development.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
• Demonstrated Strong experience using the Informatica Suite of Tools - Power Center version 9, Power Exchange version 9, B2B Data Transformation
• Strong experience in the design and development of mappings, transformations, sessions and workflows in Power Center.

Environment: MS SQL Server 2012, SQL Server Integration Services, SQL Server Report Services, SQL Server Analysis Services, Visual Studio 2011, VSS 2005, Erwin 9.0, Informatica 9.x, Windows 7, ASP.NET, MS Access.

Confidential, Philadelphia, PA

MS SQL Server/BI Developer

Responsibilities:

• Implemented complex conceptual database design and database architect into SQL Server 2005/2008R2 using various constraints and triggers.
• Thoroughly used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation for the investment data collected. Involved in Index planning and implementation.
• Performed database monitoring and tuning using SQL profiler and migrated data between SQL servers 2005 to SQL server 2008R2.
• Lead the development of automated SSIS packages to extract, transfer, load and convert data from existing data warehouse to reporting database server.
• Converted, loaded and integrated data from Access, Excel, text.csv files and internal database applications including the mainframe wif data captured for security applications.
• Developed and optimized SSIS Packages for “Lead Extraction Engine” which mainly involved high level business transformations on the data to produce the desired weekly and summary vendor extracts needed to monitor the overall TEMPeffectiveness and profitability of profit margin of investments.
• Created high quality reports, dashboards and analytics to meet the needs of various business clients such asOperations, Sales, Customer Service, Finance, and Executives.
• Designed and deployed reports in MS SQL Server environment using SSRS 2005/2008R2 and created Sub-Reports, Drilldown-Reports for the clients.
• Scheduled Summary Reports, Parameterized Reports and Ad Hoc reports for viewing purposes by the managers for the analysis purpose

Environment: MS SQL Server 2005/2008R2, SQL Server Integration Services, SQL Server reporting Services, SQL Server analysis Services, SQL Profiler, Microsoft Excel, ODBC, Microsoft Visio, and ERWIN

Confidential, Ada, Michigan

SQL Server/Report Developer

Responsibilities:

• Involved in dimensional modeling to design data warehouse.
• Worked in OLAP environment where star schema is implemented, creating and identifying fact and dimension tables and establishing proper relations between them.
• Created SSIS package to load data to SQL Server, from Flat files or excel spreadsheet.
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities bySSIS package.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Created Jobs for various packages that run at specific schedule every day based on some dependencies.
• Created reports and performed all Administrative activities. Also Installed and maintained SQL Server Reporting Services (SSRS) 2008.
• Extensively used SQL Server Reporting Services to generate various types of reports.
• Created multiple reportswif drop down menu option having complex groupings wifin the report.
• Scheduled the reports to run on daily and weekly basis in Report Manager.
• Developed Stepped and Block reports using SSRS.
• Formatted the reports using the Global variables and expressions.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Performed data analysis to generate various trend reports.
• Generated Ad-hoc, matrix, tabular, parameterized and cascading parameterized reports using SQL Server reporting services based on customer needs.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, T-SQL and Visual Studio (BI) Tool

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installed and Configure SQL Server 2012 in test and production environment,
• Migrated databases from SQL Server in test and production environment,
• Closely worked wif business analyst to collect requirements & make systems available ASAP,
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup Configured Log Shipping from Production to Standby Server (Running as Reporting Server),
• Configured and Maintained Replications (Transactional),
• Wrote T-SQL and Stored-Procedures,
• Performed performance and index tuning,
• Grant internal/external developers to development servers and shares,
• Created Backup strategy for production and development environment,
• Maintained Database Backup & Restore,
• Scheduled jobs, Setup and configured database mail for notification purposes,
• Developed Database Maintenance Plan,
• Monitored Servers activity, solving problem
• Checked SQL Server Error Log, space usage
• Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes
• Exported/Imported data from Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files into SQL Server databases,
• Involved in creating and modifying tables, Index, constraints, Views, Stored Procedures, Triggers,
• Used Clever Path Dashboard to monitor and diagnose different problems

Environment: MS SQL Server 2012, SQL Server Integration Services, SQL Server Report Services, SQL Server Analysis Services, Visual Studio 2011, VSS 2005, Erwin 9.0, Informatica 9.x, Windows 7, ASP.NET, MS Access.

Confidential 

SSIS/SSAS Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups.
• Backing up master & system databases and restoring them when necessary.
• Monitored and scheduled existing/new jobs on production environment.
• Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers.
• Worked to tune the SQL queries using SQL Profiler.
• Developed a multi-dimensional database and OLAP cube usingSSASthat stored and maintained the data.
• Dealt wif huge amount of data and used SSAS in order to retrieve the data.
• Created new stored procedures and modifying existing ones.
• Migrated data from SAS environment to SQL Server 2005 wif SQL Server Integrated Services (SSIS).
• Created ETL process usingSSISto transfer data from heterogeneous data sources.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and
• Maintaining SSIS packages..
• Designed and implemented stylish report layouts.

Environment: Windows Server 2003, SQL Server 2005, BI studio 2005, SSIS, SSAS, SSRS, Microsoft windows XP