Professional Summary:

• 7.5 years of strong experience in Information technology industry covering all stages of development life cycle including business process analysis, requirements gathering and analysis, high level design, detailed design, development, testing, QA and post implementation support.
• Excellent experience in design, development, implementation and administration of database systems using MS-SQL Server 2008/2005/2000 for both OLTP Data Warehousing Systems applications in Financial, Wireless and Health industries.
• Extensively experienced in database activities like Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
• Extensive knowledge in design of logical and physical data modeling using Erwin tool and consistency check using DBCC utilities.
• Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
• Extensive experience in Data Extraction and Transforming and Loading ETL using DTS package in MS SQL Server 2000 and SQL Server Integration Services SSIS in MS SQL Server 2008/2005 with .NET, Import/Export data, Bulk insert and BCP.
• Expert in SSIS script transformations using C Script and scheduling complex SSIS Packages for transferring data automatically from multiple data sources to SQL server.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services SSRS .
• Experienced in report generation using Crystal Reports, XML, MS Access and Excel spreadsheet.
• 2 years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as a Developer and Analyst.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experienced with aggregation using OLAP analysis services cube.
• Proficient in implementing surrogate key generation strategy in the Data warehouse.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Organized professional with excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, fast learner and also adept quickly new technology with ability to take new roles in minimum time and little training.

Business/Technical Skill:

MS SQL Server 2014/2012/2008/2005/2000, T-SQL, SQL Server Management Studio, Business Intelligence Development Studio BIDS , SQL Agent, Data Transformation Services DTS , SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , Erwin Data Modeler, MS Visio, SQL Profiler, Bulk Insert, BCP, Visual Source Safe Code management tools 6.0., C , VB.Net, PL/SQL, Oracle 10g/9i/8i, HTML, XML, UNIX, Windows Server 2008/2003, Crystal Reports XI/X/9.0, MS Access,PowerPivot,ASP.Net ,C .

Projects Summary:

Confidential

Confidential known as Grange Insurance, is an American insurance company based in Confidential. Grange markets its products exclusively through a network of about 3,600 independent agents to offer home, auto, life, and business insurance protection to policyholders

Responsibilities:

• Creating SSIS Package configurations for executing in different environments in SQL Server 2014 using Package Deployment Model.
• Creating ETL SSIS Packages on SQL Server 2014 for Data Warehouse using Type 4 Slowly Changing Dimension Model
• Fine-tuned SSIS Packages using pipeline processing techniques and memory buffers.
• Data Cleansing of different data from landing areas to Staging before performing SCD transformation for loading into FACT and DIMENSION tables.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Preparing Dashboards using calculations, parameters in Tableau and SSRS

Confidential

SQL Server developer SSIS/SSRS/T-SQL

Confidential is an enterprise data, analytics and software as a service company. For more than 40 years, Confidential has been a leader in harnessing the powerful potential of data to strengthen connections between people, businesses and their partners.

Responsibilities:

• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa.
• Creation/Modified complex stored procedures which are used for various reports.
• Used DDL and DML to writing Triggers, Stored procedures to check the Data Integrity and payment verification at early stages before calling them.
• Created/Maintained clustered/non clustered Indexes for fast and efficient reporting process.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Documented the Stored Procedures and User Defined Functions UDF for future references and maintenance.
• Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Used PowerPivot server components to load the data, process queries, perform scheduled data refresh, and track server and workbook usage.
• End to end experience in designing and deploying data visualizations using Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets , Groups, Parameters etc., in Tableau.

Environment: SQL Server 2008/2005, SSRS, SSIS, Oracle, MS Accesses 2003, MS Excel 2003, MS Visual Studio 2008/2005 ,Performance Point Server, PowerPivot, ASP.NET,IIS

Confidential

BI developer SSIS/SSRS/T-SQL

Confidential through our family of healthcare companies, provides health benefits to people with Medicare. We are dedicated to a Healthy Collaboration, working together with healthcare professionals in order to improve the health and well-being of our members. Involving in maintaining the customer database of customer details and drugs details. Worked closely with various departments like Collections, Risk and Confidential Compliance and EDI processing and Data mining According to Business Requirements and did Sequence Analysis , Deviation analysis , Regression and Forecasting

Responsibilities:

• Creation/Modified complex stored procedures which are used for various reports.
• Used DDL and DML to writing Triggers, Stored procedures to check the Data Integrity and payment verification at early stages before calling them.
• Created/Maintained clustered/non clustered Indexes for fast and efficient reporting process.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Documented the Stored Procedures and User Defined Functions UDF for future references and maintenance.
• Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Used PowerPivot server components to load the data, process queries, perform scheduled data refresh, and track server and workbook usage

Environment: SQL Server 2008/2005, SSRS, SSIS, Oracle, MS Accesses 2003, MS Excel 2003, MS Visual Studio 2008/2005, Windows 2000 Server, DTS Wizards, Share-point, Dashboard, Performance Point Server,PowerPivot,ASP.NET,IIS

Confidential

SQL Server BI Developer

Confidential is a global British investment bank. It is the investment banking division of Barclays plc which has a balance sheet of over 1.2 trillion Confidential Capital provides financing and risk management services to large companies, institutions and government clients. It is a primary dealer in Confidential Treasury securities and various European Government bonds.

Responsibilities:

