PROFESSIONAL SUMMARY

7 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment. Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.

• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• Expert Knowledge of T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS). Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

• Worked Extensively on ETL process using SSIS package.
• Experience in enhancing and deploying the SSISPackages from development server to production server.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Sub reports, and formatting them.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Used MDX to interact with the back end OLAP Services.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in Creation and deployment of cubes on SSAS.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins, storedprocedures.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Involved in DBA activities such as backups and restores.

Working as SQL BI Developer(T-SQL, SSIS, SSRS) and Support Engineer at Confidential,(Atlanta, GA) from Nov 2011 to till date.
Worked as SQL Developer/ Data Analyst at Confidential,(Irving, TX) from April 2011 to Oct 2011.
Worked as SQL BI Developer( T-SQL, SSIS, SSRS, SSAS) at Confidential,(Mesa, AZ) from April 2010 to April 2011.
Worked as SQL BI Developer(T-SQL, SSIS, SSRS, SSAS) at Confidential, (Lakewood, CO) from March 2009 to April 2010.
Worked as SQL BI Developer(T-SQL, SSIS, SSRS) at Confidential,(Irving, TX) from February 2008 to February 2009.
Worked as SQL BI Developer(T-SQL, SSIS, SSRS) at Confidential,(Fort Worth, TX) from March 2006 - January 2008.
Worked as SQL Developer at Confidential,(Hyderabad, India) from October 2005 - January 2006.

• B.E in Electricals And Electronics

• Microsoft Certified in SQL Server 2008, Business Intelligence Development and Maintenance (MCTS 70-448).

Languages: C, SQL, T-SQL,PL/SQL
SQL Server Tools & Packages: SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Toad, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, Crystal Reports, ETL
Databases: SQL Server 2000/2005/2008, MS Access 97/2003/2005/2008, Oracle10g/9i
Operating Systems: Windows Server 2000/2003/2008, Windows Vista/XP/2003/2000 UNIX, Linux, DOS
BI Tools: SSRS, SSIS, SSAS, Erwin Data modeler
ETL Tools: DTS, SSIS, Informatica 7.1.3/6.2
Web Technologies: HTML, DHTML, XML, Visual Studio, MS Front page

CLIENT: Confidential, Atlanta, GA
ROLE: Sr. SQL BI Developer(SSIS, SSRS)/Support Engineeer
DURATION: Nov\'11 - Till Date

DESCRIPTION: Confidential, is an international provider of mobile solutions for fields, sales, marketing, merchandising and DD operations in the consumer products market. Its mission is to deliver innovative mobile software solutions that support our customer's leadership in the field ensuring that they win at the shelf by having right product, in the right place, with the right price or the right promotion at the right time.
The S & M application has a front office application and a back office management Suite. This base product can be customized to meet customer business requirements.
Client application - Designed for use by sales force team in the field. Information captured at the store using a PDA is sent back to the centralized control set up for review and action.
Management suite - Designed for in-office personnelat the control set up. Information received from the field force enables them to plan, and manage stocks, trade promotion compliance, ranging & monitor share of shelf and competitive activity. It can be interfaced with enterprise applications to ensure seamless data delivery across the enterprise.
To support, maintain the sales and merchandising Application (encompassing a client application and management suite application). Analysis and implementation of Change requests to meet business needs.

RESPONSIBILITIES:

• Troubleshoot and diagnose customer issues, documenting recreation steps.
• Trouble shooting issues related to SQL, SSIS and SSRS.
• Managing customer issues in On Time, customer issue status communications.
• Designed and developed various reports such as Tabular, Matrix, Drilldown, Drill Through, and Parameterized Reports using SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Designed and developed monthly, quarterly and yearly reports at branch and company level.
• Created SSIS Package for uploads and schedule them as SQL Server Agent. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Handled Initial and Delta loads and also used Error Handling, Logging and Checkpoints and made use of Configuration files.
• Used SSIS transformations for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data, and Garbage and Unnecessary Data like removing empty rows.
• Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.
• Created/Updated Stored Procedures and User defined Functions with extensive use of T-SQL.
• Responsible for creating database objects (table, views, store procedure, triggers etc) to provide structure to store data and to maintain database efficiently.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Responsible for creating the tables, views, stored procedures.

ENVIRONMENT:MS SQL Server 2008, MS SQL Server Integration Services 2008(SSIS), MS SQL Server Reporting Services 2008(SSRS),SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio(BIDS), T-SQL, Management Suite( Proprietary tool),Workbench( proprietary tool), SQL CE.

CLIENT: Confidential, Irving, TX
ROLE: SQL BI Developer/ Data Analyst
DURATION: Apr'11 - Oct'11

