SUMMARY

• Over 7+ years of IT industry experience with Microsoft SQL Server 2000/ 2005/2008/2008 R2/2012, SSIS/SSRS/SSAS, and OLAP as SQL Developer.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Very Good Understanding and Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in Data Modeling, Normalization and building Referential Integrity Constraints, Database Design, Programming
• Development and Implementation of Client-Server Applications & Database systems using MSSQL 2005/2008/2008 R2/2012 for both OLTP & Business Intelligence applications.
• SQL Server RDBMS database development including T-SQL programming.
• SQL Server OLAP database development including KPIs, Data mining, working with changing dimensions.
• ETL implementation using SQL Server Integration Services (SSIS).
• Thorough understanding of Kimball’s’ theory, KPIs, SQL Architecture.
• Experience working on Data Aggregation and Storage design of cubes in SSAS.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes
• Good Knowledge and understanding on the SharePoint Server.
• Extensive experience of designing and developing software applications with the .NET Framework 1.0/1.1/2.0/3.0/3.5 using C#, ASP.NET and VB.NET
• Experience in using Performance Point Server.
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on
• OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF
• Architecture and design experience specific to EPM solution implementation.
• Experience in debug, maintenance of ETL packages and ETL optimization using SQL Server best practices.
• Expertise in using TFS to open bugs, create tasks and user stories, initiate change requests
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS

Languages: SQL, Transact SQL, PL/SQL, HTML, XML, C, C++,VB.Net, WCF

Databases: SQL Server 2012/2008R 2/2008/2005/2000/7.0 , MS Access, oracle

Reporting Tools: SQL Server Reporting Service (SSRS),crystal Reports

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Web technologies: .Net, ASP.Net, Ado.Net, Silver light

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2007/2003/2000 , Adobe Professional.

Operating Systems: Windows / 98/2000/2003/ XP/Vista, UNIX, Perl

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Writing advanced T-SQL queries, analyzing existing stored procedures and recommending modifications for efficiency gains
• Responsible for the design/redesign, development and implementation of technical solutions
• Analyze data elements and determine proper data element associations, aggregation points, and related data elements
• Writing complex SQL queries to populate data from different tables and which can be used for SSIS packages
• UsedSQL Server 2012tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Visual Studio.
• Used T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, Grids using Sql Server Reporting Services 2012.
• Testing Packages and fixing bugs using SQL 2012 Business Intelligence Development Studio.
• Scheduling and executing SSIS Packages, using SQL Server Agent.
• Creating SSIS package to import data from SQL tables to different sheets in Excel
• Optimizing the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, established joins and created indexes whenever necessary
• Creating SSIS Packages to extract data from CSV and TXT files into schema tables and sends Email attachment of the extracted data.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created reports using crystal reports.
• Create Master Package to run different other ETL in one Master package.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Trouble shoot any kind of data issues or validation issues
• Bug fixes in SSIS, SSRS and stored procedures as necessary.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Worked in an agile scrum methodology.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Worked on writing the T-sql code for the historical data to pull according to the specification requirement.
• Played roles like production support of SSIS and SSRS jobs.
• Perform T-SQL tuning and optimizing queries for and SSIS packages.
• Created SSIS process design architecting the flow of data from various sources to target.
• Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
• Scheduling SSRS jobs and production support.
• Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS.

