SUMMARY

• Over 8 years of strong experience in the IT industry as a MS SQL Server Developer include experience in design, development, implementation and administration of database systems using MS - SQL Server 2014/2012/2008 R2/2008 for both OLTP & Data Warehousing Systems applications with various business domains like Financial, pharmaceutical and manufacturing.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance
• Experience in Performance Tuning and Query Optimization.
• Expert in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installation
• Good knowledge of System Development Life Cycle (SDLC).
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Worked Extensively on ETL process using SSIS package.
• Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Developing reports on SSAS & SSRS on SQL Server 2014/2012/2008 R2/2008 Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014/2012/2008 R2/2008
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.

TECHNICAL SKILLS

Databases: SQL Server 2014/2 R2/2005, Oracle 8i/9i/10g/11g, MYSQL

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD.

Languages: T-SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA

OLAP: SQL Server Reporting Services (SSRS), SSAS, SSIS, Crystal Reports 9.0/8.5,OLAP, Erwin, Tableau

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003/2008/2012, MS DOS, Unix, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Greenville, SC

SQL BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Involved in gathering requirements from Business Users, Analysts by scheduling meeting Confidential regular basis.
• Created SQL Server Reports using SSRS 2012.Identified the data source and defined them to build the data source views.
• Involved in debugging Reports and deploying Reports.
• Scheduled the Reports to run automatically.
• Extract Transform Load (ETL) development using SQL Server 2008, SQL 2012 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Migrated DTS packages from SQL Server 2012 to SQL Server 2014 as SSIS Packages.
• Created/Updated Views, Stored Procedure, Triggers, User Defined Functions (UDF) and Scripts using T-SQL Code.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008R2.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2012.
• Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc. using SSIS.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Used Multi-dimensional expressions (MDX) to present the date asked by the user, to simultaneously query on different dimensions.
• Developed Analysis Services Project. Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created Informatica mappings with T-SQL procedures to build business rules to load data.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic
• Experience in Performance Point Server powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008R2.
• Involved in Data migration (Import & Export using BCP) from text to SQL Server2008.
• Involved in Creating Stored Procedures for Reports generation.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Designed and implemented stored procedures and triggers for automating tasks.
• Developed data interface layer using ASP.NET and C# for data access.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS and Crystal Reports with .NET applications.
• Involved in the design, development and implementation of web user interfaces using C#. NET, ASP.NET
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Tested applications for performance, data integrity and validation issues.

Environment: Environment: SQL Server 20142012/2008 R2, SSIS, SSAS, SSRS, MDX, OLAP, XML, MS PowerPoint, MS SharePoint, MS Project, MS Access 2007/2003 & UNIX, Informatica, .NET, C#, Agile Programming, ASP.NET, C#, Shell Scripting, Oracle, Crystal Reports.

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Involved in migration of SQL Server /2014.
• SQL Server 2008 Reports Writer and performed complex SQL report writing and design.
• UsedSQL Server 2012tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Visual Studio.
• Used T-SQL in constructing User Functions, 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
• Used Jasper Reports as a reporting tool.
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.
• Design the ETL for the data load.
• DesignedSSIS Packagesto transfer data from various sources of the Company into the database that was modeled and designed.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Designed and developed SSIS packages to load data from Flat files, Excel to Data warehouse using C#.NET.
• Created reports using crystal reports.
• Maintained and updated Jasper 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
• Created stored procedures using Common Table Expression (CTE) and various types of UDF functions
• Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and functions used for designing SSIS packages.
• Bug fixes in SSIS, SSRS and stored procedures as necessary.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Developed web based ASP.NET internet applications
• Worked in an agile scrum methodology.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Created script tasks and components with C# and VB.NET in SSIS as part of ETL load.
• Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
• Created Informatica mappings with T-SQL procedures to build business rules to load data.
• 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.
• Created numerous simple to complex queries involving self joins, correlated sub queries, CTE's for diverse business requirements.
• 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: SQL Server 2014/2012/2008 R2/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, ASP.NET, T-SQL, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, Informatica, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle.

Confidential, Long Beach, CA

