SUMMARY

• Over 7+ years of IT experience as a MS SQL Server Developer 2012/2008/2005 in various Industry verticals like Health Care, Finance and Insurance.
• Experience in Installation and Configuration of SQL Server 2012/2008/2005.
• Extensive experience in MS SQL Server 2012/2008/2005 BI tools (SSDT) like SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS) and SQL server Analysis Services (SSAS)
• Experience on Performance Tuning, Client/Server Connectivity, Query Optimization, running database consistency check with DBCC Commands.
• Extensive experience in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, and User Defined Functions.
• Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks.
• Highly experienced in complete cycle of SQL Server Integration Services ( 2012/2008/2005 ), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Excellent in using all kinds of SQL Server Constraints and Dynamic-queries.
• Highly proficient in the dealing with Complex Stored Procedures, Views, Data Import/Export, System Views and functions.
• Experience in Extraction and Migration of data from various data sources like Excel, MS Access and Oracle to MS SQL Server by using import/export Wizard, DTS/SSIS, BCP and Bulk Insert utilities.
• Strong Experience in writing, debugging, fine-tuning and optimizing complex Stored Procedures, Cursors and Triggers in SQL Server by analyzing the Query Execution Plan and using the Profiler.
• Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Experience in Scheduling and Monitoring ETL processes using DTS Exec utilities and batch files.
• Strong knowledge on Row Transformations, Partial Block and Block Transformations.
• Hand on Experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Experience in creating Ad-hoc reports and data driven subscription reports by using Report Builder.
• Experience in creating complex drill down reports, parameterized reports, dropdowns and images, charts using SSRS 2012/2008/ 2005 , Crystal Reports and MS Excel for the analyzing data at an enterprise level.
• Experience in using Global Variables, Expressions and Functions for the reports.
• Expert in creating and deploying SSRS reports on the portal for user accessibility.
• Experience in Development, Deployment and Troubleshoot Reporting services using SSRS 2 across various environments.
• Experience in creating Cubes with dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Experience in data architecture design and used data modeling tools like Erwin for designing the logical and physical data models.
• Developed a thorough knowledge in understanding business processes, gathering requirements, and coordinate ongoing iterative development of Software Development Life Cycle (SDLC).
• Excellent analytical, Communication and interpersonal skills. Excellent Communication skills, excelling as a team player and equally excelled when worked individually to achieve all project deliverables successfully.
• Proven ability to approach and solve problems effectively and independently.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2005/2008/R2/2012, Access, Oracle10g.

Database Tools: BIDS 2005/2008, SSDT 2012, Management Studio, Analysis Services (SSAS), Visual Studio, Query Analyzer, SQL Profiler, TFS.

Data Modeling Tools: ERWIN 7.3, Power Designer 12.5, ER Studio 8.0.1, MS Visio 6.0.

Programming Languages: SQL, T-SQL, PL/SQL, VB.NET, C#.NET, ASP.NET, C, C++.

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)Import/Export Wizard, Bulk Insert, BCP.

Scripts: PHP, JavaScript, CSS, VBScript, C#, HTML and XML.

Applications: Microsoft Office 2000/2003/2007.

Operating systems: Windows 2000/XP/2003/2008.

Reporting Tools: SSRS, Report Builder, Business Objects, Crystal Reports.

PROFESSIONAL EXPERIENCE

Confidential, Rochester, Minnesota

SQL Server BI Developer

Responsibilities:

• Analyze utilization data to identify patterns and trends that may impact overall performance.
• Work closely with PM and Development teams to create and test the mappings to heterogeneous sources to the data ware house.
• Created Database Objects like Stored Procedures, Triggers and User Defined Functions (UDF) for this project.
• Created Views to maintain security of customer data.
• Created Indexes to get the high level performance.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
• Designed SSIS packages for synchronizing the data between two different servers.
• Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions for better performance during package execution.
• Created SSIS Packages to migrate slowly changing dimensions.
• Create Power View reports using Power Pivot Data models.
• Import data from SQL Server databases and Analysis services into power pivot data model.
• Create calculated columns and calculated measures using DAX functions and format with appropriate data types.
• Design and develop Tabular Data model (SSAS) and deploy that on to the Share Point server.
• Create Daily/Weekly/Monthly power view reports using Power BI and schedule them on the SharePoint for the refresh.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created Ad-hoc reports and cascading reports for historical data using SSRS.
• Involved in the post deployment maintenance of canned reports and cubes.
• Involved in the design, development and maintenance of different cubes using SSAS.
• Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
• Created Partition table for very large database for good performance.
• Configured mail profile for sending automatic mails to respective people when job is failed or succeed.
• Created partition function, schema and file groups for fact tables.
• Implemented Unit Tests and Integration Tests.

Environment: MS SQL Server 2012/2008, Power BI, C#, TFS, Query Analyzer, Windows 2008, SSAS, Excel, Oracle10g.

Confidential, Richmond, Virginia

SQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Analyze the client requirements and translate them into technical requirements.
• Created new database objects like Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Import various flat flies into our databases using SSIS packages.
• Develop SSIS Packages to Extract, Transform and Load (ETL) data into the Data Warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Develop packages with monitoring features and Logging capturing the audit information of the packages and their execution results for support and troubleshooting.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like excel spreadsheets, flat file and vice versa.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Schedule SSIS packages as job to run on daily basis for the data loading.
• Created Ad-hoc reports and data driven subscription reports by using Report Builder.
• Developed Bar chart and Pie chart reports.
• Create drill-down, parameterized and sub reports and schedule them for the daily refresh.
• Report administration by creating roles and providing permissions to users/groups.
• Monitor the performance of the reports and modify the SQL queries and functions used in the reports to improve the performance.
• Studied the existing OLTP system(s) and created facts, dimensions and star schema representation for the data warehouse.
• Create cubes on top of the data warehouse for reporting purpose.
• Created complex aggregations and MDX calculations for financial reporting.
• Created roles on the cubes to enable security and restricting access specified users and groups.

Environment: MS SQL Server 2008/2005, Reporting Services, SSMS, Enterprise Manager, Query Analyzer, Report Builder, ERStudio.

Confidential, Bloomington, IL

SQL BI Developer

Responsibilities:

• Perform ETL operations to support the data loads and transformations using SSIS.
• Created distributed partitioned views, debugging / troubleshooting stored procedures, upgrading existing ones according to new requirements.
• Perform Ad-hoc analysis as and when required by the higher management.
• Change existing stored procedures upon request to implement new business logic.
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task and different data flow tasks using T- SQL and VB scripts.
• Update SSIS packages to populate new dimensions and facts.
• Design SSIS packages for synchronizing the data between two different servers.
• Schedule daily and weekly SSIS jobs on SQL Server Agent.
• Generate reports using SSRS that could be used to send information to different primary vendors, clients and mangers.
• Develop tabular, drill down, cascade and sub-reports using SSRS.
• Deploy reports onto the Reporting server and provide the data connections accordingly.
• Create roles and maintain the security by assigning users to appropriate permissions.
• Generated dynamic reports from the Multi-Dimensional databases.
• Involved in dimensional modeling with Star & Snowflake schemas and created the data source views (DSV) and cubes using the identified fact and dimension tables.

Environment: MS SQL Server 2008/2005, Reporting Services, SSMS, Enterprise Manager, Query Analyzer, Report Builder, ERStudio.

Confidential

SQL Developer

Responsibilities:

• Participated in installation of SQL Server and Enterprise manger tools using SQL Server Setup Program.
• Created tables, indexes and constraints.
• Created Views, Triggers in T-SQL.
• Defined stored procedures for module integrity and application.
• Involved in performance tuning of the database and T-SQL queries.
• Migrated access objects to SQL Server 2005.
• Extensively used Import/Export Wizard for performing the ETL operations.
• Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Designed and implemented several complex reports.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using crystal Reports.
• Created different user level groups, and assigned appropriate permission level to the database.
• Preparation of project documentation.

Environment: SQL server 2005, Visual Basic, Windows 2003, Crystal Reports.