SUMMARY:

• ver 8+ years of experience in analysing system requirements, design, development, testing and maintenance of applications. Has 5 years of strong experience in Microsoft SQL Server BI using T - SQL, SSIS, SSAS and SSRS.
• Performing BI application development, data analysis, data modeling, and testing BI solutions for variety of domains using Microsoft SQL Server 2013/20122008 R2/2008/2005
• Performance tuning, reporting, designing logical/physical databases and troubleshooting.
• Implementing ETL architecture and framework design for package configurations, logging, error handling, even handling, monitoring, maintaining, and scheduling (SQL Server Agent) ETL processes
• Creating drill down reports, parameterized reports, linked reports, sub reports, matrix reports and chart reports using SQL Server Reporting Services
• Using SQL Server integration services (SSIS) for Extraction, Transformation and Loading of data from multiple sources into Data warehouse
• Creating SSIS Packages for integrating from various sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional split, Merge and union all
• Creating databases, tables, stored procedures, triggers, views, user defined data types, functions, CTE Indexes using T-SQL
• Optimizing packages using non-blocking transformations, parallel execution, and buffer usage and optimized queries used for SSIS packages
• Designing dynamic SSIS Packages to transfer data from different platforms
• Identifying root cause problems for data integrity and data quality issues through QA or by business report owners
• Using MS Visio for data modeling, data architecture, business and data analysis
• Optimizing performance of queries by collecting statistics using SQL Server profiler, DMVs etc.
• Developing applications
• Working wif internal and external stakeholders to establish teh business needs, provide estimates, and designed and delivered appropriate BI solutions

TECHNICAL SKILLS:

Languages: T-SQL, Teradata SQL, C, JAVA, JSP, HTML SQL, JavaScript.

Operating Systems: Windows (XP NT ) and Unix/Linux.

Databases: MS SQL Server ( 7.0 6.5 ), MS Access, Teradata, Oracle 10g.

Reporting: SSRS, Micro Strategy, Business Objects XI, Crystal Report, Active Reports

ETL/Data Modeling: DTS,SSIS, Informatica Power center8.1

PROFESSIONAL EXPERIENCE:

SQL/BI Developer

Confidential

Responsibilities:

• Worked on teh ETL processes for performing Prior Authorizations and Humana Rewards programs
• Designed ETL jobs for extracting data from heterogeneous source systems, transform and finally load into teh data marts
• Performed source-to-target data mapping; data lineage analysis and created documentation using teh enterprise metadata repository.
• Created DTS and SSIS Packages to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file, and XML in order to create and maintain a centralized data warehouse
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
• Development of packages for Humana Leap rewards.
• Implemented proper logging and error handling in SSIS packages
• Monitor SSIS packages, job setup and maintenance and monitoring of sscheduled jobs.
• Fixing maintenance incidents tickets, problem tickets and Change order tickets.
• Testing of SSIS packages.
• Scheduling SSIS Packages, deploying them on Server.

Environment: MS SQL Server 2012, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), Windows, Microsoft Visio.

SQL/BI Developer

Confidential

Responsibilities:

• Understood teh technical aspects of customer requirements analysis and reviewed technical specification for completeness and recommended appropriate business systems and IT infrastructure
• Participated in development and execution of tactics and strategies to optimize data quality in data warehouse and OLAP environment
• Worked wif teh project manager in examining and reviewing teh existing project templates and made changes to them
• Translated business requirements into working logical and physical data models for Data warehouses, Data marts and OLAP applications
• Created and connected SSAS Cube to Excel and SSRS for Analysis
• Created SSIS Packages to import data daily from OLTP Applications to data warehouse
• Troubleshot system issues, monitored scheduled jobs and set up maintenance plans wif SSIS for proactively monitoring teh performance of SQL Server database
• Implemented Checkpoints, Package Configurations, Logging and Package Deployment using SSIS Packages
• Built efficient SSIS packages for processing fact and dimension tables wif complex transforms and type 1 and type 2 slowly changing dimensions
• Generated Professional Business Reports wif a good look and feel
• Created Partitions in Cubes on time dimension for optimizing teh performance
• Developed reports in teh form of Matrix, Table and Chart using SQL Server 2008 Reporting Services
• Generated weekly, monthly, quarterly and yearly reports as per teh client requirements
• Created reports in SSRS wif different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Wrote Stored Procedures and Functions whenever necessary
• Ensured best practices are applied and integrity of data is maintained throughout security, documentation, and change management

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, IBM AS/400, DB2/400, T-SQL, ODBC

SQL Server Developer

Confidential

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQLServer Integration Services (SSIS) and modified teh package according to teh advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created Query Parameters and Report Parameters to control data returned by teh query and filter data at report level.
• Designed and Developed teh Informatica workflows/sessions to extract, transform and load teh data into Transactional tables.
• Involved in teh migration of existing ETL process to Informatica Power center.
• Created linked, unlinked and on-demand sub Reports.
• Understood teh various complex reporting requirements of company and created web reports using Reporting Services.
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized teh performance of queries wif modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Modified report content and exported reports in multiple formats based on user input.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs
• Scheduled teh reports to run on daily/weekly/monthly basis and email teh results to teh users in teh required format.
• Created User Defined functions for sharing formulas across multiple reports.
• Modified existing reports according to requirements of teh end users.
• Gatheird business requirements from customers and created status reports.

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, SQL PLUS, Import and Export, SQL Profiler.

SQL Server Developer

Confidential

Responsibilities:

• Interacted wif Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of teh system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into teh database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating teh regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), SQL PLUS, MS Access, MS Excel, SSIS.