SUMMARY

• 8+ Years of IT experience in SQL Server Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments.
• Very good knowledge on SSIS Customization by extending MS Business Intelligence Framework.
• Worked in close association with the business team to produceoverallbusiness ambience and other solutions as an ETL Architect.
• Experienced in developing the applications usingT - SQL Programming (DDL, DML and DCL). Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation.
• Extensive experience in MS SQL Server 2008 R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS), Performance Point Server (PPS), VISIO, Control-M and Advance Help Desk.
• Excellent development experience in writing stored procedures and views for SSIS, SSRS in SQL Server
• Hands on experience in developing Dimensions, Measures, Cubes using SSAS.
• Experience in writing MDX queries on cubes to provide business overview to executive team.
• Developed SSIS packages using Analysis Task (SSAS) to deliver reports to executive team by email.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models.
• Very good coordination, team skills, troubleshooting, and issue resolution capabilities.
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as SQL Server, Oracle, Excel and MS Access, CSV, Oracle, flat file.
• Expertise in database transactions using SQL Server, Informix, Oracle, MS Access. Hands on experience in creating triggers, cursors, views and indexes and Experienced in debugging database components.
• 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.
• Experience in stored procedure performance tuning with good understanding of execution plan.
• 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.
• Scheduled Replication process for updating our parallel servers.
• Having idea about Setup of SQL Always-on availability group.
• Applying service packs on SQL Server 2008
• DMV queries to check the information about local server operations and server health.
• Having hands on Experience in Retail domain and Banking domain.
• 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.
• Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views and User Defined Functions.
• 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 2012/2008 R 2/2008/2005/2000
• MS Access
• SQL
• Transact-SQL(T-SQL)
• PL/SQL
• VBScripts
• MS SQL Server Integration Services(SSIS)
• MS SQL Server Analysis Services(SSAS)
• MS SQL Server Reporting Services(SSRS)
• SQL Profiler
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• Visual Studio 2013/2008/2005
• DTS
• SQL Developer
• TFS
• Crystal Reports 11.0
• MS VISUAL STUDIO 2003
• Windows Server-2003/NT/XP/2000
• Windows Vista
• MS DOS
• UNIX
• BCP.

PROFESSIONAL EXPERIENCE

Confidential, IL

SQL BI Developer

Responsibilities:

• Gathered end user requirements, developed applications and different Audit functionalities depending on the requirement acting for both system analyst and an application developer.
• Generating Complex Transact SQL(T- SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQLqueries etc. Programming inSQL Server- Using Stored Procedures, Triggers, User-defined Functions, Views, and Cursors.
• Involved in database design, normalization, de-normalization in building the Data Warehouse and Reporting systems.
• Writing T- SQLqueries (DDL and DML). CreatingSQLScripts for data loads and Upgrades for data migrations and data validations.
• Involved in query tuning by creating Cluster and Non Cluster Indexes on the tables, also used Index Tuning Wizard (ITW) for enhancing the query performance.
• Written complex Stored Procedures using temporary tables.
• Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Derived Column, Lookup, Merge Join, Conditional Split, Slowly Changing Dimension, and Data Conversion etc.) in SSIS packages.
• Used event handlers for error handling includes (On Pre Execute, On Post Execute and On Error)
• Implemented SSIS package configuration files inSQL Server, XML files, Environment Variables and Parent Package Variables.
• Implemented Package logging in both standard (SQL Serverand file based) and custom logging using customer Stored Procedures and tables.
• Involved in development, deployment, scheduling, and troubleshooting SSIS packages
• Involved in troubleshooting Complex SSIS Packages and Production Support tasks.
• Implemented Standard and Custom SSIS Package logging inSQL Servertables and text files
• Used SSIS Package Configurations stored in XML files andSQL ServerTables.
• Involved in installation, reporting services configuration, maintenance, and deployment and troubleshooting SSRS reports in (2005/2008).
• Created complex reports like Table reports, Matrix reports, Cascaded reports, Sub reports, Drill Down, Drill Through, and Chart reports using complex data set queries, Stored Procedures, Views in SSRS 2005/2008.
• Created Ad-hoc reports more often based on end user requirements.
• Generated and formatted reports using Global Variables, Expressions, and Functions.
• Involved in developing parameterized reports using Single Valued, Multi Valued and Cascaded parameters.
• Developed complex Report Models which provides ability to the users to create their own reports using Report Builder and save it in the Report Manager. Also created Linked reports to optimize redundancy of the reports on the report server.
• Involved in Configuring and deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF, S Word (from 2008), and Excel formats using SSRS 2005/2008.

