SUMMARY

• Over 8 years of IT experience as MS SQL Server Developer 2012/2008 R 2/2008/2005/2000 in various Industry verticals like Insurance, Airlines, Telecommunication, Pharmaceutical, Retail and Bank.
• Extensive experience with different phases of Software Development Life Cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Extensiveexperiencein writing functional specifications, translating business requirements to technical specifications, created/maintained/modifieddatabase design document with detailed description of logical entities and physical tables.
• Experience in developing and monitoring SQL Server Integration Services (SSIS) Packages and Data Transformation Services (DTS).
• Excellent knowledge in Creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, SQL Joins, Query Writing, Data Dictionaries, Data Integrity, Cursors and Indexes using T-SQL.
• Major experience in Data Warehousing and SSIS Packages along with SQL Programming.
• Highly experienced in complete cycle of SQL Server Integration Services (2005/2008), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Transformed data from one server to other servers using tools like SQL Server Integration Services (SSIS) (2005/2008).
• Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access and designed data conversions from wide variety of source system.
• Established and maintaining theSharePoint 2013presence.
• Experience in Migrating from SharePoint 2010 toSharePoint 2013 and fromSharePoint2007 to SharePoint2010.
• Good Experience in working on Tableaudata analysis as Tableau Analyst and building, developing theTableaudevelopment dashboards as aTableauDeveloper and Publishing the developedTableau dashboards toTableauserver with security and authentication as aTableauAdministrator.
• Generated multiple Enterprise reports using SSRS from SQL Server OLTP Database and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Wrote complex Stored Procedures and triggers to capture updated and deleted data from OLTP systems.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2005 .Experienced with converting Crystal reports to SSRS reports and migrate crystal reports to higher versions.
• Designed 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.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL. C, C++, VB 6.0, Hadoop, Java, HTML, XML.

Databases: SQL Server 2012/2008 R 2/2008/2005/2000/7.0, Oracle 9i/8.x, DB2, MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tool: SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services),DTS (Data Transformation Services), Bulk Copy Program (BCP)

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

Operating Systems: Windows 8/7/2003/2000/ XP, UNIX.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio (SSMS), SQL Server 2005 Query Editor, Solution Explorer,Reporting Server, Business Intelligence, Development Studio (BIDS).

PROFESSIONAL EXPERIENCE

Confidential, Glendale, CA

SQL MSBI Developer

Responsibilities:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Involved in database Schema design and development.
• Migrated Database from SQL Server .
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Executed stored procedures using BATCH files.
• Modified, deleted, added the data by using OLTP.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Developed stored procedures and functions for designing various reports.
• Used Batch Files to Import Data from other Data Base.
• Developed Corporate Standard Master Pages, Page Layouts and other User Interface components usingSharepoint Designer 2013and Visual Studio 2012.
• Consolidate existing data from various systems intoSharePointand supporting SQL Server.
• CreatedSSIS DBcatalogwith SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling
• Process SSAS cubes to store data to OLAP databases
• Defined report layouts for formatting the report design as per the need.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dash boards using Microsoft Performance Point service.

Environment: SQL Server Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, Java, XML, Visual Studio 2008 & 2005, MS Visio 2007.

Confidential, Frederick, MD

Lead MS BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Designed and developed SQL Server Reporting Services (SSRS) SQL Server 2005/2008.
• Involved in Report writing according to business requirment usingSSRS and Crystal Reports.
• Generated database monitering and data validation reports in SSRS.
• Expert in creating Tabular reports, Matrix reports, List report, Parameterized reports, Subreports, Adhoc reports (SSRS).
• Deployed SSRS Reports in SharePoint for web based access for multiple end users.
• Configure the report server and generated the report models for user interactions.
• Involved in Performance Optimization of Microsoft SQL Server stored procedures, Analysis Services and cubes.
• Generated dynamic stored procedures, triggers, Cursors, Joins for the database development.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Involved in order entities, retail sales, and financial transactions by using OLTP.
• Most of the database management systems use OLTP.
• Used Informatica to Extract and load the Data as per the requirement.
• Interacting with Business users and BA’s to gather requirements for creating ETL Packages and Reports.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Creating SSIS Packages using different type’s task and with Error Handling.
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Fine tuned the complex database stored procedures to increase performance.
• Performance tuning and optimization of procedures and queries.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• MigratedDTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Expert in writing stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language
• CreatedSQL Server Profiler traces and used with Database Tuning Advisor (DTA) for optimum performance of T-SQL and MDX queries.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Designing OLAPcubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications.

Environment: MS SQL Server 2005/2008, Management Studio(SSMS), ETL, DTS, Notification Services, Crystal Reports9.0, Data Modeling, OLAP, Data ware Housing, MDX, Share point (2003/2007), T-SQL, Windows 2003 Advanced Server, SSAS, SSIS, SSRS 2005/2008.

Confidential, Dallas, TX

MS SQL Developer

Responsibilities:

• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.
• Designed and modeled Microsoft SQL Server 2005 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2000 data warehouse and data marts.
• Used SSIS packages to roll our data to Live Tables and to Processing Database.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Configure the SSIS Package for run time Parameters and Configured file
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
• Schedule Package using SQL Server Job for weekly/monthly basis.
• XML result set from Stored Procedures to create custom XML file for third party data export.
• Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.

Environment: SSIS, MS SQL Server 2008, Windows Server 2003, SQL Server 2008, SQL BI Suite (SSIS, SSRS), SQL Profiler, PL/SQL, MS Office.

Confidential

SQL Server Developer

Responsibilities:

• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created database maintenance plans for the performance of SQL Server including database integritychecks, update database statistics, re-indexing and data backups.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• 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
• Created data loads and Upgrade scripts for data migrations and validations
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Have deployed packages on different servers by configuring it.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.
• Worked on SSRS to generate more than 60+ reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Created various Weekly and Monthly reports showing detailed information

Environment: SQL Server 2008R2/2005, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.

SQL Server BI Developer

Responsibilities:

• Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
• Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLEDBDrivers.
• Responsible for Design and Normalization of the database tables.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
• Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Used various Control Flow Tasks in the development of various complicated packages.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Developer and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
• Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
• Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
• Identified and worked with Parameters for Parameterized Reports in SSRS 2005/2008.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.

Environment: SQL Server 2000/2005, T-SQL, Windows Server, Microsoft Visio, Performance Monitor, SQL Server Profiler, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).