SUMMARY

• Around 7 years of professional experience in SQL Server database development, extensively worked in Production, Test, Development and Replication &Cluster Server Environments & development databases as a Developer.
• Excellent experience in designing and developing Reporting System using Business Objects.
• Experience with Finance, Sales, Health Care Doman like Insurance, Claims, Enrollment, and Credit Card tracker.
• Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.
• Hands on experience in creating indexed Views, Complex Stored Procedures, Functions, Triggers, CTE’s to assist efficient data manipulation and data consistency and used DDL, DML commands for various business applications.
• Efficient in upgrades and migration from MS SQL Server 2000/2005 to MS SQL Server 2012/2008.
• Hands on experience working with SSIS, for ETL Process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• CreatedSSISpackages with complicated transformationslikeLookup, Derived Column, ConditionSplit, Multicast, Sort, Union All, Cache Transform, and ConditionalSplit, Fuzzy Look - ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
• Great Expertise in event handlers, Package Configurations, Logging, and Check points, Package Securities and User Defined Variables for SSIS Packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in Reporting Services, Power BI (Dash Board Reports), Crystal Reports, Tableau using MS SQL Server and in supporting services MDX technology of the analysis services.
• Expertise in designing, supporting complex reports like Drill-Down, Drill-Through, Parameterized, Matrix, and formatting Reports using SQL Server Reporting Services SSRS) based on client requirement.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service, and Reporting service.
• Excellent hands on experience in creating groups, hierarchies and measures, KPIs.
• Good knowledge on creating the MDX cubes and Designing and Building the Dimensions and cubes with star schema and pre-calculating the same in SSAS 2005/2008/2008 R2.
• Good knowledge in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Having good experienced on BI Share Point like SharePoint 2013, SharePoint 2010 and Good Exposure with Microsoft Office System like MS Word, MS EXCEL, MS PowerPoint, MS Access, MS office Tools
• Writes independent code in VB.NET, VBA MS Access, MySQL, SQL, store procedures, develops, tests, debugs, implements, and documents programs. Assists in the modification of existing code.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTPand dimension modeling forOLAP.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.
• Quick learner and proactive team member with good Communication skills and Leadership capabilities.

TECHNICAL SKILLS

BI Tools: SQL Server Business Intelligence Development - SSIS SSAS, SSRS, DTS, MS Visio, Erwin, Crystal Reports 9.0/XI, ProClarity, Performance Point Server, Informatica

RDBMS/DBMS: MS SQL SERVER 2000/05/08, MS Access 2010, Oracle 9i/10g

Operating Systems: Windows server 2003, Windows 2000 advanced server, Windows NT/95/XP/Vista/2003/7/8/10, LINUX, UNIX

Web Technologies: XML,XSL,JAVA SCRIPT,HTML,CSS

Version Control Tools: Visual Source Safe, SVN

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS)

PROFESSIONAL EXPERIENCE

Confidential, Jersey City

SQL Server BI Developer

Responsibilities:

• Developed and OptimizedStored Procedures, Views, and User-Defined Functions, custom scripts and stored proceduresfor data import and manipulation.
• Developed Physical data models and createdDMLscripts to create database schema and database objects.
• Well versed with database concepts as well database design, writing SQL queries and Unix shell script programs
• Proficiency in workflow process dev for managing load dependencies and automation- Identify opportunities to optimize the Unix shell script pgms, SQL and fixed length data input files (ETL) environment, quality and validation processes to ensure data accuracy an d integrity using Unix shell script and SQL
• EmployedServer Group Management, new to SQL Server 2008 which enables T-SQL queries to be issued against multiple servers from a single central management server.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects, and ImplementedIncremental load, usedEvent Handlersto clean the data from different data sources.
• Having Experience on Exception Handling, Configurations, Project Deployment.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).Involved in Analyzing, designing, building &, testing ofOLAP cubeswithSSAS2005.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation of queries withMDX, Data Mining Models, developing reports usingMDXand SQL.
• Developed different kind of reports such aDrill-throughandDrill-down, Sub Reports,Charts,Matrix reports,Linked reports.
• Developed BI Letters in Visual Studio 2010 and 2012.
• BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service and Reporting service.
• Worked on Excel Sheet Macros, gave connections for MDX to create Power Pivot Reports.
• Involved withQuery Optimizationto increase the performance of the Report.
• Involved in the Data modeling, Physical Design of Database using tools like Erwin.
• Configured replication servers and transactional replication between production & standby server for disaster recovery
• Good knowledge in calculating measures and dimension members using multi-dimensional expression (MDX).
• Worked on Team Foundation Server (TFS), BI Share Point.

Environment: MS SQL Server 2016, DTS, Windows Server 2008, SSMS, BIDS,SSRS, SSIS, SSAS, Report Builder 3.0,Report Model, Erwin, Team Foundation Server, Performance Point Server, ProClarity, SharePoint (MOSS), FTP, MS-Visual Studio, XML, ADO.Net.

Confidential, Ann Arbor, Michigan

SQL DEVELOPER (SSIS/SSRS/SSAS)

Responsibilities:

