SUMMARY

• Over 8 Years of extensive experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL Developer with expertise in SQL Server Integration, Analysis and Reporting Services.
• Experienced in extracting, transforming and loading the data using SSIS in SQL Server 2005/2008/2012
• Migrated data using SSIS, DTS wizard (Data Transformation Services) tool through data flow tasks, look up transformationsand script tasks.
• Developed database objects such as tables, views, stored procedures, triggers, row - level audit tables, cursors, indexes, user-defined data-types, functions and constraints
• Expert in debugging an application using the debugging tools provided by the Visual Studio .Net IDE.
• Proficient in OLTP, OLAP and data warehouse design concepts, experienced in relational, multi-dimensional (Star) and snowflake, logical and physical data modelinganddata mapping
• Experienced in MS Analysis Services (SSAS) programming for data warehouses (Schemas), proficiency in data warehousing techniques for data cleaning, slowly changing dimension phenomenon
• Proficient in processing OLAP cube, creating KPIs, dimension usage, calculated members, perspectives and hierarchies
• Creation of database objects liketables, views, materialized views, procedures and packages using oracle tools likeToad, PL/SQL Developer
• Performance tuning in cube by creating storage modes (MOLAP, ROLAP and HOLAP), aggregations, usage based optimization, besides providing security by providing perspectives
• Extensive experience in reporting tabular forms, matrix (cross tab report) form, conditional, list items, charts and sub reports
• Experience in database architecture, design, coding, implementation and production support

TECHNICAL SKILLS

Programming Languages: C, SQL, TSQL, PL/SQL

RDBMS: MS-SQL Server 2000/ 2005/2008/2012 , Oracle 9i/10g, Microsoft Access

IDE Tools: Visual Studio.Net 2005/2008/2012

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008/2012 , DTS

OLAP Tools: SQL Server Analysis Services (SSAS) 2000/ 2005/2008/2012

Reporting Tools: SQL Server Reporting Services (SSRS) 2000/ 2005/2008/2012 , Crystal Reports, Cognos Framework Manager, Report Studio

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Teradata, Query Analyzer

Markup Languages: XML, HTML, DHTML

Data Modeling: ERWIN, MS Visio, Informatica.

PROFESSIONAL EXPERIENCE

Confidential, Monterey, CA

Sr BI Developer/Data Analyst

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Worked on RDBMS database management system to create and maintain the Databases.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Created indexes for the fast retrieval of data from the database.
• Created and designed reports based on query parameters and Report parameters
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Scheduling and monitoring the ETL packages for daily load in SQL Server job Agent.
• Did Unit Testing of the Deployed Reports.
• Documented Business Requirements and Technical Specs for the Report.

Environment: Windows 7, Oracle, SQL Developer 3.2, Java Eclipse SVN, Cygwin64 Terminal, SQL Server 2012.

Confidential, Dallas, TX

Sr. SQL Developer

Responsibilities:

• Interact with business users to gather required information for developing reports and SSIS packages
• Automated ETL Data loads and established efficient ways of Error Handling in SSIS, Implemented Event Handlers,
• Package Configurations, Logging, System and User-defined Variables, and ExpressionsforSSIS Packages.
• Created functions and developed procedures to implement application functionality at the database side for performance improvement, involved in Performance tuning of Queries, Indexes and Stored Procedures using SQL Profiler.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008R2
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform drill down, drill-through operations in SSRS 2008R2
• Developed reports using global variables, expressions and functions
• Created SSRS projects and datasets, Object visibility and report actions.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Created/edited sales job module in SQL Agent in development and participated in production deployment.

Environment: SQL Server 2008, SSIS, SSRS, SQL Server Management Studio, T-SQL, ETL, Visual Studio 2008R2.

Confidential, Brecksville, OH

Sr. BI Developer

Responsibilities:

• Worked in creating complex StoredProcedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2008 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked with development teams in the design of physical databases and in modification.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role

Environment: MS SQL Server 2008 R2, BIDS,SSIS, SSRS, SSAS, Business Objects.

Confidential, Plano, TX

SQL Server/ BI Developer

Responsibilities:

• Migrated very complicated Actuate reports into SSRS 2005 and SSRS 2008 which are some not able to migrate but used many work around techniques to migrate this complicated reports
• Created many new reports according to the business user requirement with includes complicated expressions and tables with as many as 36 fields in the reports
• Perform unit testing at various levels of the Reports
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2005
• Written complex Stored procedure according to the business requirements for reporting purpose
• Designed & developed the various SSIS packages for the Weekly & Monthly Loads from business users in different locations in United States
• Managed the ETL processes between various environments through scripts utilizinglinked servers, DTS packages and SSIS
• CreatedSub Reports, Parameterized and Drill down Reportsbased on the requirements provided
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables
• Converted Non-Unicode data from different databases into Unicode data and move the data to staging databases
• Involved in understanding Business and data needs and analyze multiple data sources and document data mapping to meet those needs.

Environment: SQL Server 2008/2005 SSIS, SSRS, SQL Server Management Studio, T-SQL, ETL, Visual Studio 2008R2, .NET.

Confidential, Plymouth, MN

SQL Server/BI Developer

Responsibilities:

• The project is designed in two phase’s data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server ReportingServices (SSRS) platforms
• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads last 4 days data from oracle into SQL Server database to store consistent and durable data
• ETL development of moving SSISpackages from 2005 environment on to 2008 with new transformations
• Built new SSIS Packages incrementally loading data dynamically on to SQL Server destination tables from different OLEDB, Flat File, .TXT and Excel files
• Deployed SSIS packages by creating configuration files making packages dynamic by creating variables
• Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages, extensively worked on mappings, incremental data loading, andSSIS transformations
• Created the dimensional & relational models for various databases for monitoring tools, created database, SSIS standards of development, configuration & deployment of the Packages.
• Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads

Environment: SQLServer 2012/2008, Windows 2007/2003, MS Access 2000/2003, T-SQL, Windows 2000 Advanced Server,SQLServer Integration Services(SSIS), SSRS,.NET.

Confidential, Dallas, TX

SQL Server/ BI Developer

Responsibilities:

• Extracted data from different OLEDB sources, flat file, and excel destinations with major transformations loaded on the SQL Server destination tables
• Created SSIS packages to migrate data from Oracle to SQL Server 2008
• Responsible for coordinating the implementation of the application and conversion for various Excentus retail markets
• Created and scheduled SQL jobs to run SSIS packages on a daily basis using MS SQL Server Integration Services (SSIS) on incremental loading
• Performed data conversions from normalized database structure into flat files by using BCP import/export utility along with global temporary tables
• Published migrated data using SSIS, DTS wizard (Data Transformation Services) tool through data flow tasks, look up transformations and script tasks
• Responsible for scheduling the subscription reports with the subscription report wizard
• Worked with various SSIS tasks including execute SQL task, for each loop container, file system tasks
• Created user defined functions to encapsulate frequently and commonly used business logic

Environment: SQLServer 2008, Windows 2007/2003, MS Access 2000/2003, T-SQL, Windows 2000 Advanced Server,SQLServer Integration Services(SSIS), SSRS,.NET.

Confidential

SQL Server BI Developer

Responsibilities:

• Creating SSIS packages to gather data from various sources (mainframe, Informix, Oracle)
• Improving SSIS packages for better performance by reassigning the transformations
• Created DTS packages for loading data from desperate system to porters
• Installed, upgraded and migrated databases from Oracle to MS SQL Server 2008
• Designed ER diagrams and mapped the data into database objects
• Involved in Normalization to 3F for OLTP system and some De-Normalization for OLAP system
• OLAP with the various applications to analyze the data for clients i.e. excel, reporting services
• Experience indeveloping and extending OLAP Cubes,dimensions and data source views
• Wrote SQL scripts to insert/update and delete data in SQL database
• Converted existing PL/SQL stored procedures, triggers, functions and script to T-SQL
• Created schemas, views, stored procedures, triggers and functions for data migration
• Involved in the complete life cycle of the project, from planning stage to pushing the codes to production
• Worked on client/server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server, and Excel and Reporting Services tools

Environment: SQL Server 2008 Enterprise Edition,SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, TFS,XML, and Windows Server 2003.

Confidential

SQL Serve Developer/Business Analyst

Responsibilities:

• Used SQL Server Enterprise Manager and Query Analyzer to administer SQL Server 2000
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults
• Created triggers to enforce data and referential integrity
• Created constraints, defaults, views and indexes
• Created Triggers to enforce data and referential integrity
• Wrote DDL, DML statements for processing of daily activities
• Implementing the calculations to aggregate physical measures

Environment: SQLServer 2000, SSRS