Environment: MS SQL Server 2008R2/2008, MS SQL Server 2012, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2010 ( MS Visual Studio.NET# 2008, MS Visual Studio.NET# 2010, Team Foundation Server (TFS 2012), Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server.

Confidential, Schaumburg, IL

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in upgrading from SQL Server 2008 to SQL Server 2012.
• Responsible for creating internal reports based on the project requirements and deployed the generated reports directly on the client’s workstation.
• Scheduled reports and exported in PDF, Word and Excel format.
• Administration, Configuration and Management of Microsoft EPM .
• Created various database objects in C#, Visual Studio and ASP.net and deploying them to the SQL Server 2005/2008/2008 R2/2012.
• Worked on creating report subscriptions and modifying the previously created subscriptions and troubleshooted report subscription failures.
• Used TFS source control to deploy application.
• Developed Query for generatingDrill DownandDrill ThroughReports inSSRS 2008(R2)
• Created complex Stored Procedures for better performance to generate reports.
• Analyzing complex reports and to improve the performance of those reports by adding some new filters to filter the data.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Developed BI solutions using ASP.net, Performance Point and Dashboard concepts as required.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Proficient in creating queries in TFS to validate results of TFS reports.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.

Environment: SQL Server 2012, SQL Server Business Intelligence Development Studio, SSRS, SSAS, SSIS, T-SQL, EXCEL, TFS 2012, C#.

Confidential, Charlotte, NC

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into our database.
• Created the Stored Procedures, tables, Views depending upon the project requirement
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table.
• Generated ASP.net objects from tables and presented these DOM objects which are capable for easy communication, to the Business applications.
• Created the deployment scripts after the development is done for every project.
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Troubleshooted the SSIS/SQL job Agent whenever necessary.
• Constructed cubes based on data volumes mostly adhering to Star Schema.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Used custom .NET assemblies for Script Task in SSIS
• Hands on knowledge of TFS and Bug Tracking and Reporting through TFS bug tracking tool.
• Imported the various files provide by the clients into the relational database systems.
• Used the BCP to load the large volumes of data from files into tables.
• Worked with Business Analysts and Users to understand the requirement.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Documentation for all kinds of reports andSSISpackages.
• Used Visual Source Safe as Version Control Tool.

Environment: SQL Server 2012, SQL Server Business Intelligence Development Studio 2012, SSIS, SSAS, SSRS, T-SQL, EXCEL, Performance Point Server, T-SQL, C#, Visual Source Safe, SQL prompt.

Confidential, Dallas, TX

SQL Server BI Developer (SSIS, SSRS)

Responsibilities:

• Involved in Migration of SQL Server 2005 to SQL Server 2008.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Created new reports using SSRS for project which will be used by the Management to assess the availability of resources.
• Wrote several complex SQL queries and stored procedures that are used in the reports.
• Created some new views and modified the existing views so that the views contain accurate data.
• Work with the end users to ensure that the reports are working as per the Business requirements specified.
• Created and modified User Defined functions and implemented cursors, complex SQL queries in functions.
• Help the testers in testing the reports as per the specified requirements.
• Managed reports using Report Manager and deployed reports using SSRS.
• Training clients in generating ad-hoc reports using Report Builder.
• Monitor the performance of the reports and modify the SQL queries and functions used in the reports to improve the performance.
• Migrated DTS packages to SSIS and modified the packages accordingly to the new features of SSIS.
• Involved in creating report models and applying row level security filters for report model.
• Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Experience in building Reports on Analysis Services cubes.
• Responsible for extracting data using MS SQL Server Integration Services (SSIS) from OLTP to OLAP.

Environment: MS SQL Server 2008/2005 Enterprise Edition, SSIS, SSAS, MDX, OLAP, OLTP, SSRS and Windows Server 2003, EXCEL, MS Access, PPS 2007.

Confidential, Evansville, IL

SQL Server Developer/DBA

Responsibilities:

• Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
• Designed packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, Derived Columns with Multiple Data Flow tasks.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages.
• Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different sources into company's format.
• Created Packages using Complex Store Procedures and T-SQL queries.
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Developed Complex Packages to load data into Stage, ODS and Data Ware House systems.
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Configured, Installed, Administered Reporting Services 2005/2008.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports.
• Designed Large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Developed reports using complex T-SQL queries, User Defined Functions, stored procedures and Views.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions.
• Deployed reports across Test, Development and Production Environments. Involved in Trouble Shooting Complex Reports.
• Created Large Number of Report Models for users to create their own reports.
• Involved in code reviews, change control and auditing procedures.

Environment: T-SQL, SQL Server 2008/2005, Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.Net 2003, Erwin Data Modeler.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Involved in configuring and converting MS SQL Server 2000 database to MS SQL Server 2005.
• Partially involved in Database design and Database objects.
• Created backups for databases.
• Partly Involved in Performance tuning.
• Created ActiveX DLL COM Components using Visual Basic 6.0.
• Responsible for Developing GUI Screens
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Responsible for creating COM Components using ActiveX DLLs and for creating database and database objects like Tables, Stored Procedures, Views, Triggers, Rules and functions.
• Developed various management reports using Crystal reports 8.0.
• Maintain the application as per the user requirement.

Environment: SQL Server 2000/2005, ASP .Net, VB Script, Crystal Reports, Access, Excel