SUMMARY

• Over Seven plus years of IT industry experience with Microsoft SQL Server 2000/2005/2008 , SSIS/SSRS/SSAS and OLAP.
• Microsoft Certified Technology Specialist in Business Intelligence and SQL Server 2005.
• Significant experience with SQL Server Reporting Services, Analysis Services and Integration Services..
• Experience in developing the applications using T - SQL Programming (DDL, DML, and DCL).
• Hands on experience in creating ETL packages using SQL Server 2005 Integration Services (SSIS).
• Thorough understanding of data modeling, particularly in area OLAP system design, cube, star-schemas, etc.
• Good knowledge of OLAP and Data Warehouses.
• Worked with customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Experience in Upgrading from SQL Server 2000 to SQL Server 2005.
• Expert at creating reports using SQL Server Reporting Services, SQL Server Analytical Services and OLAP (Creating Cubes) including interfaces with BIDS.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Good knowledge in optimizing queries using MDX.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Experience in designing Database Models using MS Visio and ER-Win.
• Expertise in generating reports using MicroStrategy, Crystal Reports and SQL Server Reporting.
• Experience in MS-DTS, Troubleshooting Design and Administration of Databases and other RDBMS concepts such as Tables, User Defined Data Types, Indexes and Stored Procedures
• Expert in Extracting and Transforming data using SSIS in SQL Server 2005, DTS in SQL Server 2000, Import, Export Data, Bulk Insert and BCP.
• Experience in installation and configuration of MS SQL Server 2005/2000 versions.
• Excellent in Transforming Logical Database designs into Physical Databases.
• Experience with SSMS, SQL Server Profiler and SSIS Wizards.
• Expertise in Building and Rebuilding Very Large Databases (VLDB).
• Experience in Optimizing SQL Performance by Performance Tuning and Client/Server Connectivity, Back-up/Recovery running Database Consistency Checks using DBCC.
• Experience in Error handling using Stored Procedures and Views.
• Exceptional background in analysis, design, development, customization, implementation and testing of software applications and products.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Intensive experience in monitoring database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.

TECHNICAL SKILLS

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

Database Tools: MS SQL Server 2000/2005, 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, Pro-clarity, BO XI, MicroStrategy

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

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

Reporting Packages: SQL Server Reporting Services, Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, Columbus OH

MS SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Installed, upgraded and migrated different ETL packages using SSIS and transferred data from Oracle source to MS SQL server 2008 destination databases.
• Created different SSIS packages to load the DAT files for the promotions data and loading the created different jobs for loading the fact and dimension tables.
• Created SSRS reports from the promotions SSAS cube using SSRS 2008 R2.
• Built MDX queries for Analysis Services & Reporting Services.
• Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP by creating new logical and physical design of database into SQL Server 2008.
• Involved in doing the relational database changes/updates to the current tables.
• Building Talbots promotions SSAS cube which contains different measure groups and dimensions.
• Implemented the Package configuration using XML files and used the config files for different environments DEV UAT and PROD.
• Worked on SQL Profiler and Estimated Query plan to optimize the performance of SQL queries and stored procedures.
• Created measure groups for different metrics to be reported in the reports.
• Involved in automating the partition management for the measure groups for the performance of the SSAS cube.
• Used Autosys job scheduler to schedule all the jobs and creating boxes for different processing jobs.
• Created datasets and designing the reports and writing MDX statements and expressions for the reports.
• Generated reports using MS SQLServer Reporting Services 2008 from OLTP and OLAP data sources.
• Scheduled Cube Processing from Staging Database Tables using SQLServer Agent using SSAS.
• Wrote different stored procedures for data updates of the history records and for error logging.
• Used scrum methodology to implement the project with daily scrum meetings and sprint planning for every 3 weeks.
• Created views for all the fact and dimensions to be used in the promotions SSAS cube.
• Used SVN tortoise for the version control to maintain all the reports and packages.

Environment: BIDS, SSRS, SSIS, SSAS, SQL Server 2008 R2/2008/2005, Visual Studio 2005/2008, MDX ASP.NET, HTML, XML, SVN tortoise, Sharepoint Designer 2007, Autosys job scheduler, Ms SQL server Power Pivot T SQL, JavaScript, Microsoft Visio.

Confidential, Irving TX

BI Analytics Consultant/SSIS/SSRS/SSAS

Responsibilities:

• Involved in gathering business requirements from clients about the credentials needed to access their servers, firewall settings and management about the table structures that are to be defined and the data structure that is to be collected from the clients.
• Created functional requirement specifications and supporting documents for business systems.
• Experience in database design process and data modeling process for Billing Method using Erwin.
• 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 and through FTP
• Built various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages.
• Created reports using SSRS from various sources like SQL Server 2005/2008 and Cubes from Analysis Services.
• Created Web Edit forms on Sharepoint using Sharepoint Designer 2007.
• Created a Dashboard which consists of 7 Sub Reports and used Cube as a Data source to pull the data, and deployed those reports on the Sharepoint Site.
• Designed reports using Ms SQL server Power Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel 2007.
• Replicated a DB, Cube and its entire object to a different Server and changed the SQL jobs to point to the new Server.
• Converted an Excel based Application used to do Calculations into a T SQL based application using Complex Stored Procedure’s.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Designed various Cubes as per the requirements for various clients using SSAS, and modified the already existing Cubes by adding new Dimensions.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• 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 and allowing the users to insert data into the underlying data-sources.
• Experience in developing Life Cycle using Agile Methodology.
• Experience in optimization of queries, improving the performance and Maintaining the database consistency with DBCC at regular intervals.