DESCRIPTION: Confidential, engages in originating and servicing residential mortgage loans. It offers mortgage, home equity, and manufactured housing loans. The project deals with maintaining mortgage retention and preservation master table. Master table holds information about existing Mortgage loans which are processed under various Loan modification programs like HAMP, CHAMP etc... Worked on analyzing existing Loan Fulfillment process and fixing Vintage issues with master table.

RESPONSIBILITIES:

• Worked with business users to understand and analyze business requirements.
• Translated business requirements into system requirements and functional design specifications.
• Created source to target documents as per technical requirements.
• Performed source-system analysis, transformation analysis and associated documentation.
• Created technical and functional requirements documents for ETL developers.
• Extensively used oracle analytical functions to perform impact analysis and data validation.
• Involved in using informatica transformations for loading data from source to destination.
• Analyzed business process workflows and developed code for movingdatafrom source to target systems.
• Verified accuracy of data and support of the data warehouse.
• Involved in development and enhancement of the existing processes and methods to meet both internal and external analysis requirements.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Extensively used Teradata SQL Assist in constructing User Functions, Views and Indexes.
• Extensively used stored procedures and SQL joins in construction of dimension Tables using Teradata SQL Assist.
• Experience with UAT testing.
• Evaluated the data collected through task analysis, business process analysis, and data analysis.
• Resolved data conflicts and inappropriate use of data.
• Collecting and analyzing a project's business requirements and transferring the same knowledge to development teams.

ENVIRONMENT: Toad, Oracle 10g/11g, IBM AIX 5.3, PL/SQL, Informatica Power Center 8.6/8.5.1, Cognos, TeraData, SQL Server.

CLIENT: Confidential, Mesa, AZ
ROLE: Sr. SQL BI Developer(SSIS,SSRS,SSAS)
DURATION: Apr'10 - Apr'11

DESCRIPTION: Confidential, is a service company which does financial work and measures things like Customer Retention, Sales and handling commissions etc... The project is to translate Fox Pro reports to SQL Server Reports and Packages. Business needs for this application is to develop a new database on SQL Server 2008 and integrate with existing systems.

RESPONSIBILITIES:

• Worked with business stakeholders, application developers, production teams across functional units to identify business needs and discuss solution options.
• Analyzed requirements and followed standards and extend existing code as per the requirement.
• Created SSIS Package for uploads and schedule them as SQL Server Agent. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Handled Initial and Delta loads and also used Error Handling, Logging and Checkpoints and made use of Configuration files.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Coordinated integration of Data cleansing scripts with ETL and scheduling tools.
• Developed and Unit Tested various kinds of reports such as Charts, Drilldown, Drill Through, Crosstab, Sub-Reports, Linked Reports, Cascaded Parameter reports with stylish report layouts.
• Involved in design and deployment of Report Models for generating Ad-Hoc reports as per the client requirements.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Converted crystal reports to SQL Server reports using SSRS 2008.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Defined Schemas (Star and Snowflake) i.e. relationships between Measure groups and Dimensions in SSAS.
• Created SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube
• Identified Key Performance Indicators (KPI) for Business needs in SSAS 2008.
• Partitioned Cubes for optimizing the performance of Query and reduce down time.
• Created reports to retrieve data usingStored Proceduresthat accept parameters.
• Created Report Snapshots and Report caching to show the data changes over time..
• Involved in writing T-SQL stored procedures and user-defined functions and perform daily account screening. Implemented database maintenance procedures: hourly/daily/weekly backup schedule.
• Performed daily tasks including backup and restore by using MSSQL Server2008 tools like MSSQL ServerManagement Studio, MSSQL ServerAgent, and Database Engine Tuning Advisor.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Used Execution Plan and SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.

ENVIRONMENT: MS SQL Server 2008R2, MS Excel, Business Intelligence Development Studio 2008, SQL Profiler, SSIS,SSRS,T-SQL, Windows Server 2003/2008, Crystal Reports.

CLIENT: Confidential, Lakewood, CO
ROLE: Sr. SQL BI Developer(SSIS,SSRS,SSAS)
DURATION: Mar'09 - Apr'10

DESCRIPTION: Consumer Bank Credit Union (CBCU) provides Score Cards to Issuers by comparing the Transaction Volume, Sales Volume, Penetration, VCC Account Growth, Authorization Approval Percent, Decline Percent and Reported Fraud Loss rate values between Issuers, Visa system, and Peer groups.

RESPONSIBILITIES:

