PROFESSIONAL SUMMARY:

• 7+ years of extensive experience and hands on working knowledge in various domains of IT industry like financial, office supplies and insurance as SQL/MSBI Programmer.
• Hands on experience in T - SQL Server 2012/2008R2/2008/2005 wif Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Excellent understanding of T-SQL (DDL and DML), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server (2012,2008R2, 2008, 2005).
• Experienced in Extract, Transform and Load (ETL) process using MS-SSIS, DTS application tools.
• Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Expert knowledge in SQL Server Package Configuration techniques to Dynamically configure SSIS packages.
• Experience in creating custom specific and efficient SQL server Reports using SSRS 2012/2008R2/2005.
• Expert in defining Query for generating drill down reports in SSRS 2008R2/2005.
• Experienced in using global variables, expressions and functions for teh reports.
• Proficient in handling parameterized reports in SSRS 2012/ 2008R2/2005.
• Experienced in sorting teh data, defining data source and subtotals for teh reports.
• Hands on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server (2005/2008R2/2012).
• Good Working experience in designing STAR, SNOW FLAKE Schemas, physical database design using Erwin.
• Extensive experience on Optimization and Tuning for increasing Query and Database performance.
• Highly analytical and solid programming skills besides competent in handling critical situations.
• Ability to work independently and in a team, capable of handling time-sensitive issues in distributed environments.
• Experience in documentation, providing training to fresh recruits and also participated actively in review meetings.
• Actively participated in team building and involved in many operations for maintaining healthy work environment.
• Excellent Communication and interpersonal skills.

TECHNICAL SKILLS:

Languages: SQL, T- SQL, HTML, XML, C, C++, C#.NET

Databases: SQL Server 2012/2008R2/2005, MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data

Web technologies: .Net, ASP.Net, Ado.NetTesting: Unit Testing

Other Software: MS Office- 2013/2007/2003

Operating Systems: Windows 2000/2003/XP/7

Database Tools: SQL Query Analyzer, Management Studio, SQL Server 2005/2008R2/2012, Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSONAL EXPERIENCE

Confidential, Bellevue, WA

Data Analyst/ETL developer

Responsibilities:

• Worked wif T-SQL to create Tables, Views, and stored Procedures using SQL Server 2014.
• Optimized teh database objects by building indexes and using SQL Server Profile to identify and fix long running queries. Improved performance by 8%.
• Worked wif huge amounts of data. Responsible for cleansing, maintaining and finding issues and fixing accordingly. Built systemic checks (SQL Procedures) to constantly identify and manage data inconsistencies.
• Created and implemented many stored procedures to improve teh performance and run most of teh scripts dynamically.
• Optimizing teh data base design to enhance performance and efficiency associated wif data retrieval and manipulation.
• Implemented new rules and regulations which include stored procedures, views, tables creation and modifying tables in different environments and did trouble shoot them as needed.
• Also was responsible for rectifying issues and also implemented new scripts to optimize and minimize teh scripts running time.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created C# codes for teh customization of teh SSIS packages for handling teh file names dynamically and to handle teh xml format files.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Created some intranet sites to be able to access reports, meetings and other project updates for internal customers using SharePoint.
• Extract Transform Load (ETL) development using SAP Business Objects Data Services Business Objects Data Integrator (BODI).
• Worked on processing XML files.
• Created XML files from SQL database. Parsed XML files and manipulated teh data.
• Created reports using Confidential SQL Server Reporting Service (SSRS) as per teh client request.

ENVIRONMENT: SQL Server 2014/2012, SDT 2012, Business Intelligence Development Studio, T-SQL, SSIS, SSRS, Windows 8.1,BODI,Visual Studio 2012, MS Office 2013.

Confidential, Bellevue, WA

SSRS developer and Configuration Analyst

Responsibilities:

• Developed Complex reports to identify logistics cost impact, Fraud etc.
• Launching new partners/service centres which involved in testing all systems and process flows.
• Designed, developed and maintained Databases.
• Leveraged T-SQL, SSIS, SSAS, SSRS, Tableau and Excel to create reports wif which identified several areas for improvement such as high turnaround time and fraud and implement changes to improve business.

Environment: SQL Server 2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (T-SQL, SSIS, SSRS), Confidential Office Share Point Server

Confidential, Bellevue, WA

SQL & BI (SSIS, SSRS) DEVELOPER

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding teh functional work flow of information from source systems to destination systems.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing teh packages in both teh environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured teh loading of data into Slowly Changing Dimensions using Slowly Changing Dimension wizard. Also implemented checksum SCD method to load teh data into date warehouse.
• Involved in Dimensional modeling by identifying teh fact and dimension tables based on teh user & reporting requirements.
• Developed complex SSAS cubes wif multiple fact measures and multiple dimension hierarchies based on teh OLAP reporting needs.
• Improved teh performance of teh cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing teh attribute hierarchy options in SSAS.
• Experience in developing reports using SSRS.
• Advanced extensible reporting skills using SQL Server 2008R2 Reporting Services (SSRS).
• Developed a High level dashboard using SSRS 2008R2
• Experienced in Designing stylish report layout.
• Designed and created Report templates, bar graphs and pie charts based on teh financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for teh reports using SSRS 2008R2
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-hoc reports as per teh client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated wif front-end for implementing logic in Stored Procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement teh business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2000 to SQL Server 2008R2.
• Advised optimization of queries by looking at Execution Plan for better tuning of teh database.

