SUMMARY

• Over 8 years of Experience in Database Design, Development and Support of Microsoft SQL Server 2005/2008/2012 in Development, Test and Production Environments with various business domains like Financial, Manufacturing, Healthcare and RMS - enabled applications.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Hands on experience in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
• Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables.
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler.
• Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technology of the analysis services.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008 R2.
• Experience in Visual Studio Team Foundation Server, Visio.
• Data Warehouse and ODS (Operational data store) usage to create reports.
• Extensive experience in SQL 2005 Partitioning of Tables and Indexes, for Performance, scalability and manageability of Very large databases (VLDB).
• Good Knowledge of SQL Server Clustering, Replication, Data Mirroring, Linked Servers and Log Shipping.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Profiler, Sybase 12.5 ASE

IBM Tools: IBM DB2.

Languages: C, C++, SQL, T-SQL, PL/SQL, Visual Basic 6.0, C#. NET, My SQL, VB.NET, HTML, CSS, AJAX, XML

Operating Systems: Windows 95/2000/2003/ XP/VISTA/7/8/8.1,UNIX, LINUX

Databases: MS-SQL Server 2012/2008 R 2/2008/2005/2000 , MS-Access 2007/2010

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), dashboards tools, web tools.

Scripting: HTML, DHTML, XML, Shell Scripting, Power Shell 2.0.

Reporting Tools: SSRS, SSAS, Crystal Reports, Report Builder 3.0.

DB Utilities and design tools: SQL Server Management Utility, SSAS Cubes, Query Analyzer, MDX scripting.

Application Software: Visual Studio, SQL dialect, MS Office.

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential - Lansing, MI

MS SQL Server / SSIS, SSRS/BI Developer SQL Server/ BI Developer

Responsibilities:

• Worked closely with Business Analysts and data modelers in design of logical and physical design.
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: MS SQL Server 2005/2008 R2/2012, MS SQL Integration Services 2008 R2/2012, MS SQL Reporting Services 2008 R2/2012, SQL Server Agent, MS Access, Crystal Reports, SSAS Cubes, SharePoint 2013, MS Excel Power Pivot, IBM DB2.

Confidential - Des Moines, IA

MS SQL Server / SSIS, SSRS/BI Developer SQL Server/ BI Developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Creating Database Objects like Tables, Indexes, User defined functions, Triggers, Parameterized Stored Procedures, Constraints and Roles.
• Knowledge in designing and developing Data Warehouses, Data marts andBusiness Intelligenceusing multi-dimensional models such asStar SchemasandSnow Flake Schemafor developing Cubes using MDX.
• Design and implementation of Performance TuningandMaintenance planfor consistency checks,backup/restore and Indexes.
• Conductedperformance monitoringand measurement includingTuningand executedDBCC Commands,Sizing Procedure cache,Sizing Data cache, configuredlocksandTransaction Isolation levelsand Index Management.
• Experience in configuringpackage logging, error loggingandevent handlingto redirect error rows and fix the errors in SSIS.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.
• Involved in creating SSIS packages with various transformations like Slowly Changing Dimensions,Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Migrated very complicated Bank Actuate reports into SSRS 2005 and SSRS 2008 R2 which are some not able to migrate but used many work around techniques to migrate this complicated reports.
• Designed and implemented group by, drilldowns, drill through, sub-reports, Parameterized and cascading parameterized reports using SSRS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.

Environment: MS SQL Server 2005/2008 R2/2012, MS SQL Integration Services 2008 R2/2012, MS Access, Crystal Reports, MS SQL Reporting Services 2008 R2/2012, SSAS Cubes, SharePoint 2013, MS Excel Power Pivot, IBM DB2, SQL Server Agent, SQL Server Reporting Services(SSRS).

Confidential - Chicago, IL

