SUMMARY

• Over 7 years of IT experience in Database Design, Development, Implementation and Support using various Microsoft technologies(SQLServer 205/2008,T - SQL) in both OLTP and data warehousing environments
• Experience with various domains like Insurance, Energy, Communications, Engineering, and Banking
• Expertise in SQL Server and T-SQL(DDL, DML and DCL) in constructing Tables, Joins, Indexed views, Indexes, Complex Stored procedures, Triggers, and useful functions to facilitate efficient data manipulation and consistent data storage according to the business rules
• Strong technical knowledge in SQL Server BI suite (ETL, Reporting, Analytics, Dashboards) using DTS/SIS, SSAS, SSRS and various 3rd party tools
• Experience in Data modelling, Database design, normalization techniques using Database diagrams, Erwin and other Data modeling tools.
• Expert in creating, debugging, configuring and deploying ETL packages designed in Data Transformation Services (DTS) and MS SQL Server Integration Services (SSIS).
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert and BCP).
• Hands on experience in designing Enterprise and Adhoc reports using MS SQL Server Reporting Services (SSRS).
• Experience in configuration of report server and report manager for job scheduling, giving permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in creating OLAP Data marts using SQL Server Analysis Server (SSAS).
• Experience in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions.
• Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005) using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience deploying database objects (T-SQL scripts, stored procedures, SSIS, SSRS, and SSAS) from Development server to QA and Production.
• Hands on experience in Package Migration from DTS Packages to Integration Services.
• Basic exposure on creating score cards and dashboards using MS Office Performance Point Server 2007(MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services.
• Experience in Monitoring and Tuning SQL Server Performance.
• Responsible for creating Requirements Documentation for various projects.
• Strong analytical skills, proven ability to work well in a multi-disciplined team environment, and adept at learning new tools and processes with ease.

TECHNICAL SKILLS

Languages: - PL/SQL, SQL, C, C++, ASP.NET, C#.

Operating Systems: - MS-DOS, WINDOWS 9x/ NT/ 2000/ XP, UNIX.

Databases: - MS SQL Server 2000/2005/2008 , MS Access 2007, Oracle 10g.

Reporting Tools: - MS SSRS 2005, 2008, Oracle BI Discoverer Plus.

ETL Tools: - MS SSIS 2005, 2008.

Market Analysis Tools: - D&B Market Insight.

GUI: - Visual Studio, BIDS, Oracle Developer 2000.

Web Languages & Scripting: - HTML 4.0, DHTML, PHP, JavaScript, CSS, XML, Python.

Protocols: - TCP/IP.

Assembly Languages: - Intel 8086.

GIS Tools: - MapInfo, ArcMap, ArcCatalog from ArcGIS versions 9.2 and 9.3.

Miscellaneous: - MS Office Suite, Photoshop, Flash, Fireworks.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

BI Developer (SSIS.SSRS.T-SQL)

Responsibilities:

• Worked with various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL,Analytics and reporting needs
• Point of contact for all the Data processes, Data Mappings, Data dictionaries, Data pulls and Reporting solutions.
• Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations.
• Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration
• Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Loading the Fact and Dimension tables.
• Querying, creating stored procedures and writing complex queries and T-SQL joins to address various reporting operations and also random data requests.
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008 and were integrated in the Performance point server.
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various in-house users and also for reinsurers and producers.
• Creating and maintaining various subscriptions in the Report Manager for the reports.
• Creating custom forms using MS Access to facilitate user data requests on demand.
• Developing products by determining what competitors are doing, risk assessments, ratings assessments, pricing and coverage.
• Developing training materials and underwritings.
• Involved in User communication for requirement gathering and Change control and code control policies and procedures

Environment: MS SQL Server 2008/2005, SQL Server Reporting Services (SSRS) 2008, SQL Server Integration Services (SSIS) 2008/2005, SQL Server Analysis Services (SSAS) 2005, Share Point, MS Project, MS Access 2003/2007, VBA.

Confidential, Blueash, Ohio

Commercial Data and Report Developer

Responsibilities:

• Main point of contact for market data and data analysis.
• Extracting market data using D & B Market Insight to CSV files, transforming the data to the desired format and then Loading the data into local company databases using SSIS.
• Assisting with data cleansing and preparation to facilitate enhancement of existing databases and tools for analysis and decision making.
• Defined OLAP cubes based on fact tables and dimension tables to suit a range of report/analysis requirements with SQL Server 2005 Analysis Services (SSAS).
• Worked with installation, configuration and deployment of SQL Server Reporting Services (SSRS).
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service.
• Creating various reports using SSRS for multiple sales teams within the company to support sales/builds.
• Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company.
• Creating custom Microsoft Access Forms with code behind in Visual Basic for Applications (VBA) for users to query and pull the data and integrating multiple in-house tools on to those Forms to increase the productivity and performance.
• Creating prospect customers campaign lists for marketing teams using UNICA Campaign Management tool.
• Plotting customer data on a map and performing various operations like Distance Calculation to the nearest Coaxial Cable/Fiber Cable, Extraction of customers within particular zip code/area or within specified distance of the Coax/Fiber cable, etc. using MapInfo.

Environment: MS SQL Server 2005, SQL Server Reporting Services (SSRS) 2005, SQL Server Integration Services (SSIS) 2005, SQL Server Analysis Services (SSAS) 2005, MS Access 2003, VBA, Oracle Business Intelligence Discoverer 10g, MapInfo.

Confidential, New York, NY

SQL Consultant

Responsibilities:

• Facilitated meetings with all levels of the business community for requirements management, design considerations, and quality control.
• Developed and optimized stored procedures, views, triggers and user-defined functions.
• Optimized the performance of queries with modifications in T-SQL queries, established joins and created indexes where ever necessary.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on a daily basis.
• Reviewed cubes, changed the cubes and documentation according to the requirement based on evaluation and revenue opportunities using SSAS.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, Drill Down reports, Drill through reports and Parameterized reports using SSRS.
• Responsible for Monitoring and Tuning Report performance.
• Created official Templates, Mailing Subscriptions and created shared data sources that can be used across different processes.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Provided documentation for all kinds of Reports and SSIS packages.

Environment: T-SQL, SQL Server 2008/2005, SQL Server Reporting Services 2008(SSRS), SQL Server Integration Services 2005/2008(SSIS), SQL Server Analysis Services (SSAS) 2005, Windows 2003.

Confidential, Cleveland, Ohio

SQL Server Developer

Responsibilities:

• Involved in writing views, complex stored procedures and triggers.
• Scheduled the ETL Process using Jobs.
• Modified SSIS packages to accomplish critical business logic.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SSAS.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Designed and developed various complex reports.
• Scheduled reports for the end users and Customers to view.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Fixed issues in the existing reports.
• Responsible for maintaining the accuracy and quality of the data.

Environment: SQL Server 2005, SQL Server Reporting Services 2005 (SSRS), SQL Server Integration Services 2005(SSIS), SQL Server Analysis Services (SSAS) 2005, T-SQL, MS Access, Excel.

Confidential, Irving, TX

BI Consultant

Responsibilities:

• Involved in requirements gathering sessions with the users and Business Analysts to understand business analysis functions to be supported.
• Developed reports of the data, and worked with business users to refine their analysis requirements.
• Involved in package migration from DTS packages to Integration services.
• Developed ETL packages using SSIS and stored procedurefor data loading.
• Extensively used T-SQL statements to write complex queries.
• Extensively used Stored Procedures. Wrote new stored procedures and modified existing ones andtuned them such that they perform well.
• Used Indexes to enhance the performance of individual queries and enhanced the stored procedure.
• Dropped and recreated the Indexes on tables for performance improvements.
• Customized and developed reports using Microsoft SQL Reporting Services (SSRS).
• Customized usage based optimization, data compression and storage optimization, query tuning.
• Developed roles, policies and procedures for ensuring the security and integrity of the report.
• Written technical design documentation for alterations to current business logic and future project designs.

Environment: SQL Server 2005, SQL Server Reporting Services 2005 (SSRS), SQL Server Integration Services 2005(SSIS), T-SQL, SQL Server Profiler, MS Access, Excel.

Confidential

SQL Server Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of end User Requirements.
• Created new database objects like Stored Procedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2000.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist withcoding,designandperformance tuning.
• Managed user access. Created and managed new security accounts.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Updated the statistics info for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000, T-SQL, DTS Designer, MS-Office, MS-Excel.