SUMMARY

• Over 8+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 in Development, Test and Production Environments on various business domains like Financial, HealthCare, Retail, Banking and Insurance
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• In - depth knowledge of T-SQL, OLAP, BI suite, Reporting and Analytics.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience with Adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Worked Extensively on ETL process using SSIS package.
• Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms.
• Experience in Performance Tuning and Query Optimization.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent and schedule DTS/SSIS Packages.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Expert in creating Parameterized Reports.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

Databases: MS SQL Server 2012, SQL Server 2008, 2005 & 2000MS Access 2000/2003/2007 , MySQL, Oracle 9i,10g

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Profiler, DTSSSIS, SSRS, SSAS, Business intelligence Studio, ODI, TOAD

Languages: C++, VB, XHTML, XML, C#, T-SQL, .NET, UML

Operating Systems: Windows 2003 Enterprise, Windows NT, Windows Vista, Widows 7

Other Tools: Erwin, ER Studio, Microsoft Visual studio 2003/2005, Microsoft Visio, Microsoft Office, Crystal Reports Architecture Relational DBMS, Client-Server Architecture

PROFESSIONAL EXPERIENCE

Confidential, MN

SQL/ ETL Developer

Responsibilities:

• Worked with SQL server management studio for creation of databases and tables
• Involved in data modeling of tables and also involved in design of dataflow from different tables
• Designed and developed SSIS packages to transform data from different servers
• Involved in data gathering according to client requirements following the data needed by the client
• Used SSIS to create ETL packages to extract data from one server and load into another server
• Involved in creating various packages for SQL and flat file destinations
• Involved in using various transformations like Execute SQL task, Multicasting, Merge Join, Look Up, Script Task, Send Mail Task etc
• Involved in copying tables from one server to another server for code translation tables using script tasks
• Reporting issues that are reported on data and making changes to flow of data
• Generating flat files after data flow is done and sending it to Reeher for further testing
• Involved in manual testing at the time of developing packages in order to verify whether dataflow is going good
• Involved in planning the project and keeping deadlines to meet certain tasks and send files to Reeher
• Involved in creating linked servers and utilizing the linked servers in packages for smooth flow of data and avoid the complexity
• Involved in setting up FTP task for sending files to Reeher once the package is executed successfully
• Involved in moving packages from one location to other using Package Configuration

Environment: MS SQL Server 2008 R2, MS SQL Server 2010, Integration Services (SSIS), Import/Export Wizard, SQL Server Management Studio, T-SQL, Window XP, Windows 8, Visual studio 2010.

Confidential, Topeka, KS

SQL/Oracle Developer

Responsibilities:

• Worked in CORE team, which acts as repository for Data warehouse which acts as source of data for many downstream teams
• Worked on bugs that are related to different teams and involved in a process of fixing them
• Worked with SQL server and TOAD for Oracle for different sources for pulling up the data
• Worked on Rep Errors stated as errors that were pushed to special tables in every nightly cycle
• Involved in fixing the Rep Errors by checking them for possible ways for errors and fixing them
• Involved in setting up domains in SQL for missing domains that are observed in Rep Errors
• Involved in Issue solving for the team that are reported by various downstream teams by finding the ways to fix them
• Involved in Code changes and ETL changes for some issues that are involved with issues or teams that are requesting to add columns to the tables
• Involved in updating the records in both SQL and ORACLE by raising requests for changes in Production
• Worked with offshore team in order to refresh the records or in solving the issues faster
• Worked with ETL process called as DPU ( Data Process Utility) for nightly cycles and also to check for any records that are involved with Rep Errors
• Worked with Production Support teams in order to set up domains for new funds and other type codes
• Worked on TFS to track the status of issues and tasks to be worked in sprint
• Reporting issues that are dealing with source system and tracking them for change of data or data clean up
• Used CORE Admin tool in order to refresh data that didn't make to destination table or for loading records from Rep Error tables once the domains are set up
• Creating temporary tables with data for other teams in the down streams to test the data

Environment: MS SQL Server 2008 R2, MS SQL Server 2012, Integration Services (SSIS), Import/Export Wizard, SQL Server Management Studio, T-SQL, Report Builder, Window 7, visual studio 2008.

Confidential, Minneapolis, MN

ETL/SQL Developer

Responsibilities:

• Transformed data from different data sources like different data bases to SQL Server 2008 using OLE DB connection providers by creating various SSIS packages. Data is transformed to data warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for large business users.
• Created pre aggregated business required multi-dimensional calculations in SQL Server Analysis Services cubes (SSAS).
• Writing Multi-Dimensional expressions (MDX) for querying the SSAS cubes.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational, drill-down and drill-through reports using SSRS.
• Worked on Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Migrated all Data Transformation Services (DTS) packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Translating business requirement into Database objects.
• Helping the business team members
• Assisting the structural and specialized designs of the schemes to make sure that the judgments are being made in accordance with the existing and forthcoming business plans of actions and chances.
• Coordinating with the end user gathering to ameliorate the overall individual architecture expertise
• Recognizing different matters and collecting and writing down the needs and actions of the scheme plans
• Helping the enhancement of ETL request teams
• Involved in Installing and Setting up SQL Server 2008 R2 and SQL Server 2012 on application servers
• Involved in Installing Microsoft Visual Studio 2008 and SQL Server Data Tools(SSDT) on client system
• Involved in restructuring the existing SQL tables according to client requirements
• Worked with Cosmos application in order to generate tickets for working with SSIS packages
• Involved in installation of source control in order to open/close access to packages and tables that are involved with SSIS packages
• Performed SQL alert for various SSIS packages
• By using Deployment utility the deployment manifest file created to deploy the packages in the production server.
• Package Configuration XML files has created to configure the package with server, database and credential details.