MS SQL Server / SSIS, SSRS/BI Developer SQL Server/ BI Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Designed database after analysis of the business requirement.
• Worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis.
• Worked with an offshore development team, communicating on a daily basis with the team.
• Designed the complete flow of the file processing.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Performed T-SQL tuning and optimized stored procedures using SQL Profiler, DBCC Commandsand byanalyzingExecutionPlans.
• Prepared Documentation for the Stored Procedures consuming the greatest amount of CPU resources, taking the longest time to run and which performs the most physical and logical I/O operations using Dynamic Management Views and Functions.
• Data migration (Import & Export using BCP) from text to SQL Server 2008.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, and Merge Join as required using SQL Server Integration Services (SSIS).
• Created SSIS packages and scheduled the jobs to run automatically to process the cube, load data.
• Deployed SSIS packages with a simple one-click deployment to the integration server.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports.
• Generated parameterized queries in SSRS 2008 R2 using data from SSAS Cubes and various heterogeneous data sources.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize the report execution time and to limit the no of records required.
• Experience in Report Builder in SSRS 2005 and 2008.
• Created the SQL server users and file server users with required permissions by including them in the scripts. Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.
• Implemented the SQL agent jobs creation while deploying the database instance itself by adding them on to the post deployment scripts.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Created complex expressions using the MDX scripting to solve complex designs.
• BI reporting using Excel with Power Pivot.
• Performed transactional-level process using Micro Strategy’s relational OLAP (ROLAP) architecture.

Environment: MS SQL Server 2008 R2/2012, Microstrategy, MS Access, MS SQL Integration Services 2008 R2/2012, Crystal Reports, MS SQL Reporting Services 2008 R2/2012, SharePoint 2013, SSAS Cubes, MS Excel Power Pivot, IBM DB2, SQL Server Agent, SQL Server Reporting Services(SSRS).

Confidential - Houston, TX

SQL Server/ BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created Complex Stored procedures, user defined Functions, Schema Binding Views. Extensively used CTE's for complex coding.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS 2012.
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Data migration (import & export/BCP) from Text to SQL Server.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables.
• Converted Non-Unicode data from different databases into Unicode data and move the data to staging databases.
• Involved in Query optimization and tuning stored procedures for better performance.
• Executed database backup task, check database integrity, rebuild indexes, update statistics task for maintenance.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2012 and also have hand on experience in PVCS, EDI etc.
• Created packages in SSIS with error handling.
• Developed Drill Down, Cascading, and Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users.
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2012.
• Work closely with internal customers analyzing problems and to create and maintain reports, maintaining SSRS Reports and ad-hoc SQL scripts.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Experience in Designing and Building the Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS 2012.
• Carry out creation of SDLC documentation for existing applications.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes specifically waterfall and Agile Scrum methodology including Analysis, Design, Programming, Testing and technical Documentation.

Environment: SQL Server 2012 Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), MDS, Netezza database, DQS, DTS, C#, .Net, T-SQL, XML, XD, MS Excel, MS Access, MS visual Studio, BIDS, MS Power Point 2012.

Confidential - Parsippany, NJ

SQL Server/ BI Developer

Responsibilities:

• Created SSIS packages to load data into Sql Server using various transformations in SSIS.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Extensively used Teradata SQL Assistant to extract data from Data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Made modifications and added new MDX queries to the cube.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2012 database and performed tuning and audit analysis on it.
• Migrated database from SQL server 2008 R2 to SQL server 2012 using utilities i.e. exp/imp and attach/detach for SQL servers 2012 futures.

Environment: SQL Server 2008 R2/2012 (SSIS, SSAS, SSRS), MDX, T-SQL, TeraData, SQL Server Analysis Services, EDI, SQL Profiler, VSS, MS Excel 2010, MS Word 2010, Power point 2010, Netezza database, Crystal Reports.

Confidential - Somerset, NJ

SQL Server/ BI Developer

Responsibilities:

• Created many new reports according to the business user requirement with includes complicated expressions and tables with as many as 36 fields in the reports.
• Perform unit testing at various levels of the Reports.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2008 R2.
• Written complex stored procedure according to the business requirements for reporting purpose.
• Designed & developed the various SSIS packages for the Weekly & Monthly Loads from business users in different locations in United States (Tampa. FL, Bridgewater. NJ, Morristown. NJ).
• Managed the ETL processes between various environments through scripts utilizing linked servers, DTS packages and SSIS.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules using T-SQL.
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application.
• Modified existing database to fit new business requirement by adding tables and relationships.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).