Environment: BIDS, SSRS, SSIS, SSAS, SQL Server 2008/2005, Visual Studio 2005, MDX ASP.NET, HTML, XML, Microsoft Visual SourceSafe, SSRS, Sharepoint Designer 2007, Ms SQL server Power Pivot T SQL, Team Foundation Server, Performance Point Server 2007, MOSS 2007, JavaScript, Microsoft Visio.

Confidential, Florida

SQL Server developer / BI Consultant

Responsibilities:

• Installed SQL Server 2005 with migration of applications from SQL Server 2000 and documented the client specifications.
• Extracted data from DB2 to SQL server using third party application and also flat file, excel sheets, SQL server into staging environment.
• Implemented ETL by creating several SSIS packages to load the historical and operational data using full load, merge as well as incremental loading
• Responsible for designing ETL process, SSIS package
• Used SLOWLY CHANGING DIMENSION, LOOK UP to maintain a parent child relationship.
• Used different transformation controls, event handling to handle an error.
• Added intelligence system to identify change in dimension.
• Designed OLAP cube over data warehouse and deployed cube on SSIS server.
• Created reports for budget and forecasting with use of excel and SSRS and configure with VB macros to deploy on SSRS server.
• Wrote and integrated Stored Procedures to generate the Reports
• Deployed developed reports on to the Server using Share Point Portal and Report Manager.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Created several click through reports, drilldown reports, linked reports, master detail and sub reports
• Worked closely with front end team requirement discussions on connections(ADO), ASP.Net
• Provide 24x7 supports and ensure that all critical database problems are resolved in timely manner.

Environment: MS SQL Server 2000/2005& T-SQL,SQL Server Integration Services(SSIS), DTS 2000, SQL Server Reporting Services (SSRS), SSAS, SQL Profiler, MS Office, Windows 2003 Server, Visual Studio 2005, Windows XP.

Confidential, Chicago, IL

MSBI Developer

Responsibilities:

• Set up the SSIS packages for the exchange of data between different data sources.
• Defined and processed the Fact table & Dimensions using SSIS.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
• Co-developed the ETL architecture design and the metadata model.
• Designed ETL packages for different data sources (SQL Server, Flat Files, and XMLs etc).
• Used various ETL tools like DTS/SSIS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Reporting OLAP cubes built with Microsoft Analysis Services using Business Objects as a front end.
• Migrated SQL Server 2000 DTS objects to SQL Server 2005 integration services (SSIS) environment.
• Design Dimensions and using the MDX expressions for the various Calculated Members, Actions and KPI.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Designed and created cubes and optimized application performance and created dynamic rules based security model to customize data/report access for multiple users.
• Involved in designing of Star, Snowflake schemas and dimensional data models.
• Designed/implemented the information access and delivery effort for the data warehouse.
• Created logical and physical data models according to the business requirements.
• Monitored the performance of SQL Server using SQL Server Profiler.
• Designed different kinds of transactions for the application.
• Performed data transformation services and bulk inserts for large amounts of data.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Experienced in setting up SQL Server and database configuration parameters.
• Developed a Tabular Reports using SSRS Report Designer.
• Debugging reports and deploying reports on server.
• Installed and administered Microsoft SQL Server Reporting Services.
• Created subscription in report manager in both standard and data-driven subscription.
• Configured Report Server for email delivery.
• Configured SMTP server and scheduled reports and send the reports via email.
• Created ad-hoc reports using SSRS Report Builder.
• Added a document map in the reports as per the business requirement.
• Implemented the SharePoint portal services
• Incorporated reports into WS SharePoint services.
• Utilized Visual Studio 2005 to design and create workflows for InfoPath forms submitted by users.

Environment: SQL Server 2005/2000, T-SQL, Data Transformation Services (DTS), Analysis Services (SSAS), Reporting Services (SSRS), Windows SharePoint services 3.0, Integration Services (SSIS), ER/Studio, Query Analyzer, Business Objects, SQL Profiler, Enterprise Manager

Confidential, Chicago, IL

Reporting Consultant

Responsibilities:

• Installation and configuration of SQL Server Reporting Services 2005.
• Involved in migration of crystal reports to SSRS 2005.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Configured Transactional Replication between the Production server and Reporting server to move the data to servers in various locations to the Share Point portal Server.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Involved in creating report models and applying row level security filters for report model.
• Developed Stored Procedures and Views to be used to supply the data to the reports. Complex formulas were used to show derived fields and to format the data based on specific conditions.
• Experience in building reports through Report Builder and Report Designer.
• Experience in creating reports using Report Model and applying row level security filters.

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle.

Confidential

SQL Developer

Responsibilities:

• Created Logical and Physical data models using ERWIN data modeling tool.
• Developed Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Migration of the data from various sources using DTS.
• Scheduled and performed data transfers using DTS including filtering appropriate to the data mart for data analysis.
• Designed and implemented user login and security.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
• Planned the complete back-up of databases for disaster recovery scenarios.
• Reorganized database structures as needed, automated procedures at regular intervals.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Involved in project planning, scheduling for database module with project managers.

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

Education and Certification:

Bachelors in Computer Science from JNTU, India.

Implementation and Maintenance with Microsoft SQL Server 2005 Business Intelligence (Exam 70-431).