SUMMARY

• Around 5+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2000/2005/2008/ R2 for both OLTP & Data warehousing(SSIS,SSAS,SSRS) applications in various business domains.
• Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.
• Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
• Involved in relational data modeling and multi-dimensional modeling using Denormalization, Fact tables, Dimension tables, Star schema for OLAP systems.
• Experience in SQL Server DTS and SSIS package design, development, and deployment using SQL 2008/2005 in Control flow, Data flow, Error Handling and Event handling in different heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Extensive experience in SSRS and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down and Sub reports.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Worked on SQL BI solution integration with Microsoft Share Point Server (MOSS).
• Expertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Worked on OLAP Data warehouses, Modeling, Design, cube development including KPIs, Data mining, working with changing dimensions.
• Experience in OLAP cube partitions, aggregations, optimization as well as refreshing cube data.
• Experience in developing web applications using ASP.Net, ADO.Net.
• Performed daily tasks including backup and restore usingtools likeSQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Self-Motivated with Excellent communication skills with a strong focus on Client oriented service and ability to work excellently as an individual and also as part of a team with minimum amount of supervision.

TECHNICAL SKILLS

Databases: MS SQL Server 2008R 2/2005/2000/7.0 , ORACLE, MS Access

Database Tools: MS SQL Server 2008R2/2005/2000, MS-Access, SSIS, DTS, SSAS, BIDS And Erwin

Development skills: SQL, SSIS/SSRS/SSAS, Oracle

Languages: VB Script, T-SQL, HTML, XML, ASP, Java Script, Vulcan, VBA Macro, C, C++

Operating Systems: Windows 98/NT/2000/XP, 2003 Servers, UNIX.

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, Visual studio.

PROFESSIONAL EXPERIENCE

Confidential, Woodland Hills, CA

MS SQL Server/ BI Developer

Responsibilities:

• Involved in gathering Requirements form the Business and worked as a part of Data Modeling Process.
• Continues Interaction with the business for the Data delivery and Data quality.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Performed ETL from various data sources like Excel, CSV, Text files and various client servers.
• Developed various Stored Procedures and implemented different business logics, Filters to pull required data from sources.
• Designed various reports using Pivot - tables, and different charts like Bar, Pie, Line Etc... With CUBE and SQL Server as data sources.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Designed automated excels using VBA Macro and Functions.
• Generated various AD-HOC reports as pet the business requirements.
• Worked on optimizing Query’s and maintaining the consistency of Databases.
• Maintained the documents and packages in Team Foundation Server.
• Worked internally to achieve the Data consistency with both the Up-Stream and Down-Stream Systems.

Environment: MS SQL Server 2008R2/2008/2005, SSIS, SSAS, SSRS, EXCEL, VBA Macro, TFS, Share Point.

Confidential, San Antonio, TX

MS SQL Server/ BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Developed various T-SQL queries, Stored Procedures for data retrieval, maintenance and testing.
• Developed various SSIS packages for managing current and historical data using various transformations.
• Good experience in Master Data Services (MDS).
• Created different Models, Versions and Managed different entities using MDS.
• Automated the Batch Processing and Version Validation.
• Created and published various Business rules to validate master data to ensure Data Accuracy and completeness.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Involved as a part of Data Governance team in MDM.
• Worked with the business to meet their requirements on time.
• Integral part of the Warehouse team for the Design, Development and functioning of cube.
• Worked in Production environment and resolved the tickets in time to deliver the requirements.
• Overall hands on all tasks of MDM, MDS and all other Data related issues.

Environment: MS SQL Server 2008R2, SSIS, SSAS, MDS, VULCAN, EXCEL, Visual Studio.

Confidential, Oklahoma City, OK

SQL Server/ BI Developer

Responsibilities:

• Involved in different phases of SDLC process of design, development and testing of License Information Repository application using SQL Server.
• Participate in up gradation and migration of data from SQL
• Modified a number of existing stored procedures based on the changes made to existing tables.
• Migrated DTS packages to SSIS packages.
• Worked with slowly changing dimensions type 2.
• Created SSIS packages to perform cube processing from staging to Analysis Services Cube.
• Developed aggregated queries to populate the fact tables.
• Created a MOLAP Cube on SQL Server 2005 Analysis Services as an alternative prototype to an existing relational data mart.
• Handled millions of records on changing dimensions as well as facts in SSAS.
• Developed numerous reports off OLTP Servers using Reporting Services by writing T-SQL queries, stored Procedures with parameters, charts and multiple datasets.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005 Reporting Services.

Environment: SQL Server 2000/2005, SSIS Packages, SSAS, SSRS, Product Studio and Windows.

Confidential, Parsippany, NJ

SQL Server BI Developer

Responsibilities:

• Used the SSIS to migrate databases such as Oracle and Access database, flat files to centralized SQL server destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Generated reports on wealth information, account information, research reports using AD-HOC reporting to be used by the clients and advisors.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updations to improve the query performance.
• Conducted performance tuning by using SQL Profiler and index tuning wizard.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly
• Scheduled, maintained, and supported the distribution and access to reports through Crystal Server

Environment: MS SQL Server 2005, SSIS, SSRS, T-SQL, Crystal Reports 10,Visual Studio 2005, MS Office 2007, SQL Profiler, Windows 2003.

Confidential

MS SQL Server Developer

Responsibilities:

• Gathered requirements from business users.
• Wrote user requirement documents based on functional specification.
• Created and designed data models using Erwin data modeling tool.
• Designed physical data models.
• Created DDL scripts to create database schema and database objects.
• Created functions, views and triggers.
• Developed source to target specifications.
• Created DTS package and schedule the jobs for batch processing.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Greatly involved in Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.

Environment: SQL Server 2000, Visual Basic 6.0, ASP. NET, Windows NT.