• Involve in complete Software Development Lifecycle (SDLC).
• Analyze user requirements, functional and technical specifications, preparing test plans and write test cases.
• Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2008 and 2012.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Creates appropriate documentation in work assignments such as program code, and technical documentation.
• Expertise in Data Warehouse applications, directly responsible for the Extraction, Transformation and Loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle,SQLServer,Sybaseand SAP BW.
• Proficiency in workflow process dev for managing load dependencies and automation - Identify opportunities to optimize the Unix shell script pgms, SQL and fixed length data input files (ETL) environment, quality and validation processes to ensure data accuracy an d integrity using Unix shell script and SQL
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, and process SSAS cubes to store data to OLAP databases.
• Created Matrix, Drill-down and Sub-Reports in SSRS using different types of properties like Chart controls, filters, Interactive Sorting, SQL parameters etc. Deployed RDLs to Report Server (Share Point).
• Installation/configuration ofSybaseServer on various Unix Env.
• Upgrading ofSybaseServers to ASE 15.5
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Interacted with business users in collecting the requirements, solving issues and making changes as required.
• Managed indexes and optimized queries using execution plan.
• Used temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement.
• Involved in performance tuning of queries and SSIS packages which increases the performance and runs faster.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created ETL packages to get the data from XML raw files and used XSD files to convert the raw file to desired format.
• Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.
• Used C#.Net and Vb.Net in Script tasks in order to validate the files and to get the latest files.
• Used Script component using C#.Net to perform row by row transformations in data flow tasks.
• Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Upgraded SSIS 2005 packages to 2008 packages.
• Involved in testing the performance of SSIS packages over different servers in collaboration with platform labs.
• Used Event Handlers to handle errors in the packages.
• Deployed the SSIS Packages from development server to production server.
• Used script task to produce HTML reports and mail using SSIS.
• Created SSRS reports by Report designer for the users and deployed onto the report server.
• Parameterized and cascaded reports are also used to make the reports interactive with the users.
• Supported multiple projects at a time.

Environment: Microsoft SQL Server- 2008/2010/2012 , Visual Studio-2008/2010, T-SQL, Team Foundation Server, SQL Server Analysis/Integration and Reporting Services, Share Point 2010/2013.

Confidential, San Ramon, California

SQL Server BI Developer

Responsibilities:

• Developed and OptimizedStored Procedures, Views, and User-Defined Functions, custom scripts and stored proceduresfor data import and manipulation.
• Developed Physical data models and createdDMLscripts to create database schema and database objects.
• Well versed with database concepts as well database design, writing SQL queries and Unix shell script programs
• Proficiency in workflow process dev for managing load dependencies and automation - Identify opportunities to optimize the Unix shell script pgms, SQL and fixed length data input files (ETL) environment, quality and validation processes to ensure data accuracy an d integrity using Unix shell script and SQL
• EmployedServer Group Management, new to SQL Server 2008 which enables T-SQL queries to be issued against multiple servers from a single central management server.
• Ability to understand Unix scripting and mapping with database(involving Unix shell script pgms, SQL, syncsort/DMExpress, fixed length data input files and complex/critical tables/joins and Data validations)- Strong knowledge on ETL loading concept using (Unix shell script programs, SQL, syncsort/DMExpress, fixed length data input files and complex/critical tables/joins and Data validations
• Managed the migration of SQL Server 2000 databases to SQL Server 2005 and latest 2012.
• Experience using REDGATE to compare and synchronize all database objects.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects, and ImplementedIncremental load, usedEvent Handlersto clean the data from different data sources.
• Having Experience on Exception Handling, Configurations, Project Deployment.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).Involved in Analyzing, designing, building &, testing ofOLAP cubeswithSSAS2005.
• Expert in creating Star schema cubes usingSSAS.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation of queries withMDX, Data Mining Models, developing reports usingMDXand SQL.
• Developed different kind of reports such aDrill-throughandDrill-down, Sub Reports,Charts,Matrix reports,Linked reports.
• Migrated all SSRS Reports from Visual Studio /2010/2012 .
• Developed BI Letters in Visual Studio 2010 and 2012.
• BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service and Reporting service.
• Worked on Excel Sheet Macros, gave connections for MDX to create Power Pivot Reports.
• Cracked SAP code to SQL Code to Develop SSRS Reports
• Involved withQuery Optimizationto increase the performance of the Report.
• Involved in the Data modeling, Physical Design of Database using tools like Erwin.
• Good knowledge in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Good Knowledge on SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Configured replication servers and transactional replication between production & standby server for disaster recovery
• Good knowledge in calculating measures and dimension members using multi-dimensional expression (MDX).
• Worked on Team Foundation Server (TFS), BI Share Point.

Environment: MS SQL Server 2012/2008/2005/2000/7.0 , DTS, Windows Server 2008, SSMS, BIDS,SSRS, SSIS, SSAS, Report Builder 3.0,Report Model, Erwin, Team Foundation Server, Performance Point Server, ProClarity, SharePoint (MOSS), FTP, MS-Visual Studio, XML, ADO.Net.

Confidential, Chantilly, VA

SQL Server BI Developer

Responsibilities:

• Understanding the report design Requirements and Constraints.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Deployed the created SSIS packages using different transformations in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe

Confidential

SQL Developer/ DBA

Responsibilities:

• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation
• Responsible for MS SQL Server Installation and configuration, applied service packs and hot fix.
• Used SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Wrote User Defined Functions and Stored Procedures, and also defined Roles and Privileges to control access to database.
• Created Triggers to enforce data and referential integrity.
• Created Constraints, Defaults, Views and Indexes.
• Created Triggers to enforce data and referential integrity.
• Developed Master/Detail Reports and Tabular reports using Crystal Reports

Environment: SQL Server 2000, Windows NT 4.0, Crystal Reports 9.0.

Confidential

SQL Developer/ DBA

Responsibilities:

• Preparation of Functional and Technical Specification documents as deliverables to the client
• Designed, Developed and Deployed reports in MS SQL Server environment.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.
• The task involved writing a lot of SQL Code and distributing adhoc reports out of database.
• Tested for different test cases based on the requirements. Developed Test Cases and Test Scripts.

Environment: SQL server 2000, Windows XP, T-SQL