PROFESSIONAL SUMMARY:

• Around 7 years of IT experience in Analysis, Design, Development, Implementation, troubleshooting and Support of MS SQL Server 2012/ 2008/ 2005/ 2000 in OLTP, OLAP Environments as a Developer.
• Upgrade/Migration of MS SQL Server 2000 to MS SQL Server 2005 and from 2005 to 2008.
• Involved in all the phases of software development life cycle (SDLC) process.
• Experience in Database Normalization, Designing, Creating Indexes, Developed Queries and T - SQL Scripts in MS SQL 2012/2008/2005/2000.
• Experience in Creating Tables, Views, ComplexStored Procedures, User Defined Functions(UDF’s), Triggers to facilitate efficient data manipulation, data integrity and other T-SQL (DDL, DML) statements for various applications.
• Experience in optimizing the query by creating various Clustered, Non-clustered indexes and Indexed views.
• Experience in SQL Server DTS and SSISpackage design, construction and deploymentfrom heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations.
• Experience in using Performance point server 2010 and Share point server 2010.
• Experience in using C# and VB.Net scripts for the Script task and Script component in SSIS.
• Knowledge on Eclipse Business Intelligence Reporting tool for developing (BIRT) dynamic reports.
• Experience in Data Migration using tools like BULK INSERT, BCP and Replicationbetween different homogeneous/heterogeneous systems and SQL Server.
• Extensive experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Enterprise Manager.
• Experience in creating Sub Reports, Tabular Reports, Matrix Reports, Parameterized Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS) and web reporting by customizing URL Access.
• Proficient skills inDrill down and Drill through reports, sorting the data, defining subtotals in SSRS 2008/SSRS 2005.
• Developed Crystal reports.
• Connectivity and Database Consistency Checks using DBCC Utilities.
• Data Modeling Experience in creating Logical, Physical data models using tools like ERWIN and Visio.
• Excellent analytical, interpersonal and communication skills & desire to excel, fast learner, hardworking and versatile team player.

TECHNICAL SKILLS:

SQL Server Tools: SSIS (2008/2005), SSRS (2008/2005), SSAS, DTS.

RDBMS: SQL Server.

Data Modeling: ERWIN 4.0, Visio 2003.

Languages: T-SQL, SQL, PL/SQL, HTML, XML, VB.Net, ADO.NET./PIG/HIVE

I.D.E: Visual Studio 2008/2005.

Version Control: Visual Source Safe.

Operating Systems: WindowsNT 4.0/, Windows 98/2000 /2003 Server/XP/Vista, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential Michigan

Database Developer

RESPONSIBILITIES:

• Involved in business analysis and technical design sessions wif business and technical staff to develop dimensional models, requirements document, and ETL specifications.
• Created database objects like Procedures, Functions, Triggers, Indexes and Views.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
• Worked wif various SSIS control flow tasks and data transformations like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split, Aggregate transformations etc. as part of ETL. Worked wif Change Data Capture Task.
• Worked extensively wif SSIS to import, export and transform the data from oracle, xml and text files.
• Using SQL Profiler to estimate the slow running queries and Database Tuning Advisor for performance tuning purpose.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS Packages.
• Expertise inDeployingSSISPackage to Production and used different types of Package configurations to export various package properties to make package environment independent.
• Created checkpoints, Break Points and configuration files in SSIS packages.
• Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems.
• Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.
• Published reports in PDF, Excel, CSV formats in the Report Server and also saved them to TFS for storing versions and also published them in SharePoint.
• Created subscriptions to provide a daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Wrote complex SQL Queries using multiple joins for creating Adhoc reports using Report builder based on the requirements.
• Provide 24*7 supports to SQL application developers in implementing the applications on production server.

ENVIRONMENT:MS SQL Server 2008 R2 SSIS, SSRS, SSAS, Visual Studio 2008, T- SQL,Crystal Reports, Performance point server 2010, Share point server 2010, Windows 2008 Server, Team Foundation Server, XMLA, MS-Access, MS-Excel, Cognos reports, Business Objects.

Confidential, Houston TX

BI Developer /DBA

RESPONSIBILITIES:

• Actively participated in gathering Business requirements to implement functional and technical specifications.
• Designed and developed full-scale reporting solution for a multi-client environment using MS SQL Server 2008 and MS SSRS 2008, 2005.
• Created, implemented and maintained reporting suite of over 36 standard reports while also customizing many reports to meet individual client needs.
• Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created dashboards using benchmarked data to provide an analytical snapshot of point in time data.
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Deployed and Generated SSRS reports using the Reporting Services Report Manager and Microsoft SharePoint 2010.
• Deployed and maintained reports in SharePoint 2010 and played critical role in providing the support to the business users.
• Provided MS SSRS 2008 training to clients in order for them to develop their own ad-hoc reports.
• Converted Cognos Reports to SSRS Reports based on users requirements.
• Converted MS SSRS 2005 and Excel based reports to MS SSRS 2008 based reports.
• Worked wif various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Created custom C# and VB Scripts to loop through set of files and extract the data based on the column information.
• Developed the packages wif monitoring features and logging so dat audit information of the packages and their execution results are loaded in to the audit table.
• Played critical role in developing ETLs for loading dimension tables using Kimball methodology, creating SSRS reports, batch commands for scheduling.
• Provided back-end support for functional tuning and performance testing.
• Worked on data warehouse Analysis services and developed different reports for analysis.
• Involved in creating Tabular Cubes using SQL Analysis Services (SSAS).
• Used Tabular cubes since their are important calculations based on distinct count measures and complex calculations based on many-to-many relationships.
• Created cubes wif full processing and partial processing capabilities.
• Created SSIS packages for custom processing of Partitions in SSAS cube.
• Created and maintained users, roles and groups and handled cube security efficiently.
• Trained End users to browse cube data using Microsoft Excel 2013/2010 and PowerPivot.

Environment: MS SQL Server 2012/2008R2/2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel 2013/2010, Power Pivot, Windows XP, Cognos, Star Team

Confidential, St Louis, Missouri

BI Developer

RESPONSIBILITIES:

• Interact wif Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required.
• Created ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Experienced in slowly changing dimension in SSIS packages.
• Performed incremental data load packages in SSIS.
• Upgraded more TEMPthan 40 packages from 2000 to 2008 and 2005 to 2008 SQL Server.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases wif DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from dat servers.
• Identified and Defined Fact relationships in SSAS.
• Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.
• Designed and deployed cubes in SSAS environment for snowflake schema and Star Schema designs.
• Created Yearly Partition and processing Cube based on adjustments occurs using SSIS package as well as deployed cubes in various environments.

Environment: MS SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential, Jacksonville, Florida

SSIS Developer/BI Developer

RESPONSIBILITIES:

• Participated in requirement gathering, data warehouse design, application design, and SSIS development, training operational staffs and mentoring junior staffs.
• Created SSIS packages for new projects utilizing Business Intelligence Development Studio.
• Designed data flow diagrams for new projects.
• Involved in Designing of ODS, Star Schema and Staging area.
• Created user interface application to insert file folder path information to SQL tables.
• Created execute SQL task to retrieve the folder path from the SQL table to bulk load text files to the warehouse and assigned dat folder path info to package level variable.
• Created For each loop to iterate through a number of suppliers having multiple text files to be loaded to the warehouse.
• Created File enumerator to iterate through a number of files per supplier and assign dat file path to package level variable, which is used by the Flat file source.
• Created a script component to read the title of the columns from the text file, to read SQL table to find the appropriate mapping columns and to map columns dynamically.
• Created mapping document and database diagrams Load access tables to SQL to create look up tables.
• Load text file to staging area, edit columns based on the business logics, created unique identifiers.
• Generated stats reports based on the data in staging area to analyze the quality of the data.
• Created SSIS package to uploaded data to the warehouse, once the data is verified.
• Generated stats based on the uploaded data and existing data to check the data accuracy and export them to excel for distribution.
• Created ActiveX tasks to create file, edit text source file, to change DTS task properties dynamically and to edit and map column dynamically.
• Created web services to return list of suppliers and customers.
• Created Quality Assurance stats reports using SSRS.
• Reviewed existing project document, suggested correction and updates.
• Trained operational staffs on how to download data understand stats reports; verify data quality based on stats and to decide for uploading / rejecting data to the data warehouse.
• Created several stored procedures and views for Reporting.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed reports using SSRS and published as PDF formats.

Environment: MS SQL Server 2005,SSIS, SSRS, SSAS, T-SQL, MS OLAP, ERWIN 4.0, Oracle 10g, DB2, Sybase, Active X, Microsoft Source safe, Windows 2003.

Confidential, Alpharetta, GA

SQL Server Developer /BI Developer

RESPONSIBILITIES:

• Worked as a developer on databases like MS SQL Server 2000, MS Access (using DTS, T-SQL, scripts, stored procedures and views).
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Managed requests from the clients and from the development teams.
• Designed and developed the Logical and Physical model of the database.
• Worked on Performance testing of the Application using Load Runner.
• Created automated test scripts using QTP and Win Runner.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, and Indexes.
• Created and automated the regular jobs.
• Managed and monitored the system utilization.
• Managed the security of the servers (Logins and users).
• Developed complex T-SQL code for the application.
• Designed stored procedures and triggers for automating tasks.
• Worked on complex data loading (implemented the batch data cleansing and data loading).

Environment: MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.