SUMMARY

• Around 6+ years of experience as SQL Server Developer/Admin/Business Intelligence Developer.
• Experience includes requirements gathering, development, design, testing, deployment and maintenance of SQL Server technologies.
• Experience in installing, upgrading, configuring, managing, monitoring and troubleshooting of Microsoft SQL Server and Databases.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc.using SSIS/DTS utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in OLTP, OLAP/Data Warehouse, and Data Mart and ODS Data Bases.
• Experience with SQL Server 2000, 2005, 2008 and Denali 2012.
• SQL Server R RDBMS database development including T - SQL programming.
• Proficient in T-SQL queries using Stored Procedures, Dynamic SQL, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, and DDL etc and Proficient in Performance Tuning of SQL query.
• Good Understanding of Isolation Level, MOLAP, ROLAP, HOLAP, Normalization, De Normalization,
• Partitioning, ACID Property, Data Warehouse, Bill Inmon methodology, Ralph Kimball methodology, Star flake schema, Snowflake Schema, SSAS Dimension Attribute Properties and etc.
• Good experience in developing reports using SQL Server (SSRS)
• Experience in Visual Studio Team Foundation Server, Visio.
• Proficient in writing MDX query and good knowledge of all MDX Functions.
• Expert in Creating and managing roles for security in SSRS reports.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Excellent experience in Crystal report. Use tables, view, Store Procedures as data Source.
• Active Directory Basic operation and integration with related application for directory entity.
• Familiar with Agile methodology in software development.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2014/2012/2010 , 2008R 2/2008/2005/2000 , Oracle 11g/10g/9i/8i, Teradata V2R5, MySQL and MS Access 2003/2000/97

Database Technologies/Tools: SQL Server Enterprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal Reports.

Operating Systems: UNIX, Windows NT/XP/Vista/7/2008, Mac

Programming Languages: T-SQL, C, Java, C#, T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++

Internet Technologies /Tools: ASP.NET, JavaScript, VBScript, XML, CSS, HTML, Rational Rose, MS Office, VisualStudio2008/2005, DTS, SSAS, SSIS, SSRS, VSTF.

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, SSAS, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE

Confidential, Charlotte,NC

SQL Developer & ETL Specialist

Responsibilities:

• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions using SSIS.
• Used C# scripts in SSIS script task to run custom scripts in package flow.
• Involved in implementing package configuration in SSIS packages that allowed transferring packages from one environment to other
• Worked with Business Analysts for gathering the requirements & implementing the tasks.
• Conducted code walkthroughs and review peer code and documentation.
• Configure TFS environment such that SQL Reporting and SharePoint interact with each other.
• Knowledge on maintaining Production Servers which are in remote location.
• Performed Unit Testing of ETL Programs to support QA on End-to-End testing.
• Collaborated with development team during all phases of the project to promote successful delivery of quality products to our customers.
• Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and communication skills.
• Analyzing the requirements and discussed with managers and leads on the functionality.
• Involved in SDLC followed by Agile methodologies to produce high quality software model using N-Tier Architecture
• Designed and Implemented Tables, Functions, Stored Procedures and Triggers in SQL Server 2016
• Wrote complex SQL queries, Stored Procedures,CTE’s and Views
• Involved in creating multiple parameterized Stored Procedures, which were used by the reports to get the data.
• Regression testing was performed after each new build of the application.
• Involved in the process of Defect logging and Defect follow up in Team Track

Environment: SQL Server 2016,Autosys,TFS tracker &, Sharepoint,SSIS 2016 Visual Studio 2008,SSRS 2016, T-SQL, Visio 2015,.Net,Enterprise Manager, Windows Server.

Confidential, Charlotte,NC

SQL Developer & ETL Specialist

Responsibilities:

• Installed, configured, maintained and supported SQL server 2010 and 2012 in different environments.
• Worked with Business Analysts for gathering the requirements & implementing the tasks.
• Conducted code walkthroughs and review peer code and documentation.
• Uploaded the source code to version control tool (SVN).
• Developed various SSIS packages for the ETL process involved in CCAR application.
• Designed & implemented generic packages for all CCAR templates in SSIS.
• Performed Unit Testing of ETL Programs to support QA on End-to-End testing.
• Collaborated with development team during all phases of the project to promote successful delivery of quality products to our customers.
• Expertise in Autosys Job Scheduling through JIL file and extensively worked on production support.
• Created JIRAs to track efforts,assign work and generate reports for the team capacity .
• Created SSIS Packages to export heterogeneous data from OLE DB Source (SQL), Excel Spreadsheet and flat files.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Documentation of all the processes involved in maintaining the database for future reference.
• Worked with DBAs in order to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
• Created Email Alerts for successful or unsuccessful completion of scheduled Jobs.
• Written and executed complex T-SQL queries using SSMS for back end data validation testing.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Multicast,Data Conversion and Derived Column.
• Implemented Metrics Checks for data loads in SQL to compare row counts & send Email notifications using SSIS Packages.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Rendered reports in different formats like pdf, excel etc tobe executed automatically on weekly or monthly basis and managed subscriptions.
• Used Lookups Transformation to get the data from reference data sets.
• Development of mappings according to the ETL specifications for the staging area data load using SQL Server Integration Service & SQL Server 2008 R2.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Implemented Slowly Changing Dimension (SCD) in T-SQL using MERGE.
• Developed a package to copy tables data from one environment to another(UAT to Prod) dynamically using SqlBulkCopy in script task.