Environment: MS SQL Server 2005/2008 R2, Windows XP, UNIX, Visual Studio, IBM Lotus, IBM Same time, Borland Star Team, Compare IT, Performance Point Server, Microsoft Office, Snag IT 10, Netezza database, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T-SQL, PL/SQL, MDX/DMX, Power point 2010, Microsoft Project, Microsoft Outlook, XML, IIS, Microsoft Access.

Confidential - White Plains, NY

SQL Server/ BI Developer

Responsibilities:

• Ensured project requirement and delivery with active interactions with end users.
• Redesigned and tuned stored procedures, triggers, tables, UDF, views, recursive CTE, indexes and was successfully able to increase the performance of the queries.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, cross tabs and charts.
• Created complex store procedures for data profiling process needed to define the structure of the pre staging and staging area.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2008 R2 Integration Services (SSIS).
• Used SSIS control flow task, Analysis service processing task to individually process the partitions and the dimensions and updating the cube as changes occurs in underlying data warehouse.
• Created automated backup of OLAP cubes as well as normal backup using SQL server management studio and SSIS package.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Extensively involved in all the phases of report life cycle (Authoring, Managing, and Delivering).
• Created ad-hoc reports, and complex Enterprise reports (drill down, and drill through reports, Parameterized reports, cascading report) using SQL Server Reporting Services and report manager. Created linked reports using report builder.
• Involved in trouble-shooting of reports in Authoring, managing, and delivery phases on multiple servers.
• Used Notification services to generate error messages and send them to the user through e-mails.

Environment: SQL MS SQL Server 2008 R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX, Erwin, MS-Access 2010.

Confidential - Memphis, TN

SSRS/SSIS/SQL Developer

Responsibilities:

• Responsible for SQL Server 2008 R2 database development, database modeling, and database program.
• As a member of Database and BI Reporting team, extensively worked on T-SQLs, Data loads and Reports for Land Administration & Revenue Accounting groups.
• Involved in Creation of Dimensions using Star and Snowflake Schema.
• Involved in database modeling using Erwin tool and diagrams for mapping Entity relations among all the objects.
• Experience in Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery.
• Developed, designing and deploying of various complex reports such as Drill down, Tabular reports, Parameterized, Pie charts using Expressions, Global variables and Functions in MS Reporting Services.
• Experience with Data migration utilities (Import & Export - BCP, Bulk Insert) from text to SQL Server.
• Defined Relationships between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, and Dimension Granularity within a Measure Group.
• Defined Calculated members, named sets, and executed other script commands using MDX Expressions.
• Deployed and processed OLAP Cubes.
• Created complex OLAP cubes with multiple fact measures groups, and multiple dimension hierarchies based on the reporting needs.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS.
• Designed and Developed KPIs, Aggregations and Cube Partitions.
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver the reports.
• Extensively worked on Report coding to behave according to the front end CRM Application.
• Configured Subscriptions and Security for all critical reports.

Environment: SQL Server 2008 R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), DTS, Visual SourceSafe, OLAP, Performance Point Server, Enterprise Manager, Query Analyzer, SQL Profiler, Active Directory, DB2 (Main-Frame), Erwin 5.1,Database Diagrams, VB Script, VB.Net, Power point 2008.

Confidential

Jr. SQL Developer

Responsibilities:

• Conducted Performance tuning/MS SQL server development - SQL Profiler, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Created and administered multiple development, training and production databases.
• Developed and created data dictionary, advanced queries, views, indices, and functions for databases.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Responsible for database security of the operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: MS SQL Server 2000/2005, T-SQL, DTS, Oracle 8i/9i, TOAD, Micro strategy, Microsoft Visual Source Safe, MS Visio 2007, MS Projects 2007(v12.0).