SUMMARY

• Over 7+ years of strong experience in the IT industry as a MS SQL Server 2012/ 2008R2/ 2008/ 2005 Developer/BI Developer.
• Expert knowledge of all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2012.
• Skillful in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Expert in developing and modifying multi-dimensional cubes using MS SQL Server Analysis Services (SSAS).
• Hands on experience in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS.
• Strong in developing and modifying cubes using SSAS and transform into pivot table.
• Hands on experience in writing MDX queries to work with cube data.
• Experienced 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.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2008 R 2/2008/2005/2000.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005, SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Quick learner, excellent communication skills and good performer both in team and independent job environments.
• Understanding knowledge about Equities, bonds, swaps, CDS.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R 2/2008/2005/2000/7.0
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Reporting Services (SSRS)
• Informatica
• Business Intelligence Development Studio (BIDS)
• BCP
• SQL Profiler
• Enterprise manager
• Management studio
• Microsoft Access 2000
• ERWIN 4.0/4.1/4.2/7.2
• Microsoft Visio 10.0/11.0
• T-SQL
• ASP.NET
• C#
• VB.Net
• HTML
• XML
• XSL
• Oracle 9i/10g
• Crystal Reports 8.5/9/10/11
• Visual source safe 2005
• MS office 2007/2003
• DMEXpress
• Windows 2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE

Confidential, IL

Sr SQL Server BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Create joins and sub-queries for complex queries involving multiple tables.
• Generated dynamic stored procedures, triggers for the database development.
• Involved in installation and configuration of SQL Server 2005, SQL Server 2008 R2 and SQL Server 2012 with latest Service Packs.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008 R2/2012.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Created SQL server Reports using SSRS.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system and CSV Files and load into staging tables.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.
• Report writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS).
• Used SSIS, DMExpress to import data from two different sources (Teradata, Oracle) to a single destination like SQL Server 2008. Used various SSIS transformations like Derived column, Lookups, Conditional split to cleanse the data and used stored procedures for effective data transfer.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012 as SSIS Packages.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008/2012.
• Using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Involved in package migration from DTS to SSIS, running upgrade advisor tool against DTS packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Configure the report server and generated the report models for user interactions.
• Experience in creating SSIS packages using different type’s task and with Error Handling.
• Designing OLAP cubes, Data Modeling, Dashboard Reports according to the business requirement.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed the frontend application using VB6.
• Implementing Road Map, Defining and building best Practices for C#.NET Application Development.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Performance tuning and optimization of procedures and queries.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Worked on OLAP Data warehouse, Model, Design, and Implementation &power BI.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008.

Confidential, Tulsa OK

MS SQL Server Developer/BI Developer

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Very good 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."
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, CTE, user profiles, relational database models and data integrity, SQL joins and query writing.
• Used Visual Intercept Manager, the premiere bug tracking system for the Microsoft development environment, which is project oriented, scalable and optimized.
• 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.
• Using ETL pulled data from various sources like Oracle, DB2, Access, XML etc.
• 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.
• Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS 2005/2008/2012.
• Expert in 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.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008R2 Reporting Services (SSRS).
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using MS SQL Server Integration Services (SSIS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, 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.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoringtools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Confidential, Richardson, TX

SQL Server BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Developed logical and physical data models for schemas using Erwin.
• Installed MS SQL Server 2008 and Management tools using SQL Server Setup Program.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
• Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data.
• Converted existing Excel templates into SSRS reports to migrate the reporting model to SQL Server Reporting Services.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Performed daily tasks including backup and restore by using MS SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Supported production operation activities, with focus on integration and development of new and existing products and services.

Confidential

MS SQL BI Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL.
• Designed an OLAP with the help of ERWIN to visualize data structure.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Improved query performance and reduced down by cube partitioning.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS.
• Generated reports using SSRS as per business requirements.
• Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures.
• Involved in package migration from DTS packages to SSIS packages, running the Microsoft upgrade advisor tool
• Implemented the calculations to aggregate physical measures using management studio.
• Identified and defined the scoped assignments using script commands.
• Defined Referenced relationships with the measure groups and fact tables.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Established a sound backup and recovery policies and procedures.

Confidential

SQL BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Installed and configured MS SQL Server 2005/2008 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Created OLAP cubes and dimensions for the analysis of student’s registrations in specific areas using SSAS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2005 with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Established backup and recovery of MS SQL server by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Used Visual Source Safe (VSS) for version control.