SUMMARY

• Around 7 years of IT industry experience with Microsoft SQL Server 2000/2005/2008 , SSIS/SSRS/SSAS in OLTP and OLAP(Data warehousing) environments
• Extensive experience in business analysis, requirements gathering and refinement and reports design
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T - SQL Programming using DDL, DML, DCL commands for various business applications.
• Expert at developing ETL interfaces using SSIS, Datamarts/cubes using SSAS and enterprise reports using SSRS/Crystal utilizing latest versions (2005/2008) & features
• Hands on experience with Performance Point Server 2007, ProClarity, Business Scorecard Manager (BSM).
• Experience in designing Database Models using MS Visio and ER-Win for both Relational and dimensional modeling
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, Cursors for various business applications
• Experience in Error handling and debugging coding issues and troubleshoot production problems
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions,CTE’s,TableVariables and Stored Procedures
• Experience in SQL Optimizing by using SQLProfiler, Index Tuning Wizard, Database Tuning Advisor,DBCC Commands, DMV’s, DMFs and Query Execution Plans
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities
• Hands on experience with performing various data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and EventHandlers, Error Handlers etc.
• Experience in conversion of packages from legacy systems (DTS to SSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Expertise in generating reports using Business Objects 6.5/XI, Crystal Reports and SQL Server Reporting.
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc
• Integration of SSRS Reports using various web parts into Sharepoint and various delivery mechanisms
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Excellent analytical/Communication Skills, Team Play and very much result Oriented

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2000/7.0 , ORACLE, MS Access, teradata V2R6/V2R5, DB2

Database Tools: MS SQL Server 2000/2005/2008 , MS-Access, performance point server, SQL Server Integration Services, Data Transformation Services, SQL Server Analysis Services, OLAP(Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio

Development skills: T-SQL,PL/SQL,SSIS/SSRS/SSAS, ProClarity, BO XI, MicroStrategy

Languages: VB.net, VB Script, T-SQL, SSAS, OLAP, HTML, XML, ASP, Java Script, C, C++ and MDX.

ETL Tools: DTS, SSIS (SQL Server Integration Services), Informatica.

Reporting Packages: SSRS 2000/2005/2008 , Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel.

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, SQL*Loader, Front page, Microsoft Share Point Server 2007, Performance Point Server.

PROFESSIONAL EXPERIENCE

Confidential, Mason, OH

SQL Server/Microsoft-BI/Share-Point Developer

Responsibilities:

• Involved in the process of automating the Manual Billing process for more TEMPthan 120 clients.
• Involved in gathering business requirements, Server access credentials, firewall settings Data dictionaries, Data mapping dat are to be defined and data structures from clientele
• Created functional requirement specifications and supporting documents for business systems.
• Involved in database design process and data modeling process for Billing Method using Erwin.
• Involved in ETL process development, Implementation and support for the Analytics and Reporting needs of over 120+ customers
• Used SSIS/DTS in performing the extractions from various data sources SSAS cubes for data marts, Enterprise warehouse and SSRS for reporting needs
• Accomplished the task of converting DTS packages from /2008 by using SSIS tasks in SSMS,BIDS and troubleshoot the conversion process
• Developed and Implemented SSIS packages, utilities like Bulk Insert, BCP and DTS on an enterprise level for all the ETL needs (Multimillion data transfer)
• Involved in importing and exporting data from text files, MS Excel and other OLEDB sources into SQL Server using SSIS/DTS and Vice Versa.
• Wrote Optimized Stored Procedures with T-SQL for better performance for OLTP and OLAP needs
• Developed views and indexed views for easier implementation on web pages as per the client requirements
• Responsible for creating batches & scripts for nightly/weekly batch process using T-SQL.
• Created Joins, Views and Triggers written Sub Queries using T-SQL involving multiple numbers of tables.
• Performed query optimization using SQL Profiler, Index Tuning Wizard,DTA, Query Execution Plan, Indexes and appropriate joins
• Actively involved in analyzing the old database system and mapping tables, relationships, columns to SQL Server 2008.
• Experience in developing and deploying OLAP cubes, monitoring full and incremental loads
• Involved in designing of Star schemas, identifying fact and dimensions, add KPIs and Scorecards
• Experienced in building MDX queries and DMX (Data Mining Expression) queries for Analysis Services & Reporting Services.
• Integrated Reports into SharePoint portals using OLAP cubes as data source
• Involved in creation & web publishing of reports using SSRS in different formats (Excel, PDF etc).
• Designed reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used MS Office Performance Point Server 2007 Dashboard Designer to create Executive level scorecards and Dashboards and deployed them on to the SharePoint Site.
• Used ProClarity tool to analyze the data in the cube by using the different features like Chart View, Decomposition Tree, Performance Maps, etc.
• Published reports on to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one Page.
• Created forms on share-point to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources.
• Created forms on share-point allowing the users to insert data into the underlying data-sources.
• Involved in developing Life Cycle using Agile Methodology.
• Adhere to change control procedures for deployment of code across all SDLC environments
• Coordinating with end users, upstream/downstream customers for various requests and issues

Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, Oracle, Report Builder 2.0, SQL Profiler, Erwin, SQL Server Integration services, SQL Server Reporting services, SQL Server Analysis Services, Visio, Share-Point, Microsoft-Office 2003/2007, MS-Excel 2003/2007.

Confidential, Houston, TX

SSIS/SSRS/SSAS /SQL Server DW Developer

Responsibilities:

• Involved in requirement gathering and technical translation of requirements for the ETL needs of ETRACS application
• Involved in identifying the data sources, create data dictionaries, define data mapping and document ETL Procedures
• Involved in database design process and data modeling process using diagrams and Visio.
• Involved in optimization of queries, improving performance and Maintaining database consistency with DBCC check at scheduled intervals
• Created Data-driven Packages in SSIS as part of the automating the process for billing method.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, .CSV, Excel and Text file from Client servers using FTP tasks and utilities
• Built various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages.
• Designed various Cubes as per the requirements for various clients using SSAS.
• Involved in Designing Aggregations and pre-calculations in SSAS 2005/2008.
• Created Measures, KPIs and defined Actions, Translations and Perspectives in Analysis Services.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Involved in writing MDX Queries for Analytical and Reporting purposes.
• Involved in developing and deploying OLAP cubes, monitoring full and incremental loads.
• Involved in adding additional Dimensions and Measure groups to already existing SSAS Cubes based on the changing requirements of the customer.
• Involved in using Analytical cubes for designing reports in SSRS and Excel Reports.
• Created reports using SSRS from various sources like SQL Server 2005/2008 and Cubes from Analysis Services
• Created dashboards using MS Office Performance Point Server 2007 Dashboard Designer and the dashboards are incorporated with drill down capability to view categorical data.
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Designed reports using Pivot-tables, Bar charts, Line charts and Pie charts on data from cubes and SQL Server in Excel 2007.

Environment: SQL Server 2000/2005/2008 , T-SQL, Windows2003,SSIS,SSRS,SSAS, Oracle,VB,ASP, SQLProfiler, Erwin, Visio, BO- XI, Web Intelligence 3.1, Share point Products and Technologies WSSV3.

Confidential, Chicago, IL

SQL Server Developer/ETL Programmer/OLAP Developer

Responsibilities:

• Involved in supporting Reporting and OLTP application back end coding for Loan and Financial forecasting applications
• Developed parameterized stored Procedures required to retrieve/insert data from the applications into the database
• Involved in creation of Optimized Clustered and Non Clustered indexes for optimal performance
• Used SQL Server Integration Services to design and build the ETL procedures and a Data Warehouse to meet client requirements.
• Created and scheduled DTS packages using Active-X scripting for importing selected data from different servers and flat files into the GCDB.
• Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Implemented Normalization to 3F for OLTP system and some De-Normalization for OLAP system.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SSIS in Extract, Stage and Production Servers.
• Involved in Data Ware House, datamart designing and creation of Cubes using dimensional data modeling and identifying Facts and Dimensions.
• Built Reporting OLAP cubes with Microsoft Analysis Services using Business Objects as a front end.
• Created SSAS cubes and used them for marketing research team who analyses the performance of brokers and agents forecasts
• Hand on experience in designing cubes and optimized application performance and created dynamic rules based security model to customize data/report access for multiple users.
• Involved in Installation and administration of Microsoft SQL Server Reporting Services, created schedule reports and delivered the reports via email in links and PDF attachments
• Designed Report Layouts for Parameterized Reports and Drill Down reports, Tabular Reports, Hyperlink Reports.
• Created Scorecards and Dashboards by using MS Performance Point Server 2007.
• Experienced on working with SSRS and Business Intelligence tools and reporting services like Crystal Reports.
• Package Configuration using XML is implemented.
• Work with .NET developers and Project Managers to resolve application/database objects conflicts.

Environment: SQL Server 2005/2000, T-SQL, Data Transformation Services (DTS), .net, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), ER/Studio, Business Objects, SQL Profiler, Enterprise Manager.

Confidential, MEMPHIS, TN

SQL Developer/ ETL Programmer/SSAS

Responsibilities:

• Participated in development efforts to analyze client server applications using Visual Basic 6.0 as front-end tool and MS SQL Server Database.
• Actively involved in analyzing the old database system and creating an environment and performed mappings to SQL Server 2005.
• Designed ER diagrams and mapped the data into database objects.
• Designed ETL packages for different data sources (SQL Server, Flat Files, and XMLs etc).
• Involved in converting existing PL/SQL stored procedures, triggers, functions and script to T-SQL.
• Designed, Implemented, Maintained OLAP servers and processes to replicate production data to the server.
• Involved in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Performed data extraction from OLTP to OLAP for decision making using SSIS.
• Extracted large volumes of data from different data sources and loaded the data into target data by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Provided documentation on current database environment and as well on the structure dat needs to be modified in the future for better performance of the system.
• Designed Dimensions and using the MDX expressions for the various Optimizations like Optimizing cube schema.
• Involved in Installation, Configuration of SSRS Reporting server and involved in Deploying reports.
• Deploying SSRS Reports across multiple environments including Test, Production and supporting environments.
• Scheduled Reports based on a particular Day and sent them through Email in required format (Excel, PDF, etc.)
• Worked in the complete life cycle of the project, from the beginning i.e Planning Stage to final i.e giving the codes to production side

Environment: MS SQL Server 2005/2000 Enterprise Edition, Windows XP, Oracle, T-SQL and ER-WIN, Crystal Reports, Windows 2000 Server.

Confidential, NJ

SQL Developer

Responsibilities:

• Involvement in design and development of Tables, Queries, Access Pages and Macros.
• Involved in Designing and developing Sales reports, inventory reports and order reports, etc.
• Experienced in SQL Script writing and involved in application design using C# and Visual Basic.
• Responsible for database creation, objects creation, database tuning & administration.
• Designed and developed databases using MS Access from scratch.
• Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Design and implementation of database maintenance plan.
• Used Iterative Approach to develop a project.
• Used DBCC checks and fixed data corruption in Application databases.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Responsible for using SQL Profiler and Database tuning wizard to tune up the performance of stored procedures.
• Responsible for converting existing PL/SQL procedures, triggers, functions and script to T-SQL.

Environment: SQLServer 2000,MS Access, MS Excel, T-SQL,PL/SQL,Oracle,DTS, Windows 2000 Erwin

Confidential, Foster City, CA

SQL Server Developer

Responsibilities:

• Creation of database, tables and procedures to update and clean the old data.
• Responsible for Logical and Physical design of database for projects on basis of user requirements.
• Involved in creation and reallocation of database objects on appropriate File groups to ease maintenance and improve data access performance.
• Designed and developed for data download from external systems to verify revenues and commissions.
• Involved in designing logical and physical data models using ERWIN and ER/Studio tools
• Responsible in SQL Server disaster recovery procedures and involved in Stored Procedures Optimization, Performance tuning & Index tuning
• Responsible for merging of data into a single server environment for achieving better control, consistency and security of data.
• Responsible for Implementation of batch processing for approval process using Jobs and DTS.
• Wrote DTS Packages to transform daily and monthly jobs, like data on expired items, items below reorder level etc.
• Helped the front end application developers with their queries.

Environment: Windows 2000/XP, Microsoft SQL Server 7.0/2000, MS excel, Erwin, .Net, VB Script, Crystal Reports.

Confidential

Jr SQL DBA/Developer

Responsibilities:

• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Design of the database and tables and loading of data into them.
• Installed and Configured SQL Server 2000 successfully.
• Involved in writing procedures to check some of the rules at the backend at the time of entering data.
• Responsible for development of SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Built table relationships and wrote stored procedures to clean the existing data.
• Coordinated with the front-end developer to put in the business rules.

Environment: Server 2000 Enterprise Edition, T-SQL, Enterprise manager, Crystal Reports, MS Office and Windows 2000