Environment: SQL Server 2012,2010,2008 Autosys, JIRA tracker & Tortoise SVN for source control, Sharepoint, Visual Studio 2008,SSRS2008, T-SQL, Visio 2010, Crystal Report2011,.Net,Enterprise Manager, Windows Server.

Confidential, New Berlin, Wisconsin

SQL Server BI Developer (SSRS/SSIS)

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes,Constraints, Tables, Views and other T-SQL code and SQL joins for applications.
• Create SSIS and DTS packages to process the data. Make use of various Control Flow and Data Flow items from Toolbox. Perform Error handing and version log using Event Handler.
• Work in Stored Procedures to prevent SQL Injection
• Manage Large Scale Stored Procedures and tuning to reduce execution time
• Developed and maintained a backup and recovery strategy for all databases.
• Work with EVENT MANAGER to manage the whole scheduling reports and manage recipient scheduling.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Used Lookups Transformation to get the data from reference data sets .
• Created permanent tables, temporary tables and table variables.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Developed T-SQL queries and Stored Procedures with multiple parameters to created data sets for reports.
• Created report snapshots to improve the performance of SSRS.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, to SQL Server and created complex SSIS packages using various transformations.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created Stored Procedures to retrieve data from CDC enabled tables to load all deltas into destinations.
• Created SSIS package to loop through multiple shared folders for multiple file servers to get all the files along with file path and folder names.
• Created Event Handlers for the SSIS package on Error, on Post execute.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Created Stored Procedures to load data into fact tables and dimensions tables for spot fire reporting dashboard.
• Write Complex Crystal Formula to format report as business logic .
• Crosstab Report with Crystal Report to provide unlimited dynamic column in report.
• Export and mail Crystal report data with different type and format.
• Active Directory Basic operation and integration with related application for directory entity.
• Manage Group, Role, Organizational Unit for users in Active directory.

Environment: SQL Server 2012,2010,2008 Control-M Manager, DTS, Sharepoint, Visual Studio 2008,SSRS2008, T-SQL, Visio 2010, Crystal Report2011,Enterprise Manager, Windows Server.

Confidential, Research Triangle Park, NC

MS SQL Server Developer/SSAS

Responsibilities:

• Designing and Developed queries using Microsoft visual studio 2008 R2.
• Created Database Diagram using third party tool Erwin in beginning of the project, identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
• Created database and database objects like tables, stored procedures, views, triggers, rules, defaults user defined data types and functions with T-SQL to facilitate data consistency.
• Created multiple hierarchical aggregates for faster performance.
• Created perspective of the cube to simplify the process of browsing for the end users.
• Supported all production operation activities with focus on integration and development of new and existing products and services., control, and automation opportunity to improve overall access to information.
• Created report snapshots to improve the performance of SSRS.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, failure reports with error description.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.
• Administrated the created reports by assigning permission to the valid user for executing the reports.
• Designing and developing the web forms using ASP.Net 2.0.
• Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
• Created different business classes and interfaces using .Net Framework 4.0 with Object Oriented Programming Methodology.
• Provide Support to other teams to fetch the data from the centralized database using ASP.net XML Web Services.

Environment: SQL Server 2005, T¬SQL, Window 200 Advanced Server,.NET, ETL, SQL Server Integration Services, SQL Server Reporting Services, Oracle 9i/11g SQL Server Analysis Services

Confidential, Menlo Park, CA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Designed and implemented stored procedures and triggers for automating tasks.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs.
• Involved in writing MDX Scripts for the OLAP CUBES and Developed multidimensional Objects using MS Analysis.
• Involved in Creation of Dimensions using STAR and SNOWFLAKE Schema.
• Created Logical & Physical Data Modes using Entity Relationship Diagrams.
• Reviewed the Conceptual EDW (Enterprise Data Warehouse) Data Model with Business Users, App Dev. and Information Architects to make sure all the requirements are fully covered.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Created classes and dimension and measure objects according to business requirements.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting, so create reports that draw content from a variety of data sources.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Deployed SSRS Reports in SharePoint for web based access for multiple end users.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Created reports using stored procedures and also involved in scheduling, creating snapshots and subscriptions for the reports SSRS.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

Environment: Windows XP, MS SQL Server 2008R2, SQL Server Management Studio (SSMS), Query Analyzer, Enterprise Manager, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.