PROFESSIONAL SUMMARY

• Over 7 years of experience as SQL Server/Business Intelligence developer in database designing, modeling, and reporting using SQL Server 2012/2008/2005/2000, SSIS, SSRS and SSAS.
• Experience in requirement analysis, designing, coding, testing and evolution phases in a software development life cycle.
• Experience in writing technical design documents and developing testing documents.
• Held meetings with stakeholders to understand both technical business needs and requirements as required.
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for applications and database.
• Expert in performing T-SQL DDL/DML/DCL commands using SQL Server Management Studio SSMS .
• Rich development experience in creating tables, views, triggers, stored procedures, user defined functions and other T- SQL statements.
• Expert knowledge in using data modeling tools like ERWIN and ER diagrams.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Experience in extracting and transforming data using DTS, Import and Export Data wizard.
• Highly experienced in whole cycle of DTS/SQL server integration services SSIS 2005/2008 packages Developing, Deploying, Scheduling, Troubleshooting and monitoring for performing ETL Purposes across different servers.
• Expertise in generating reports using SQL Server Reporting Services SSRS 2005/2008 , Crystal Reports, and MS Excel spreadsheets.
• Expert in designing enterprise reports using SQL Server Reporting Services SSRS 2005/2008 to generate drill down reports, drill through reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts.
• Experience in creating Ad-hoc reports, data driven subscription reports by using report builder in SSRS 2008.
• Having Good knowledge in developing Cubes and Dimensions using SQL server Analysis services SSAS .
• Experience in dimensional data modeling using star and snowflake schemas for fact and dimension tables using SSAS.
• Good exposure in SQL Server 2012 in my recent project.
• Experience in optimizing the database by creating various Clustered, Non-clustered Indexes.
• Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision. Good understanding of Insurance, Financial and Retail domains. Expert in working with trace files and execution logs.
• Highly self-motivated and excellent time management skills. Strong interpersonal and communication skills.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Role: MS SQL Server/ Business Intelligence SSIS, SSRS Developer

Confidential is a Fortune 500 company offering a diverse range of financial services and solutions. With a strong focus on four core business areas as life insurance, annuities, retirement plan services, and group protection. Database development and report generation are the integral parts of the application. This application created a more user friendly experience.

Responsibilities:

Actively involved in interacting with front end users, project lead, business analyst to gather user requirements and online system specifications.

• Documented the user requirements based on functional specifications.
• Designed the data models using Erwin.
• Created database schema and number of database objects like tables, views, stored procedures, user defined functions using SQL Server management studio.
• Involved in writing complex SQL scripts which includes transact statements, database object validation, and exception handling to facilitate functionality in different modules.
• Handled errors using exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Created audit tables and implemented complex business logic using triggers.
• Used cursors and cursors with dynamic SQL for fetching data and processing it.
• Maintained the table performance by following the tuning tips like normalization, creating clustered and non-clustered indexes and collect statistics.
• Transformed the complex business logic and calculations into coding.
• Created ETL packages using heterogeneous data sources SQL Server, ORACLE, Flat Files, Excel source files, XML files etc and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Used different transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Created DTS package to schedule the jobs for batch processing.
• Generated various reports with drilldowns, drill through, calculated members and dropdowns from the cubes by connecting to analysis server and SQL Server from SSRS.
• Used various report items like tables, lists, matrix, sub report and charts to develop the reports in SSRS and upload into report manager.
• Created subscription of reports in different formats like PDF, excel, word etc to be generated automatically on weekly or monthly basis using SSRS.
• Worked on requirement analysis, coding and testing various modules in a software development life cycle.

Environment: SQL Server 2012/2008, SSMS, SSIS, SSRS, ERWIN, MS-Excel, Windows 7, Visual Studio

Confidential

Role: MS SQL Server/ Business Intelligence SSIS, SSRS, SSAS Developer