Environment: MS SQL Server 2008 R2, MS SQL Server 2012, Reporting Services (SSRS), Integration Services (SSIS), Import/Export Wizard, SQL Server Management Studio, T-SQL, Report Builder, Window 7, visual studio 2008.

Confidential / Los Angeles, CA

Lead MS BI (SSIS/SSRS/SSAS) ETL/SQL Developer

Responsibilities:

• Installed SQL Server 2008 and Microsoft Visual Studio on application server
• Worked with SQL Server Studio for creation of database and tables
• Designed and developed SSIS packages to transform data from Excel and ERP to SQL destination using BI.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to one database to another databases and process SSAS cubes
• Designed SSAS cubes for all the developed DataMart models and identify measures with proper aggregate functions applied.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters.
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Involved in creation of Stored Procedures
• Involved in scheduling jobs for SSIS packages
• Performed Importing and Exporting data from One database to another
• Responsible in Package Integration and System testing of Packages
• Involved in using various transformations like Conditional Split, Data Conversion, Derived Column, Export Column, Fuzzy Lookup, Merge Join, OLE DB Command.
• Involved in working with Control flow items like Different types of Containers, Execute SQL Task, File System task, Script task, Send Mail Task etc.
• Involved in creation of various testing scenarios for SSIS packages and documented them.
• Developed scripts using script task using Microsoft Visual Basic 2008 according to clients requirements.
• Updating SSIS packages according to users requirements
• Identified issues and Contributed in making changes to the system there by resolving issues and implementation of solutions
• Deployed packages into server
• Backing up Stored Procedures and SSIS packages

Environment: Windows 2003/2000, XP, MS SQL Server 2012, SQL Server 2008,SSIS, SSRS,SSAS,SQL Server Analysis Services, T-SQL, SQL Query Analyzer, IIS (5.0), Power Designer, Visual Studio 2005,T-SQL, Windows Server

Confidential, Westport, CT

Lead MS BI (SSIS/SSRS/SSAS) ETL/SQL Developer

Responsibilities:

• Installed and Configured SQL Server 2008 on application server in development and testing.
• Gathered requirements from Sales department and interact with business owners and documented them based on functional specification.
• Responsible to ensure the validation of the SSIS packages with the BA, DBAs, QA auditors, and Developers.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Representation for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Developed ETLs architecture via MS SQL Server Integration Services (SSIS).
• Participate in integration and system testing.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.
• Involved in creating relationships and hierarchies between attributes and measure groups and defined granularity with in a measure group and drill through actions in SSAS (SQL Server Analysis Service).
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Developed the chart type, tablix, matrix reports in SSRS (Sql Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• Contribute to system architectural design and planning discussions.
• Identify issues and recommend and implement solutions.
• Gathered requirements from users and interact with business owners and documented them based on functional specification.
• Create mapping document based on VIP records and users requirements.
• Responsible to ensure the validation of the creating tables, stored procedure, and SSIS packages.
• Developed ETLs architecture via MS SQL Server Integration Services.
• Implemented SSIS (ETL) to extract and transform data from Oracle RDBMS, Teradata and Flat files/CSV, SQL Server 2005 instances and to load into staging and then to DW
• Participate in integration and system testing.
• Documented all the UTP, SSIS packages, SQL and Tidal job schedule.
• Developed SQL agent job in TIDAL scheduler to execute SSIS package.

Environment: Windows 2003/2000, XP, SQL Server 2005, SQL Server Integration Services (SSIS) 2005, SSRS, SSAS,SQL Server Analysis Services, T-SQL, SQL Query Analyzer, IIS (5.0), Power Designer, Visual Studio 2005,T-SQL, Oracle, Windows Server

Confidential, Sunnyvale, CA

MS BI (SSIS/SSRS/SSAS) ETL/SQL Developer

Responsibilities:

• Responsible to ensure the validation of the reports with the Business Analysts, DBAs, QA auditors and Developers.
• Performed database management and address internal database configurations (tables, reports) and configurations between systems.
• Primary source of contact for any reporting needs for Air Wisconsin Airlines IT department and other internal users.
• Played a major role in production support of SSRS jobs.
• Support the data warehousing MDM project to facilitate the merger process of regional airlines.
• Responsible for gathered the requirements from the internal users of the Air Wisconsin team to meet their reporting needs and subscribe them with the appropriate authority.
• Developed database objects providing ad-hoc SQL scripts, stored procedures, Functions, and Triggers using T-SQL.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Used SQL Server 2008 Integration Services to extracted data from flat file, and Excel spreadsheet to transform data and load the result into operational data store (ODS).
• Worked on Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Updates and inserts of records into data warehouse dimension tables using SCD type I and type II in SSIS.

Environment: MS SQL Server 2005 Enterprise Edition, MS SSIS 2005, SSRS, SSAS DTS, T-SQL, Windows Server 2003, Oracle, and Microsoft Visio.

Confidential, Newport Beach, CA

MS BI (SSIS/SSRS/SSAS) ETL/SQL Developer

Responsibilities:

• Responsible for job flow processes for client data added to the database.
• Enforced data entry guidelines to created consistency among users.
• Make recommendations for upgrading and maintaining software applications.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Performed in-depth diagnosed on abnormal conditions, and use expertise and experience to take corrective action to resolve problem. If uncertainty existed about what type of corrective action to pursue, ensure management or more experienced personnel are involved.
• Worked as a database designer and developer on databases like MS SQL Server 2005 using T-SQL, stored procedures and views.
• Designed small data marts and then integrated them together to form a Data Warehouse.
• Used Erwin for designing and also wrote the technical documentation for the whole project single handed.
• Made decisions on the naming conventions to be used for the purpose of designing the data warehouse and also helped to improve the performance of the database by doing performance tuning.
• Developed complex T-SQL code for the application.
• Modified the existing database by adding the tables and relationships to the tables.
• Performed Data Cleansing is creating new tables for the loading of Data in SSIS.
• Involved in the migration of DTS packages to SSIS packages.
• Involved in performing incremental loads using SSIS packages.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Created reports that call Sub reports in SSRS
• Developed measures and dimension members using multi dimensional expression (MDX) to meet additional needs that were calculated from existing measures.
• Developed MDX for cube calculations
• Implemented the calculations to aggregate physical measures using management studio.
• Defined d relationships with the measure groups and fact tables.
• Optimized long running stored procedures and Queries for effective data retrieval
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer.
• Setup and maintain daily, weekly and monthly backups. Restored files at the request of users or management.
• Maintained daily server backups of databases and ensure successful completion.
• Completed any other duties pertinent to the position as assigned by supervisor.
• Worked collaboratively with help desk staff to address user tickets and time-sensitive technology issues.
• Created and implemented design upgrade to database.
• Assisted others in problem resolution and technology troubleshooting on as-needed basis

Environment: MS SQL Server 2005 Enterprise Edition, MS SSIS 2005, SSRS, SSAS, DTS, T-SQL, Windows Server 2003, Microsoft Visio

Confidential, Iselin, NJ

MS BI (SSIS/SSRS) ETL/SQL Developer

Responsibilities:

• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal Process.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.
• Developed an automated report subscription process using SSRS.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Created report links to refer other reports in a particular report.
• Resolved any deadlocks issues with the Databases/Servers on a timely basis.
• In-Depth working knowledge of ODBC.
• Handled Underwriting and pricing of renewal accounts within underwriting authority for
• Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.
• Created multiple hierarchical aggregates for faster performance.
• Installed SQL server 2000 on Windows 20003 servers and involved in Physical and logical Database Design using Erwin tool.
• Developed an automated report subscription process using SSRS.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Created database objects like tables, users, roles, stored procedures, triggers.

Environment: SQL Server 2005, Windows 2000/2003,MS Access 2000/2003,T-SQL,Windows 2000 Advanced Server, SQL Server Integration Services (SSIS)

Confidential

ETL/SQL Server Developer

Responsibilities:

• Developed the Functional Specifications documentation and the traceability to the corresponding business requirements with Requisite Pro and updated the BRD document.
• Developed business and system use-cases with activity, sequence and class diagrams using UML and corresponding test plans.
• Used Rational Requisite Pro to document organizes, track and manage the evolving requirements.
• Used Vision document as a template to define the feature requirements. Communicated the requirements effectively to all stakeholders.
• Built advance reports such as Cargo Capacity Report and Range of each Transport Reports using report designer in SQL Server 2005 Reporting Services.
• Added drill down ability, totaling, grouping, multi-value parameters, queried data sets, and conditional formatting using IIS function.
• Used SQL Server 2005 Integration Services to extracted data from flat file and Excel spreadsheet to transform data using data conversion transformation, derived column transformation, lookup transformation and to load the result into operational data store (ODS).
• Used SQL Server 2005 Integration Services using slowly changing dimension (type I, type II, and type III) for updating and inserting of records into data warehouse dimension tables.
• Maintained user/groups access and security permissions in accordance to policies and procedures using Integration Services.
• Worked with SQL Server management Studio to created tables, setup data types assign primary and foreign keys and define cardinalities.
• Participated in designing multi-dimension model (star schema and snowflakes schema), prepared ETL standards.
• Worked with part of Java Coding in Eclipse Environment and worked on GUI's

Environment: SQL Server 2000,T-SQL, SSIS, SSRS, Query Analyzer, SQL Profiler, SQL - Database Tuning Advisor, SQL Performance Monitor, Core Java, Windows OS