SQL BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data.
• Interaction with a variety of internal and external users to develop technical designs and reviews with the rest of the project team as appropriate.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and technical specifications.
• Querying, creating stored procedures, triggers, views, functions and writing complex queries and T-SQL Joins to address various reporting operations and also random data requests.
• Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
• Implemented Complex Logging in SSIS Packages.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Used C# codes in Script task component in SSIS to accomplish various tasks as per requirement.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Converted DTS packages in SQL Server 2008 to SQL Server 2012 using Integration Services (SSIS).
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various business users.
• Generated Sub-Reports, Drill Down reports, Drill through reports and Parameterized reports using SSRS. Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 2012 as assigned.
• Created List reports, Cross-Tab reports and different types of charts like Column charts and Bar charts.
• Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Reports using Global Variables, Expressions and Functions for the reports. Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Having knowledge in Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS).
• Extensive hands on experience in working with SQL Server 2014.
• Well versed in MS-Visio, MS-Project, MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysis.

Environment: MS SQL Server 2012/2008 Visual Studio2012/2010, Windows 7, SSIS, SSRS, Report Builder 3.0, SQL Profiler, C#, SQL Server Agent, Google Analytics, MS Excel, Power Pivot

Confidential, Manhattan, NY

SQL BI Developer

Responsibilities:

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
• Created complex SSIS packages using proper control and data flow elements with error handling.
• Installation and configuration of SQL Server 2008.
• Involved in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed the chart type, Tablix, matrix reports in SSRS (SQL Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• Used performance Point Services, SSRS, excel as the reporting tools.
• Wrote the expressions in SSRS wherever necessary.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in modifying report content and exporting reports in multiple formats based on the business requirements.
• Designed and implemented Parameterized and cascading reports using SSRS 2008.
• Developed data model based on the BA's and the reporting Team using SSAS, SSRS.
• Created derived columns on the final fact and dimension tables as per the business requirements.
• Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Created Analytical reports by PROCLARITY tool.
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.

Environment: SQLServer 2008/2005 Enterprise Edition,SQLBISuite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle.

Confidential

SQL Server Developer

Responsibilities:

• Involved in various phases of Software Development Life Cycle (SDLC) and developed use Case diagrams, Object Diagrams, Class Diagrams, and Sequence diagrams to represent the detail design phase using Rational Rose
• Implement high availability through database mirroring and Merge Replication.
• Performed Import / Export using DTS
• Propping up the new schema changes and additional new features on Development, Staging/QA and Production servers.
• Configured Log Shipping between Primary and Secondary servers.
• Created database, tables, Indexes and views.
• Created linked server between SQL servers.
• Dropped and recreated the indexes on tables for performance improvements.
• Designed DTS packages to refresh data on Development and QA/Staging.
• Developed web based ASP.NET internet applications
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.
• Created Stored Procedures and triggers to perform automated rules, updating to related tables.
• Discussions with Product team for new features.

Environment: Microsoft SQL Server 2000, Windows XP, ASP.NET, Rational Rose.

Confidential

SQL BI Developer

Responsibilities:

• Actively participated in gathering business requirements and system specification from business users and business analyst.
• Used Microsoft SQL server 2005, SQL server management studio and BIDS and participated in designing a data warehouse to store all the information from OLTP to Staging and Staging to Enterprise data warehouse Confidential the center to do better analysis.
• Designed configurations, logging/auditing, package error handling, data error logging and checkpoint in SSIS Package model.
• Used SSIS Package Model to load master data from CSV, XLS/XLSX and pipe delimiter files.
• Parameterized Control flow and Data Flow using variables and expressions in SSIS Package to achieve business needs and business requirement.
• Used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Used For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, Package Events, Precedence Constraint to achieve business requirement.
• Used complex T-SQL queries for data extraction. Applied various business logic to scrub/clean/validate/ convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, user defined functions, stored procedures and ad-hoc queries.
• Design SSIS package to load data in to DW along with dimensions & facts with the use of slowly changing dimension and maintain the historical data too.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs using other tools such as event handler, Logging information etc.
• Use Analysis service processing task to process the analysis cube in SSAS after DW run.
• Designed the usage summary, performance, Audit/Log, Job Status and detailed reports for ETL users in SSRS.
• Created parameterized, drill-down and drill-through for sales module for business users in SSRS 2005.

Environment: MS SQL Server 2005, MS SQL Server reporting services (SSRS), Integration Services (SSIS), T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003/2008.