Environment: MSSQL Server2012, SSRS, SSIS, T- SQL,SQL ServerQuery Analyzer,SQL ServerBusiness Intelligence Development Studio, Microsoft Visual Studio 2005, Crystal Reports.

Confidential, Chevy Chase, MD

SQL Server BI Developer

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.
• Publish automated, interactive dashboards to end customers using Tableau.
• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
• Defined best practices for Tableau report development.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Created Database objects like Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers.
• Created required indexes to improve the performance of the queries.
• UsedSQL Server Integration Services (SSIS) to perform bulk insert operations fromSQL Server 2008R2/2008 databases to flat files/CSV files and vice versa.
• Configure the SSIS Package for run time Parameters and configured files as well as developing the Documents for Logging/Error Handling for SSIS Packages.
• Performed job scheduling to ensure execution of certain jobs and daily updates.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
• Created XSLT files for loading the XML data to database.
• Implemented custom error handling in SSIS packages and also worked on different methods of logging.
• Created batch files to load the data from text file to database tables.
• Developed packages to copy tables, schemas and views and to extract data from Excel and from other legacy systems using SSIS.
• Performance tuning of SSIS packages.
• Created technical documents for the process of executing the packages.
• Involved in Project tracking using MS Project.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• IntegrateSQL Server 2005 reporting services with Microsoft Share point PortalServerto the Share Point portal.
• Enhance/modify existing reports by creating new Parameters, Formulas etc.
• CreatedSQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of T- SQLand MDX queries.
• Developed complex SSIS packages to migrate the data from flat files to SSIS.
• Worked on source controls VSS (Visual Source Safe), Borland Star team.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, Tableau Software 8.0, MS PowerPoint, MS Project, MS Access 2003, Oracle, Business Objects, SharePoint, PL/ SQL, C#, VB.Net, ASP.NET, XML, Visual Studio 2008 & 2005, MS Visio 2007, Borland StarTeam, Build Forge, Visual SourceSafe.

Confidential, Irving, TX

ETL Architect / Developer

Responsibilities:

• Coordinating with the end user gathering to ameliorate theoverallindividual architecture expertise.
• Coordinating with the other IT teams to collect design needs and making specialized structured written papers based on the operative needs.
• Upholding a very superior level of specialized skills on all the operative schemes, hardware and software computer systems.
• Assisting the users and writing and producing specialized particularities.
• Aiding the support and supervision ofBI softwareprograms.
• Helping the business abled team members.
• Making the basic ETL architectural rules and regulations.
• Assisting the structural and specialized designs of the schemes to make sure that the judgments are being made in accordance with the existing and forthcoming by Giant Savings">business plans of actions and chances.
• Decreasing the information repetition and division and ruling out unneeded motion of information and enhancing the choice of information.
• Producing firm explanations for joint remark information.
• Making sure that the Meta information is right, legal and reclaimable.
• Recognizing different matters and collecting and writing down the needs and actions of the scheme plans.
• Owning the architectural production actions related to ETL projects.
• Helping the by Giant Savings">enhancement of ETL request teams.
• Transformed data from different data sources like different data bases to SQL Server 2008 R2 using OLE DB connection providers by creating various SSIS packages. Data is transformed to data warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for large business users.
• Migrated the data from the appropriate databases to end database and maintained batch log files.
• By using Deployment utility the deployment manifest file crated to deploy the packages in the production server.
• Package Configuration XML files has created to configure the package with server, database and credential details.

