SUMMARY

• Over 8+ years of IT experience as a MS SQL Server Developer in various Industry verticals like Finance, Retailers, Insurance, Pharmaceuticals, Banking.
• Creating, saving, exporting and printing power view reports using power BI.
• Experience in developing the applications usingT - SQL Programming (DDL, DML, and DCL).
• Conversant with all phase of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.
• Provide A description of the purpose of the FROM Clause in an MDX Select Statement.
• Extensive experience in MS SQL Server 2012/2008R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, common table expressions (CTEs, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Experience in using Change Data Capture for track DML Operation on Database level.
• Strong in creating table Partition for better performance for Database and creating Partition Function and Partition Scheme.
• Having Knowledge on Mortgage Banking, Financed And Leasing.
• Provide Basic Syntax Information for the MDX SELECT Statement.
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, Sybase, Excel and MS Access CSV, Oracle, flat file.
• Strong experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Sybase databases.
• Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Describe how to use variables and parameters within MDX Queries.
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages.
• Strong 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.
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Strong in optimizing MOLAP cubes by partitioning them, designing aggregations and implementing hierarchies. Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports and deploying SSRS reports on the portal for user accessibility.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Strong experience in logical and physical database design and development using Erwin and SQL server enterprise manager. Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.

TECHNICAL SKILLS

• MS SQL Server 2014/2012/2008 R 2/2008/2005/2000
• SQL Server Integration Services (SSIS 2005/2008/2012 )
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• DataTransformation Services(DTS)
• ERWIN
• Windows Server 2008
• Windows 7
• UNIX (Sun Solaris)
• Red Hat Linux
• AS/400
• MS Visual Studio 2008/2005
• SQL Server Data Tools
• MS Word
• MS Excel
• VSS
• MS Power Point
• MS Access 2010/2007/2003
• HTML
• WML
• XML

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

SQL Server/BI Developer

Responsibilities:

• Developed various T-SQL stored procedures, functions, views and adding/changing tables for data extraction, data load and transformations.
• Creating Power view report using Power BI.
• Involved in Migration of SSRS 2008 to SSRS 2012.
• Created various database objects such as tables, indexes and views based on the requirements.
• DevelopedSSISpackages with monitoring features and custom logging, loading audit information and execution results into audit tables.
• Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, Sub-reports and Matrix reports and developed some graphical reports using Report Designer.
• Wrote complex SQL Queries using multiple joins for creating Adhoc reports using Report Builder based on the requirements.
• DesignedSSRSreports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Deployed SSRS reports to Report Manager and created linked reports, snapshots, subscriptions for the reports and worked on scheduling of the reports.
• Performed maintenance duties likeperformance tuningand optimization of queries, functions and stored procedures.
• Designed SSIS Packages using various tasks like Execute SQL Task, Bulk Insert Task, Data Flow Task, File System Task, Send Mail Task, Execute Package Task, Active Script Task, Xml Task.
• Responsible for Deploying SSIS Package onto Production and used different types of Package configurations to export various package properties to make package environment independent.
• Analyzing the requirements and creating technical design documents.
• Analyzing different interfaces, metadata, data dictionary and architecture.
• Involved in developing Technical Design specification and promotional documents.
• Maintained business rules in design and create tables, views, stored procedures, indexes and leveraged auditing tables.
• Involved in designing SSIS packages for data mart for sales and partner channel subject areas.
• Created multiple master packages to handle the ETL flow with different check points.
• Developed SSIS packages to process Analysis services cubes and implemented logic for dynamic creation of partitions using Xmla.
• Worked on different SFTP tasks (Task factory, CozyRoc) to transfer data by leveraging auditing tables and load Analysis services cube using facts and dimensions.
• Load data from different sources like flat files, SQL server, CSV and Excel.
• Coordinated with business team for building the new Analysis services cubes with various calculated members and named calculations using MDX.
• Designed various facts and dimension tables for developing the Analysis services cube having many to many relationships.
• Worked on different named queries, named calculations, named sets and time intelligence

Environment: SQL Server Management Studio, SQL Server 2014/2012/2008 R2, SQL Server Data Tools, SQL Server Integration Services, SQL Server Reporting Services, Windows 7/8

Confidential, Phoenix, AZ

SQL Server SSRS/SSIS Developer

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using Sql Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Interact with the Business Admin and gather the requirements and analyzed.
• Interacted with the Project Managers and the Field Managers who would be using the application the most
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Designed SSIS Packages using various Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, Execute Package Task, active script task, xml task.
• Responsible for Deploying SSIS Package onto Production and used different types of Package configurations to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Developed various T-SQL stored procedures, functions, views and adding/changing tables for data extraction, data load and transformations.
• Created various database objects such as tables, indexes and views based on the requirements.
• Hands on experience in developing and writing T-SQL queries, store procedures, triggers, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2000 and MS SQL Server 2005 respectively.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Proficiency in Developing and Extending MS SQL Server Analysis Services 2005 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Good command in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2008/2005 (SSRS).
• Accomplished 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/2005.
• Strong experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.

Environment: SQL Server 2008 R2, SQL Server 2008, SQL Server Data Tools, SSIS, SSAS, SSRS, Windows 7.

Confidential, Durham, NC

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusing Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail Task,Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Created C# Script for Control Flow and Check File existence using Script task in SSIS.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Involved in Production support with Deployment of the SSIS Packages and schedule SSIS packages using SQL Server Agent Job.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Deployed reports on Report Server and SharePoint Server also scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Involved in table and indexpartitioning for performance and Manageability.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Extensive experience working with BCP, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Expert in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.

Confidential, Columbus, Ohio

MS SQL Server/SSIS Developer

Responsibilities:

• Understanding of existing business processes, project functional and technical specifications. Designed &developed packages/workflows for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Created ETL logging Control tables for maintaining a log of all the loads. Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Imported data from text files/excel spread sheets, Informix Database into SQL Server 2005/2008 database using SSIS package. Also designed and generated on crystal reports from various sources.
• Designed SSIS Packages using various Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, Execute Package Task, active script task, xml task.
• Involved in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors that support base views and modules involved in the application for Log View, Demographics, Insurance, Coding both Professional and Facility, Visit, Rules.
• Worked on recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistence as well as to support the existing applications.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Utilized cascaded parameters concept to generate a report from two different Data Sets.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Migrated data from DB2 database to SQL Server database using SSIS.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Involved in extensiveDATA validation by writing several complex SQL queriesand Involved in back-end testing and worked with data quality issues.

Confidential, Richmond, VA

SQL Developer

Responsibilities:

• Extensive experience of SQL Developer with extensive experience of analytical techniques.
• Experience in writing SQL queries and optimizing the queries in SQL Server 2005.
• Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.
• Performeddata analysisanddata profilingusingSQLon various sources systems including SQL Server 2000.
• Extensive knowledge and experience inproducing tables, reports, graphsand listings using various procedures and handlinglarge databases to performdata manipulations.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects
• Writecomplex SQL queriesfor validating the data against different kinds of reports.
• Worked withExcel Pivottables.
• Performingdata management projects and fulfilling ad-hocrequests according to user specifications by utilizing data management software programs and tools like Excel and SQL.
• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.