SUMMARY

• Over 6 years IT experience with database development experience, Business Intelligence and have Software Development experience.
• Expertise in Extracting, Transformation and Loading (ETL) data using various tools including Bulk insert (BCP), Import/Export data, DTS packages and SQL server Integration.
• Excellent experience of managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Experience inData warehousesuch as dimensional modeling,Star/Snowflake schemas, Data marts,fact and dimension tablesidentification andOLAP.
• Expert in writing T - SQL, working onDTS, SSIS, SSRS, SSAS,and Data Migration projects.
• Expert in creating Cubes and Implementation of perspectives, partitions, aggregations, roles, DVS, calculated members, calculated measures.
• Expert in Extraction, Transforming and Loading (ETL)data flows using SSIS; creating mappings/workflows to extract data fromOracle, SQL Server and Flat File sources, legacy systems and load into various Business Entities.
• Expert in Creating Indexes, Views, complex Triggers, effective Functions, and appropriate stored Procedures to facilitate efficient data manipulation and data consistency.
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages.
• Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Expertise in generating report usingCrystal Reports, SQL Server Reporting Services(SSRS)andExcel spreadsheet, scheduling and deployingreports on report manager.
• Experience in Data Modeling skills using MS VISIO and ERWIN.
• Excellent verbal/written communication skills and strong analytical abilities, and can perform well both independently and as a team player.

TECHNICAL SKILLS

• MS SQL Server 2012/2008/2005/2000
• Composite 6.1
• Oracle 10g
• MS Access
• SQL
• Transact-SQL(T-SQL)
• PL/SQL
• C
• C++
• HTML4.0
• XHTML1.1
• XML
• ASP.NET
• VB.NET
• C#.NET
• JScripts
• JDBC
• VBScripts
• MS SQL Server Integration Services(SSIS)
• MS SQL Server Analysis Services(SSAS)
• MS SQL Server Reporting Services(SSRS)
• SQL Profiler
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• Visual Studio 2008/2005
• DTS
• SQL Developer
• ERWIN
• MS Project
• Crystal Reports 8.5
• MS VISIO 2003
• IIS
• UML
• Windows Server-2003/NT/XP/2000
• Windows Vista
• MS DOS
• UNIX
• BCP.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL Server BI Developer

Responsibilities:

• Successfully setup of composite Environments along with load balancing following ITIL process for implementing Composite Environment.
• Migration of Composite repository from MYSQL to Oracle.
• End to End Implementation of Composite Information Server Environments on Linux Servers.
• Expertise in creating and maintaining Database objects, Tables, Stored Procedures, Triggers, Views, Functions, DTS, SSIS,SSRS.
• Experienced in Analysis, Design, Development and Performance tuning and troubleshooting for OLTP databases.
• Good Knowledge of Extract Transform and Load(ETL) packages(SSIS), package building and deployments.
• Experience in creating Master and Child packages, Error handling, package Configurations and logging, Derived columns expression in SSIS.
• Made Improvements in Existing ETL packages.
• Excellent knowledge of using Variables and Expressions in packages.
• Installation of patches for Composite Environment.
• Working knowledge of Service oriented architecture, Composite Applications, XML Transformation and BI data Extraction Techniques.
• Experience in writing VB Scripts in Script Component Task.
• Hands on Experience in designing complex both Enterprise and Adhoc Reports using MS SQL Server Reporting Services (SSRS) 2008/2005 from OLTP and OLAP data Sources.
• Troubleshooting and resolving the entire database build errors in TFS 2010.
• Analysing Sources and migrated to SQL Server by creating database, tables, indexes, views, complex Stored procedures.
• Created dynamic reports about the daily report server’s refreshment for management.
• Designed SSIS Packages for automatic data migration to transform data from SQL Server 2008 to SQL Server 2012.
• System was developed in SQL Server 2008 and made extensive use of SSIS for the movement of information to and from the mainframe system.

Confidential, Richmond, VA

SR ETL/SQL Server BI Developer

Responsibilities:

• Successfully installed and configured the MS SQL 2008.
• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data. Multi Dimensional Expression (MDX) to access them.
• Implementing Facts and dimensions for providing views of large sets of data..
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Developed report specifications, created and modified reports using SSRS 2008.
• Scheduled reports and exported in PDF, Word and Excel format.
• Created OLAP Cubes from the integrated data and generated reports on those cubes.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Design and develop crystal reports.
• Worked on error handling a module consisting of data from bank, transactions, currencies, countries, master, static etc.
• Worked on the dirty source data that resulted in errors.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.
• Actively participated in meetings and checked for the development of the project.
• Documented the project work and process.

Confidential, Los Angeles, CA

MS SQL/BI Developer

Responsibilities:

• Involved in interpreting client requests to generate daily data reports.
• Used ETL tool for transferring data between database servers within a Local Area Network.
• Provide Data management and data migration among database servers.
• Involved in analyzing problems with data set reports and discussing ideal solutions.
• Involved in Quality Assurance checks on Data retrievals on a daily basis.
• Responsible in monitoring and performing high quality administration of large scale database in an Enterprise environment.
• Performed “pivot” operations on relational and data warehouse, dimensional and fact table for Business analyst.
• Responsible in interpreting business requirements and providing intuitive technical solutions.
• Completed all assignments within a schedule timeframe in a team environment.
• Created SSIS solutions to solve complex business problems using ETL and Business Intelligence.
• Validated reports to ensure quality of data and conducted Meetings with business users to review reports and obtain continuous feedback.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other T-SQL code to implement business rules.
• Wrote T-SQL queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Actively participated in the meetings and checked the progress of the project.
• Documented the developed work.

Confidential, Berkeley Hills, CA

SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Upgraded SQL Server databases to latest version 2005 from SQL server 2000.
• Involved in Database maintenance plan and Implemented replication. Designed and implemented data access stored procedures and triggers for automating tasks.
• Involved in Performance tuning, Query Optimization and extracting data using SSIS from OLTP to OLAP. Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries.
• Developed SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Managed and coordinate with remote user for change request and optimization of application.
• Scheduled jobs, alerts and designed and implemented user log in and security.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Actively participated in the meetings.
• Documented all work so that the user can easily understand the flow of the process.

Confidential

MS SQL DEVELOPER

Environment: MS SQL Server 2000/7.0, Windows Server, DTS, SQL Reporting Services, Windows NT.

Responsibilities:

• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS, Stored Procedures and Views).
• Involved in developing the SQL code for the application
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP, DTS and Indexes.
• Analyzed the Reports, Tables and ETL process.
• Created and automated regular Jobs such as Daily/Weekly Report Generations.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.
• Managed and Monitored System Utilization. Managed Backup and Disaster Recovery of the systems. Managed the security of the servers as a part of administration duties.