Environment: SQL Server 2008 R2, SQL Server Integration Services 2008 R2

Confidential, Fort Gibson, OK

MSBI Developer

Responsibilities:

• Prepared data mapping document for data migration, for every new customer enrolled.
• Developed staging tables and related objects to move new customer business data, prior to migration.
• Carried out migration, for around 20 customer’s data over a period of one year with tight deadlines. Each customer data has a volume over a million.
• Developed TSQL stored procedures and functions for customer feedback process, which kicks on overnight by SSIS packages.
• Involved in performance tuning of existing TSQL stored procedures by analyzing applicable indexes and filters used in queries.
• Developed SSIS packages with multi-threading related to Customer Data Migration and Overnight batch processes, related to reminder service, notification management.
• Developed Service Utilization SSAS Cube from Vendor, Product, Area, Service dimensions and Number of hours, Service Charge measures. This cube is used for Executive team for reporting vendor utilization data.
• Developed SSIS package using Analysis Task, generated EXCEL sheets from “Service Utilization” SSAS Cube and sent as an email to each Area manager.
• Developed SSRS Drill-down, and Pivot Reports, which are meant to subscribe by customer.
• Developed SSRS Subscription model for each report so that, ASP.Net application will subscribe in runtime.
• Implemented Exception Handling and used existing Logging sources in all SSIS packages to cover all exceptional scenarios. These 2 helped us in troubleshooting issues in production.
• Prepare SSIS package deployment ready for production release, including release notes.

Environment: SSIS 2012, SSDT 2012, C# .Net, SQL Server 2012, TSQL, MS Excel 2007, Informix database

Confidential

SQL Server BI Developer

Responsibilities:

• Involve in complete SDLC requirement specifications, analysis, design, development and testing the user stories.
• Designed conceptual logical and physical model using Erwin.
• Created complex T-SQLQueries, Stored Procedures, Indexes, Functions and Views to support efficient data storage and manipulation.
• Created appropriate Triggers to assist efficient data manipulation and data consistency.
• Created traces using SQL Serverprofiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS).
• Loading data from various sources like OLEDB, flat files toSQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Worked on various tasks and transformations like ExecuteSQLTask, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Created and scheduled jobs for Drip Campaign, feedback from patients and for waiting list of patients usingSQLmail task to send the alerts.
• Created Script task packages using C#/VB.net to display a script.
• Created a custom error handling process for SSIS packages and also created a process to monitor scheduled jobs on a periodic basis.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Provided test data scenario for data quality and maintenance.
• Created statistical reports, internal reports, and parameterized reports as per the requirement.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Involved in some DBA activities like Performance Tuning, Backup the data, recovery models and Disaster recovery scenarios.
• Ensure proper source control (Git), documentation (Confluence), testing and quality assurance processes are established, implemented, and followed to maintain high data integrity.
• Investigate issues/bugs in reporting processes and output, identify root causes, and implement robust fixes.
• Attended the daily scrum meetings to update the status.

Environment: Microsoft SQL Server 2012/2008R2 Enterprise edition, SISS, SSRS, BIDS, Erwin, Visual Studio 2012, ASP.Net 4.5, MS SharePoint 2010/2013, Windows PowerShell C#, GIT HUB

Confidential

SQL Server Developer/DBA

Responsibilities:

• Actively participated in gathering the required information for the project.
• Involved in different stages of Project Life Cycle.
• Modified current database by adding tables, indexes and constraints.
• Created stored procedures for implementing the business logic.
• Responsible for Performance Tuning / Optimization.
• Worked with complex T-SQL queries
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Proposed triggers on events to insert, update and captured the data
• Defined constraints, rules and defaults to ensure data integrity and relational integrity.
• Scheduled jobs by DTS, and created alerts for Error reporting.

Environment: SQL Server 2005, T-SQL, SQL Server 2005 Reporting Service, VSS, Windows 2003 Server, Enterprise Manager, Query Analyzer, SQL Profiler.