PROFESSIONAL SUMMARY:

• 8+ years of IT experience as MS - SQL Server Developer, involved in Design, Development and Support of MS SQL Server 2000/ 2005/2008/2012/2014 .
• Extensive experience in Data Modeling, Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012/2014 forboth OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS,SSIS, SSAS)
• Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing andImplementation of client-server based applications.
• Experience in database programming in writing Stored procedures, User Defined DataTypes, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL/PL-SQL
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
• Excellent knowledge of performance tuning in tuning stored procedures, Queries using tools like SQL Profiler, Database Tuning Advisor, Execution Plans, DMV’s and Efficient coding standards.
• Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, ConditionalSplit, Bulk Insert, merge and union all etc.
• Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
• Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.
• Highly experienced in full cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Developing, Scheduling, Configuring, Troubleshooting and monitoring) for performing data transfers and ETL Purposes across different servers.
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, NormalizationandDe-Normalization techniques for both OLTP and OLAP systems.
• Experienced in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2005/2008/2012/2014 across various environments.
• Expert in designing Crystal reports, Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 ) and Excel Pivot
• Created SSRS projects and reports in BIDS, sortand toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.
• Expert and proficient in highly analytical & detailed reports that include drilldown, drill through, parameterized(Cascading parameters), TopN, Summary, OLAP, cross tab, linked and sub reports and filters, charts in SSRS 2005/2008/2012/2014 .
• Extensive experience in SQLServer Analysis Services OLAP Cubes, and Data Mining.
• Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014, calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling DSV diagrams, Fact and Dimensions Tables using Analysis Services.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• Developed cubes using Partitions added the Key Performance Indicators (KPI), partition aggregations, Perspectives, slow changing dimensions etc. and created various user roles.

TECHNICAL SKILLS:

BI Tools: SSIS, SSAS, SSRS, Power BI, Business Intelligence Development studio (BIDS), Visual Studio

Languages: T-SQL, PL/SQL, C/C++, HTML, XML, VBScript, C#.Net, VB.Net, ASP.Net, ADO.Net, ActiveX, XML, MS Access, HTML, DHTML, Shell Scripting

Application package: MS Office Suite, Visio

Tools: SQL Server Enterprise Manager, Management Studio

Protocol: FTP, TCP/IP, Named Pipes

Databases: SQL Server 2005/2008/2012/2014, Access, MySQL, Oracle 10g, 11g.

Operating Systems: Windows Server 2003, 2007, 2010, 2013, Windows 8/NT/XP/Professional, MS-DOS, Red Hat Linux

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SQL Developer (SSIS developer)

Responsibilities:

• Created jobs Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Gave Server Access,helped in setting up a new Testing Enviroment.
• Created SQL Server Reports based on the requirements using SSRS
• Involved in analysis of Report design requirements and actively participated and interacted with Team. Lead Technical Manager and Lead Business Analyst to understand the Business requirements.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Created multiple reports with drop down menu option having complex groupings within the report.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Confidential

SSIS, SSAS, SSRS developer

Responsibilities:

• Involved in taking the requirement.Created jobs Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Created Partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning.
• Created SQL Server Objects, Schemas, Tables, Stored Procedures and Functions as per the given requirements.
• Created SSIS Packages for import and export data from various sources to destinations.(CSV,OLEDB,EXCEL)
• Worked on SSRS, created reports with Drill Down and Drill through.
• Created datasets and data sources for the SSRS reports.
• Validated the data from sources, reports and output files.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Worked on performing different transformations normalization and de normalizations.
• Involved in end to end to phase of the requirement gathering.
• Involved in testing the data.
• Involved in Deploying Packages and Scheduling the Jobs.

Confidential, St. Louis, MO

MSBI Sr. Consultant

Responsibilities:

• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data-load and transformations.
• Created various database objects such as tables, indexes and views based on the requirement.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Created data sources, connection strings and defined the datasets for generating the report.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• MigratedCrystal reports to SSRS reports.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports.

Confidential, Eden Prairie, MN

SQL SERVER SSIS/SSAS/SSRS Developer

Responsibilities:

• Wrote complex Stored Procedures, Views and indexes to cleanse data in the ADB database before letting the data flow downstream.
• Involved in Database design using Normalization and De-Normalization rules.
• Extensively worked on Tuning and performance issues on stored procedures created.
• Created a Parent Package using SSIS which takes care of all the child packages setting configurations to help the data flow from Sales force to Staging.
• Worked with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
• Knowledge of automation frameworks.
• Experience in writing and developing automation and manual Test strategies and Test plans with Scenarios.
• Developed automation test plans,high level test cases based on business requirements specifications.
• Used For-Loop Container, for-each Loop Container frequently in the packages to keep track of both the History and current data flow in the objects.
• Broke down complex VBA code to better understand the Excel reports and create SSRS reports out of it.
• Created many User Defined Functions (UDF’s) to meet the business logics.

Environment: s: SQL Server 2008/2012, T-SQL, SSIS, SSRS, Salesforce, Excel VBA(Visual Basic for Applications), SAS.

Confidential, Stamford, CT

SSRS SSIS SSAS BI Consultant

Responsibilities:

• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data-load and transformations.
• Created various database objects such as tables, indexes and views based on the requirement.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Developed Cubes using SQL Analysis Services (SSAS) and Dimensions using cube wizard and also individually and Generated Named calculations and named queries.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to analysis server from SSRS (2005/2008).
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• MigratedCrystal reports to SSRS reports.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports, VBScript.

Confidential

BI/ SQL Developer

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Creating dashboards for different departments.
• Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) 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 etc.
• Created different Parameterized Reports (SSRS 2005/2008) 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).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.

Environment: MS SQL Server 2005/2008/2008 R2, Sybase, Excel, TSQL, Microsoft Visual Studio 2008,SQL Reporting Services, SQL integration services.

Confidential

SQL Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
• Actively participated in gathering of Requirement and System Specification.
• 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
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Wrote Transact SQL utilities to generate table insert and update statements.
• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression (CTE)
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2008/2005, T-SQL, .Net, Microsoft Framework 2.0, Erwin, MS Visio.