• Created SSIS packages to retrieve data from Legacy sources, retrieve PII user data from the Flat files on monthly and weekly basis, File Transfer from one location to the other using FTP task.
• Used SSIS transformations for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data, and Garbage and Unnecessary Data like removing empty rows.
• Worked on building the mockup reports using SSRS and Excel for prototype.
• Create reports in SQL server using SSRS as per the requirements provided by the Front End users.
• Managed the process for SSIS packages using Team Foundation Server.
• Used MS Excel for exporting the reports (Pivot Reports) so that they can be slice and dice as per the requirement by the client.
• Assisted in developing OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting Services (SSRS).
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Set up Partitioned Tables and Indexes for Parallel Processing of queries using SQL Server 2008 Partition functions and schemes.
• Writing the stored procedures, checking the code for efficiency using T-SQL.
• Create joins and sub-queries for complex queries involving multiple tables.
• Created and managed database objects such as tables, views, indexes, stored procedures and Triggers.
• Testing the Stored Procedures performance and its path of execution by using SQL Profile.
• Perform DBCC checks to ensure the physical consistency of the database and objects.

ENVIRONMENT: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, Microsoft clustering Services, Visual Source Safe 8.0.

CLIENT: Confidential, Irving, TX
ROLE: Sr. SQL BI Developer(SSIS,SSRS)
DURATION: Feb'08 - Feb'09

DESCRIPTION: Confidential, is a boutique financial advisory firm, founded in 2002 by Kim Snider. It specializes in financial education for investors, particularly as they prepare for retirement.
Snider Advisors offers a series of live courses, web-based training and extensive support to its clients based on their trading activity. Trading data is sourced into ODS system from the Snider Trading Application. Data is staged, transformed and loaded into Snider Warehouse for user activity analysis.

RESPONSIBILITIES:

• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data ware house using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using SQL Server Integration Services.
• Worked with different Loop Containers and Tasks in Control flow and also worked with different components of Data flow tab.
• Developed packages to handle slowly changing dimensions, data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop).
• Created jobs, alerts using SQL Server Agent to run SSIS packages periodically.
• Generated reports using Expressions, Global variables and Functions.
• Administrating and Scheduling Mailing Subscriptions on SSRS Reporting server.
• Designed and developed monthly, quarterly and yearly reports at branch and company level.
• Implemented Constraints on tables for maintaining Data Integrity and Entity integrity.
• Performed daily tasks including backup and restore by using MSSQL Server2008 tools like MSSQL ServerManagement Studio, MSSQL ServerAgent, and Database Engine Tuning Advisor.

ENVIRONMENT: MS SQL Server 2005/2008, MS Reporting Services 2005/2008, SQL SSIS 2005/2008, SSAS 2005/2008, T-SQL, Windows XP Professional, MS Excel 2003, Visual Source Safe 8.0., Perforce v4,
C#, .net

CLIENT: Confidential, Fort Worth, TX
ROLE: SQL BI Developer(SSIS,SSRS)
DURATION: Feb'06 - Jan'08

DESCRIPTION: The project is to develop and maintain a database for SNAP (Special Needs Assistance Program) supporting the client application .Office of Emergency management maintains the vital information of individuals with permanent disabilities and residents with special needs to ensure that assistance is available when disasters strike. Business needs for this application is to develop a new database on SQL Server 2008 and integrate with existing systems.

RESPONSIBILITIES:

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created mappings using the Transformations such as the conditional split, Join,Filter, mapping, character map, derived column etc.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Worked with different methods of logging in SSIS.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
• Involved in creating report models and applying row level security filters for report model.
• ScheduledReports to run thereports Hourly, Daily, and Monthly accordingto client requirements for the periodic analysis.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated the update of the database statistics.
• Implemented Database mail and Triggers as per business needs.
• Involved in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent. Used Performance Monitor/Profiler to solve Dead Locks.

ENVIRONMENT: MS SQL Server 2005 Enterprise Edition, MS Analysis Services 2005, Analysis Services 2000, MS Access, SSIS, Erwin 4.1, Windows XP Professional.

CLIENT: Confidential, Hyderabad, India
ROLE: SQL Developer
DURATION: Oct'05 - Jan'06

RESPONSIBILITIES:

• Responsible for database design using Erwin Tool.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers & maintained Referential Integrity. Wrote complex queries using joins.
• Created and monitored Database maintenance plans for checking database integrity.
• Tested Backup and Recovery Strategies.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Maintained SQL scripts for creating Database objects.
• Used DTS to import and export objects between databases.
• Coded SQL to perform database tasks by using Inner/Outer Joins and group by/having clause.
• Involved in entire life cycle including database design, development, testing, optimizing and deploying on development and production servers.
• Responsible for creating the Tables, Views, Stored Procedures, Triggers.
• Used Data transformation Services (DTS) to export and import data.

ENVIRONMENT: SQL Server 2000 Enterprise Edition, DTS Designer, SQL Server Enterprise Manager, Windows 2000/NT, MS Office