SUMMARY

• 9 years of total experience as an accomplished Senior SQL Developer, with Experience in System Design, Development and Support of Microsoft SQL Server 2012/2008/2005 in Development, Test and Production Environments.
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008/2005/2000.
• Expertise on Business Intelligence Tools (Analysis Services, Integration Services and Reporting Services).
• Good working experience in Management Studio, Enterprise Manager, T - SQL, and SQL Jobs and Query Analyzer.
• Experience in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Erwin Tool.
• Experienced in Data Warehouse Design and architecture, Data Analysis, Data Mining, Relational data modeling, Dimensional modeling, business modeling and UML methodologies.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Extensive Experience in creating and maintaining security mechanisms for reports, creating repository domains using Business objects Supervisor.
• Extensive experience with building Universe, defining objects, classes, resolving loops.
• Involved in Data Migration from SQL Server 2005 to SQL Server 2008.
• Worked on ProClarity to create, deploy and analyze Reports based on MSAS Cubes.
• Experience in creating connectivity between already generated Cubes.
• Good experience in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2008.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS)
• Excellent Report creation skills using Microsoft Reporting Services (SSRS) 2008.
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
• Creating Dashboard pages that use Excel Access web parts and Reports.
• Developed, Monitored and Deployed SSIS Packages from Development environment to Production environment.
• Experience in using Try Catch Block introduced in SQL Server 2005.
• Extensively used tools like SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Extensive experience in creating Tables, Views, Indexes, writing Stored Procedures, Triggers using T-SQL (DML and DDL) as well as analyzing and debugging existing complex stored procedures.
• Experience in writing complex T-SQL queries using Inner Joins, Outer Joins and Cross Joins.
• Extensive experience to analyze and document business requirements and system functional specifications including use cases.

TECHNICAL SKILLS

• C
• C++
• C#.Net
• T-SQL
• MS SQL Server 2012, 2008, 2005, 2000
• SQL Server Management Studio(SSMS)
• SQL Server Analysis Services 2005
• MS SQL Server Integration Services 2005
• SQL Server Reporting Services 2008
• Microsoft Visual Studio
• Team Foundation Server
• E-Reporting tool (In Built tool for reporting)
• JIRA
• MS Access
• MS Visual Basics 6.0
• ASP.Net
• ADO.Net
• WCF Web Forms
• XML Web Services
• HTML
• Microsoft Office SharePoint Server (MOSS) 2007
• Crystal Reports
• Business Objects
• IIS 5.1/6.0
• ERWIN 4.0
• ETL
• Visio 2002
• Windows 2000 Advanced Server
• Windows 2000 data center
• Windows NT
• Windows

PROFESSIONAL EXPERIENCE

Software Developer

Confidential, Sunrise, FL

Responsibilities:

• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Plan, design, and implement application database objects, such as stored procedures, functions and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in performing data conversions from flat files into a normalized database structure.
• Performed ETL Operations on Large Datasets with quick turnaround for Reports and Analysis.
• Involved in creating sophisticated ad-hoc and custom analysis to support medical claims and compensate medical claims efficiently.
• Designed parameterized reports and ad-hoc reports using Report builder for the brokers and clients.
• Responsible for designing, creating and deploying the reports into the production server.

Environment: Microsoft SQL Server 2012, SQL Server Reporting Services(SSRS), SQL Server Integration Services(SSIS), Microsoft Visual Studio 2010, SQL Profiler, JIRA, Team Foundation Server (TFS), Microsoft Word/Excel 2013.

Senior Programmer Analyst

Confidential, Maple Grove, MN

Responsibilities:

• Involved in Analyzing business requirements, report data specifications along with the team.
• Wrote SQL queries to generate reports according to the business rules.
• Extensively used joins and sub-queries for complex queries, which were involving multiple tables from different databases.
• Analyzing data and re-mapping fields based on business requirements.
• Created Roster reports, Survey reports for the different states.
• Responsible for proper deploying and exporting reports as per the requirements.
• Performance tuned the stored procedures and queries for efficient Report generation.
• Importing XML files into table using E-reporting tool and validated the data against the different states provided tables with requirements specified in documents.
• Interacted with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Participated in daily stand ups as a part of agile software development lifecycle.
• Performed Unit Testing in Test Environment and Production Environment.
• Tracking and updated the status of tasks in the smart sheet (in built application).
• Worked closely with developer to track, log and follow through on all software bugs, and provided more information about bugs thereby helping them to fix any issues.

Environment: Microsoft SQL Server 2012, E-Reporting tool (In built tool for Reporting), Smart sheet (In built tool for tracking tasks), JIRA, Team Foundation Server (TFS), Microsoft Word/Excel 2013.

Senior SQL Developer/ SSRS Report Developer

Confidential, Phoenix, AZ

Responsibilities:

• Created Complex Stored procedures and queries to pull data out of database for generating reports.
• Created databases, tables, stored procedures, DDL/DML triggers, views, functions and cursors using T-SQL
• Extensively using joins and sub-queries for complex queries, which were involving multiple tables from different databases.
• Analyzing data and re-mapping fields based on business requirements.
• Developed aggregate strategies to aggregate data, sorting and joining tables.
• Performance tuned the stored procedures and queries for efficient Report generation.
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Designed and deployed reports with Drill Down, Drill Through and Dropdown menu option and Parameterized and Linked reports.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Executed and maintained timely and accurate report delivery through SSRS Subscription.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Actively participated in User Acceptance Testing, and debugging of the system.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Generated test data and tested database to meet the functionalities deliverables in the project. Assisted in Documentation and specifications.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Advise proper SSRS standards and created documentation on standard set forth for report formatting.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.

Environment: MS SQL Server 2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T-SQL, Microsoft Visual Studio 2010, Team Foundation Server (TFS), Crystal Reports X1, Business Objects, pgAdmin III, Windows

Senior SQL Server Developer

Confidential, Overland Park, KS

Responsibilities:

• Extensive Dashboard reports development using SQL Server Reporting Service (SSRS) for managers and executives.
• Developed various Drill down and drill through reports which involved complex chart-based reports.
• Enhanced deployment process of SSRS reports by performance tuning of various report aspects.
• Executed and maintained timely and accurate report delivery through SSRS Subscription.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Performance tuned the stored procedures and queries for efficient Report generation.
• Responsible for proper deploying and exporting reports as per the requirements.
• Created SQL Server Reports using SSRS 2005 and developed query for drill down reports.
• Worked on Report generation using SQL Server Reporting Services (SSRS) that could be used to send information to managers.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Maintained scheduling the subscription reports
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created report models and deployed on report server.
• Created standard report Subscriptions and Data Driven report Subscriptions. Created report snapshots and cache for better performance.
• Reviewed and developed data models and database designs with development teams
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Developed MS SQL Server Reporting Services (SSRS) under SQL Server 2000, SQL Server 2005 and SQL Server 2008

Environment: SQL Server 2008/MSDE, MS Access, Query Analyzer, BCP, SQL Profiler, T-SQL, Import & Export Data, DTS, Windows 2000 Server