Environment: SQL Server 2005/2008R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Confidential Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2008R2.

Confidential, Sunrise, FL

SQL BI Developer (SSIS & SSRS)

Responsibilities:

• Participated in sprint meetings to discuss on teh present tasks assigned and any hurdles related to tasks.
• Interacted wif business analysts and users to discuss teh requirements for development
• Developed functional and technical specification document to assist in teh design, development and/or maintenance of deliverables
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions to migrate data from staging to production environment
• Modified existing stored procedures, functions using joins following SQL Standards to enhance teh performance of teh reports.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow task etc. to import teh data into data ware house
• Developed SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
• Deployed packages to pre-production environment and created SQL Agent jobs to run those packages
• Implemented Logging and Error handling in SSIS packages
• Analyzed execution plan and optimized some complex queries by creating indexes and using some SQL best practices
• Created Parameterized, Cascaded parameter Reports using SSRS
• Created dashboard SSRS reports under report server projects and published SSRS reports to teh reports server.
• Experienced in scheduling, creating snapshots and subscriptions for teh reports using SSRS 2008
• Developed, scheduled and generated various reports like List, Matrix, Drill-Down, Chart and Sub report and standardize company report by implementing SQL Server Reporting Services (SSRS)
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Created SSRS Data Model projects using Confidential Visual Studio 2008 R2 and using Report Builder for report server to facilitate Ad-hoc reporting by teh business users

Environment: SQL Server 2008 R2/2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), .Net framework and TFS 2010

Confidential, Chicago, IL

DTS/SSIS/SSRS DEVELOPER

Responsibilities:

• Responsible for transformation and loading into teh target SQL Server databases using ETL tools, DTS 2000 and SSIS 2005.
• Created SSIS packages wif which data resources such as Flat files, Excel files, were loaded daily in order to create and maintain a centralized data warehouse.
• Made teh package dynamic so it fits teh environment.
• Scaled SSIS to make it work more reliable.
• Expertise experience wif administering and debugging DTS and SSIS.
• Created scheduled jobs to execute DTS and SSIS packages.
• Transferred/Rewrote DTS packages to SSIS Packages. Hands on working experience wif configuring every aspects of SSIS 2005.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Coordinated other Reporting Analysts in analyzing data and creating management reports.
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Developed reports wifout formal specifications often.
• Created and developed teh stored procedures, triggers, views, and user-defined functions to support application development.
• Worked closely wif IT project managers, programmers, and testers.

Environment: T-SQL Server 2000/2005 Enterprise, Confidential Reporting Service, SQL server BI development studio, Confidential Visual Studio 2005

Confidential, Rancho Cordova, CA

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Writing stored procedures, triggers, cursors, and views to improve teh quality of application, and manage mission-critical information using T-SQL.
• Designed and developed DTS packages for transferring data from flat files and Access files.
• Involved in identifying facts, dimensions and various other concepts of dimensional modeling, which are used for data warehousing projects.
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation.
• Performed Performance tuning and optimization of SQL queries using SQL profiler and query analyzer.
• Using Integration Services (SSIS), built high performance Data Integration Solutions, including extraction, transformation and loading (ETL) packages for data warehousing.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Used Oracle as a source to extract data and load into SQL Server for further use.
• Develop and support reports built wif Confidential SQL Server Reporting Services 2005 (SSRS).
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Ensure that periodic (daily, weekly and monthly) reports are delivered in a timely and accurate fashion using Reporting services SSRS.
• Used oracle as teh source for creating some of teh reports as per client request.
• Optimized performance and capacity planning of various data transformation processes related to teh reports.
• Used SVN as a version control system to maintain release schedules.
• Generated test data and tested database to meet teh functionalities deliverables in teh project documentation and specifications.
• Maintain and monitor teh data warehouse to ensure its proper operation, performance and availability.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Involved in end-to-end documentation of all teh processes including aggregation, metrics and all teh relevant customizations made in teh system.
• Developed application logic wif C# .Net.
• Worked on some PL/SQL (Oracle) programming as per teh client requirement.

Environment: SQL Server 2005/2008, Excel (pivot tables) SSIS, SSRS, T-SQL, SVN, C#, Visual basic, Visual studio2005, Windows 2000/XP

Confidential

T-SQL Developer

Responsibilities:

• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Generated T-SQL scripts for application development.
• Created Stored Procedures and User Defined functions.
• Created Indexes to speed up teh queries.
• Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedure.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of database servers.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Environment: SQL Server 2005, SQL Server Query Analyzer, DTS, T-SQL, Windows 2003/XP