• Involved in all the phases of SDLC.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of constraints and Triggers for Data Consistency.
• Used Stored Procedures for updating Servers.
• Created and Deployed Custom Components in C .NET .
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used SQL Server Integration Services SSIS and its tools to Extract, Transform and Load data into Data Ware House and for OLTP side.
• Creating and running SSIS Packages for Importing Data from CSV, Pipe Delimited and Fixed Length Files.
• Responsible for creating log files for SSIS packages, Package configurations for executing in different environments and Enabled Check points in SSIS package.
• Created break points in order to view the status of data, variables and over all status of SSIS package
• Standardized company reports by implementing SQL Server Reporting Services SSRS .
• Created various dynamic reports using SSRS.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
• Creation/Modified complex stored procedures which are used for various reports.
• Used DDL and DML to writing Triggers, Stored procedures to check the Data Integrity and payment verification at early stages before calling them.
• Created/Maintained clustered/non clustered Indexes for fast and efficient reporting process.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Documented the Stored Procedures and User Defined Functions UDF for future references and maintenance.

Environment: SQL Server 2008/2005, SSRS, SSIS, Oracle, MS Accesses 2003, MS Excel 2003, MS Visual Studio 2008/2005, Windows 2000 Server, DTS Wizards,C .NET

Confidential

SQL Server Developer SSIS/SSRS

Confidential is a financial services firm specializing in retirement savings and providing other services like Life/Business Insurance. Foresight Financial is a leading international insurance organization of commercial and industrial insurance in the Confidential. The purpose of our project was to build data warehouse for Life Insurance.

Responsibilities:

• Worked as a database developer on databases like MS SQL Server 2008/2005 using T-SQL, stored procedures and views to get data from Data warehouse to Data marts.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel, Text file and MS Access to different data Marts.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server
• Migrated SSIS 2005 packages to SSIS 2008 packages.
• Developed Master Child package using variables and Execute package task in SSIS.
• Deployed, Tested and Scheduled SSIS packages using SQL Agent.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used SQL Server Integration Services SSIS and its tools to Extract, Transform and Load data into Data Ware House and for OLTP side.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created report models for ad hoc reports and deployed on report server.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Developed incremental loading using MERGE statement in SQL server 2008.
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Successfully tested all task in staging and stored all versions of data using team foundation server TFS .

Confidential

SQL Server BI Developer

Confidential has been at the forefront of communication inventions and innovations for nearly 80 years. Confidential develops a portfolio of technologies, solutions and services including wireless handsets, wireless accessories, digital entertainment devices, wireless access systems, voice and data communications systems, and enterprise mobility solutions

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 using SSRS, T-SQL, scripts, stored procedures and views .
• Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Created UDM for cubes in SSAS.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Deployed the reports in to the report server.
• Involved in creating Data mappings in SSIS and created data models using ERWIN tool.
• Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in building of OLAP cubes with SSAS and in adding calculations using MDX.
• Preparation of documents and class diagrams using VISIO.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Involved in Creating SSIS Packages for Importing Data from CSV, Pipe Delimited and Fixed Length Files.
• Creating and running SSIS Packages for Import and Export of Heterogeneous Data.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database Access database and xml format data to SQL Server.
• Used SQL Server Integration Services SSIS and its tools to Extract, Transform and Load data into Data Ware House and for OLTP side.
• Responsible for creating log files for SSIS packages.
• Involved in creating SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS package.
• Created break points in order to view the status of data, variables and over all status of SSIS package.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Environment: SQL Server 2005, SSIS, SSRS, SSAS, XML, Windows 2003/2000 Server, Visual Studio 2005

Confidential

SQL Server Developer/SSIS/ SSRS

Confidential is a research-based global pharmaceutical company. Confidential discovers, develops, manufactures and markets leading prescription medicines for humans and animals, as well as many of the world's best-known over the counter medicines and consumer health products

Responsibilites:

• Developed complex T SQL code for the application.
• Modified the existing database by adding the tables and maintained relationships between the tables.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like billing, customer, and requests from the residential, business and large business databases.
• Created SSIS Dynamic Packages using variables and deployed the SSIS packages.
• Implemented Incremental loads using different kind of tasks using SSIS.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS .
• Created, Managed and Support existing reports using SSRS.
• Involved in creating, deploying and configuring reports according to the requirements using SSRS.
• Developed different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS .
• Developed cubes using SSAS involving multidimensional data.
• Supported various sectors like Development, testing, Production, Maintenance and Application teams.
• Conducted performance tuning by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Executed Test cases manually Using Quality Center.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed requests that came from the development team.

Environment: MS SQL Server 2005, ASP.Net, Management Studio, BIDS, Visual Studio 2005, MOSS, Integration Services, SSRS, SSAS, T-SQL, DTS, ETL, XML, SQL Profiler, Windows 2003.

Confidential

Database Developer

Confidential is the holding company for State Bank of India, the second-largest banking institution in India head quartered in Confidential 36 billion in assets, it has 248 branches in Confidential.

Responsibilities:

• Implemented a well-planned backup and restore strategy that protects databases against data loss
• Responsible for design, development and implementation of mappings/transformations based in source-to-target specifications, defining ETL extract transform, load
• Developed complex SQL queries, stored procedures, and DTS packages
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
• Involved in designing and writing Stored Procedures, functions and packages using T-SQL for SQL Server 2000
• Used DBCC utilities to fix data corruption in application databases
• Development of Business rules implemented as Constraints, Triggers and or Stored Procedures
• Developed reports using Crystal reports.

Environment:

SQL Server 2000 Enterprise, Windows Enterprise Server 2003, Erwin, Microsoft Visio, DTS, SQL Profiler, Query Analyzer