SUMMARY

• Around 8 years of IT experience in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS 2008.
• Experience in dealing with high volume transactional data in SQL
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from /2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Extensive experience in writing Distributed Queries between SQL Servers by creating link servers and federated servers.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Extensive experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS

Languages: Transact SQL, C, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML.

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

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

ETL Tools: DTS, SSIS, Data Stage

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2007/2003/2000

Operating Systems: Windows / 98/2000/2003/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Novato, CA

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Focused more on building SSRS reports for the finance teams and SSIS packages based on the business requests.
• Worked in a team building the new Data warehouse system for the company from the design/planning phase till the end.
• Supported the project at the phases of development along with the Data warehouse Architect.
• Built and maintained 2 databases- one for holding just the current data and the other for holding the complete log as part of the data warehouse.
• Documented for all the reports built and SSIS packages built.
• Scheduled reports and packages to run on daily/weekly basis.
• Monitoring the daily data load and reports status.
• Converted Data Transformation Services(DTS)application to SQL Server Integrated Services(SSIS)as assigned.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like MS access and flat files.
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSISsuch asData Conversion,Conditional Split,Bulk Insert,Mergeandunion all.
• Built a secure paperless method for the technicians to serve the patients by generating Excel Secure Patient List reports by using SSIS packages on their tablets.
• Scheduled Jobs to run once a week to send the report attachment to all the Technicians and General Managers based on their District/Area.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Data cleanup for the historic data in the data warehouse using efficient SQL queries in SSMS 2012.
• Implemented back fill by inserting the data from the past to the current data.
• Implemented logic in inserting the new rows into the table by following a Load Flags.
• Scheduled report and exported in PDF format and Excel Format as desired by users.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Modifying and tuning existing reports.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2012.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Used Tortoise SVN for the version controlling for all the projects I worked on.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager

Environment: MS SQL Server 2012, SSIS, T-SQL, SSRS, TFS, Win 2008 Advanced Server, Tortoise SVN

Confidential, Sunnyvale, CA

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Created SSIS package to load data from Flat Files, CSV files, and SQL Server 2008R2 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Scheduled report and exported in PDF format and Excel Format as desired by users.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2012.
• Developed applications using ASP.NET, C#, VB.NET, and T-SQL on Visual Studio 2005 .Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager

Environment: MS SQL Server 2012/2008, SSIS, ASP.NET, C#,T-SQL, SSRS, TFS, Win 2008 Advanced Server, VSS, Erwin v7.3, HP quality Centre

Confidential, San Francisco, CA

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Key role in team of 4 in brining 2005 SQL database environment to SQL 2008R2 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
• Extensively worked on Data Flow tasks like For each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Developed applications using ASP.NET, C#, VB.NET, and T-SQL on Visual Studio 2005 and 2008
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Deployed and configured the reports in the Report Server.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2008R2 using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with various SSIS packages which involve Transactions, Restartability and roll back techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Server Agent for scheduling jobs and alerts.
• Configuration and Deployment of all reports across various SDLC environments.
• Deployed the packages to production using XML package configuration.

Environment: SQL Server 2012/2008R2/2008/2005, SSRS 2008, SSIS 2008, DB2, Oracle 9i/10g, ASP.NET, C#, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe.

Confidential, Boston, MA

Sr. SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Created complexSQL stored procedures using Microsoft SQL Server 2008 and 2008 R2
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• I worked with .Net development team to write and approve SQL stored Procedures
• Designed many different modules, including data parsing which was develop by using C#
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
• Experience in creating snapshots of static reports and configure subscription.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Lead the team of developers to write efficient code.

Environment: SQL Server 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, ASP.NET, C#, VB.NET, and T SQL, Erwin, MDX, Oracle 10g, ProClarity, MS Excel.

Confidential, Grand Rapids, MI

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Created logging, custom logging and error handling packages.
• Deployed SSIS packages and Reports to Production Servers.
• Designed many different modules, including data parsing which was develop by using C#
• Developed code and support provided for C#.NET, T-SQL, Microsoft SQL Server
• Maintained system monitoring jobs and provide high availability support.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Deployed and configured the reports in the Report Server.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2008.
• Worked closely with IT project managers, programmers, and testers.

Environment: SQL Server 2008 Enterprise Edition, SSIS /SSRS 2008, C#, .Net, T-SQL, VisualStudio.net, XML, MS Excel, MS Access, Visual Studio 2008.

Confidential, Phoenix, AZ

SQL Server SSIS/SSRS Consultant

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Generated database monitering and data validation reports in Proclarity and SQL Server Reporting Service (SSRS).
• Created Datawarehourse Cubes in SQL Server Analysis Service (SSAS).
• Deployed SSIS packages and Reports to Production Servers.
• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Responsible for the design and development of .Net web applications for firm's Solutions.
• Migrated data using ETL Tool in SSIS.
• Maintained system monitoring jobs and provide high availability support.
• Created partition table for very large database for good performance.
• Worked on Migration of packages from DTS using SQL Server Reporting Service(SSIS).
• Participated Databases Architecture and data Modoling design.
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Fully supported change management procedures.
• Reviewed and developed data models and database designs with development teams
• Wrote store procedures for some job automations.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Designed and developed OLAP using MS SQL Server Analysis Services
• Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2000 and SQL Server 2005
• In charge of converting data using SQL Server 2005 using SSIS

Environment: MS SQL Server 2005 and 2000, MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, SSAS, ProClarity, MS SQL Server Analysis Services 2000, C#, ASP.NET,VB.NET, OLAP, UML, Erwin, DTS/SSIS,BIDS.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).
• Developed User Defined Functions and created Views.
• Created Triggers to maintain the Referential Integrity.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.

Environment: SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5.