Confidential is a Leading nonprofit worldwide organization with more than 58 million beneficiaries from 125 national associations. The Y is a powerful association of men, women, and children committed to bringing about lasting personal and social change. With a focus on nurturing the potential of every child and teen, improving the nation's health and well-being and providing opportunities to give back and support neighbors, the Y enables youth, adults, families and communities to be healthy, confident, connected and secure.

Responsibilities:

• Involved in gathering the requirements from the sales operations team.
• Documented the requirements based on functional specifications.
• Implemented Complex business Logic as per the client requirement.
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Greatly involved in performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.
• Generated multiple enterprise reports using SSRS from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included
• various reporting features such as group by, drill down, drill-through, sub-reports, navigation reports Hyperlink etc.
• Created different parameterized reports SSRS 2005/2008 which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default queried and non queried parameters .
• Created hierarchies so that the respective user / team understand data easily.
• Created all types of report types like tables, matrix, charts, sub-reports etc.
• Created ETL packages using heterogeneous data sources SQL Server, ORACLE, Flat Files, Excel source files, XML files etc and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Worked on dimensional data modeling using star and snowflake schemas for fact and dimension tables.
• Developed OLAP cubes by using SQL Server Analysis Services SSAS , worked on performance tuning of SSAS cubes.
• Involved in development deployment of SSAS cubes and monitored full, incremental loads and support any issues.

Environment: MS SQL Server 2008 SSMS, SSRS, SSIS, SSAS , MS Access, Erwin, SQL Query Analyzer, Windows XP

Confidential

Role: MS SQL Server/ Business Intelligence SSIS, SSRS, SSAS Developer

Client Description: Applied Medical is leading organization in providing innovative products that improve patient outcomes and enable the advancement of minimally invasive surgery. My role in the team is to support the sales operations team with their daily operations by developing packages to extract, transform and load the data, cubes to analyze the data of their customers and generate reports on the monthly basis to keep track of the sales etc.

Responsibilities:

• Performed review of the business process, involved in requirements analysis, system design documents, flows, test plan preparations and development of business process and work flow charts.
• Performed database design and implementation using SQL Server and data modeling tools.
• Involved in various data transformation and cleaning techniques like cast, convert, trim etc.
• Developed database objects like tables, views, indexes, stored procedures, common table expressions.
• Involved in writing queries with join conditions, correlated sub queries, and nested queries for the business application development.
• Created custom T-SQL procedures to read data from flat files to dump to SQL Server database using SQL Server import and export data wizard.
• Developed procedures and database triggers for the validation of input data and to implement business rules.
• Developed user defined functions based on the requirements and also used various built-in functions.
• Handled errors using exception handling try, catch extensively for the ease of debugging and displaying the error messages in the application.
• Involved in adding, validating, dropping the XML schema to the database.
• Developed backup restore scripts for SQL Server as needed.
• Resolved any deadlocks issues with the databases/servers on a real-time basis using transaction and locking strategies.

Environment: MS SQL Server 2005 SSMS, Import and Export Data Wizard , Windows 2000, MS- Excel, Word.

Confidential

Role : MS SQL Server Developer

Client Description: Mind fire solutions are the leading global provider of engineering and geospatial software that enables customers to visualize complex data. The company's software and services empower customers to build and operate more efficient plants and ships, create intelligent maps, and protect critical infrastructure and millions of people around the world.

Responsibilities:

• Actively involved in interacting with front end .net developers, and gathered user requirements and online system specifications.
• Created new logical and physical database design to support multi-year conferences for the tables of employees, histories, skills, experience and payroll.
• Created database objects like tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions in SQL Server.
• Extensively worked with dynamic SQL, composite data types and global temporary tables.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Created and reallocated database objects on appropriate file groups to ease maintenance and improve data access performance.

• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Developed scenarios for unit, integration testing to ensure that all the components work correctly when integrated.

Environment: MS SQL Server 2000 SSMS, Import and Export Data Wizard , Windows 2000, MS- Excel, Word.