SUMMARY

• Overall 7 Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2012/2008/2005 , SSIS, SSAS and SSRS in various business domains.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Good working experience in Management Studio, Enterprise Manager, T - SQL, and SQL Jobs.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Excellent in High Level Design of ETL - DTS Packages & SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Derived Column, Multicast, Data Conversion, Conditional Split, Bulk Insert, Merge Join, Lookup, Pivot, Slowly Changing Dimensions, and union all.
• Good understanding of Microsoft Reporting Service(SSRS)with Report authoring, Report management, Report delivery and Report security.
• Experience in developing Custom Reportsand different types of Tabular Reports, Matrix Reports, Ad hoc reports via Report Model and distributed reports in multiple formats usingSQLServerReporting Services(SSRS) in Business intelligence development studio (BIDS).
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes in SQL Server Analysis Services (SSAS)
• Proficient in Error handling, debug coding issues and troubleshoot production problems and also experienced in taking Backups, managing alerts, Operators and Jobs through SQL Server Agent.
• Researched and worked on creating reports using Tableau to improve the visualization for the end users.
• A motivated, highly organized individual and enthusiastic team coordinator with excellent communication, analytical and problem solving skills. Strong organizational skills.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL-SQL, ASP.NET, C, C++, SHELL SCRIPTING

RDBMS: MS SQL SERVER 2012/20, MS ACCESS,Oracle 9i, Oracle 11g

Database/BI Tools: SQL Server Integration Services (SSIS), SQL ServerReporting Services (SSRS), SQL Server Analysis Services(SSAS)Business Intelligence Development Studio (BIDS), VisualStudio

Packages: MS office, Microsoft Office Suit, Microsoft Office SharePointServer (MOSS) 2007

Web Technologies: HTML, XML, CSS and Java Script

Reporting Tools: SSRS, Tableau

Analytic Tools: Adobe OMNITURE Site catalyst, Google Analytics

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Sr. SQL BI Developer

Responsibilities:

• Worked with business gathering requirements.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Deployed the created SSIS packages in Development and Testing environments.
• Created Linked Servers to retrieve data from other databases.
• Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, Business Intelligent Integration Services (SSIS 2012/2008), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Performance Point Server 2007, MS Excel.

Confidential, Denver, CO

Sr. MS BI Developer

Responsibilities:

• Administration and Support in Multiple Data Centers including Production, Stage, Test and Development Environment
• Installation and maintenance of MS SQL Server 2012/2008 R2
• Design and creation of SQL Database, Tables, Indexes, and Views
• Create Stored Procedures, Triggers and Functions for the Application, and Extensive testing on the Performance of the Stored Procedures
• Experience in creating complex SSIS packages using proper control and data flow elements
• Worked with different sources to extract the data like Flat File, Excel, OLE DB, and Raw File and loaded the data into different destinations like OLE DB, Flat File and Excel Destination
• Generated Tabular Reports using SQL Server Reporting Services (SSRS)
• Created the Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate and Lookups Functions
• Designed SSIS packages for the Automatic Data Migration to Transform Data from the SQL server 2000 to SQL server 2012
• Extensive use of Stored Procedures and Writing new stored procedures and modifying existing ones and tune them such that they perform well
• Worked with Configuration Files and Parameterization in SSIS
• Managed Logins and User accounts, including assigning Database Object Permissions and Privileges
• Created various SQL functions, Stored Procedures, and Views to optimize Database Performance
• Enforced the Business Rules to filter bad data from the system by using Complex T-SQL Statements, and implemented various Constraints and Triggers for Data Consistency
• Identification of all necessary Business Use Cases from requirements, created UML Diagrams including Use Cases Diagrams, Activity Diagrams, and Web Page screen shots using MS-Visio
• Created the Report Models for Ad-Hoc Reporting Analysis and developed Queries for generating Drill-down Reports in SSRS 2012
• Experience in different Report Layouts and Dashboards consisting of Grids and Charts
• Designed transformation rules and processes to derive the correct data from the extracted data and transform into the required format and structure to support the business requirements
• Extensively worked with different control flow tasks such as Execute SQL Task, Data Flow, Execute Package, File System Task, Script Task, Send Mail Task and different containers like For Each Loop and Sequence Container
• Created Dimension and Fact Tables and Loaded Corresponding Data
• Experience on Slowly Changing Dimensions and Change Data Capture
• Created Different Methods of Logging in SSIS
• Responsible for ETL operations using SQL Server Integration Services (SSIS) and worked with users in and support
• Monitoring performance and optimizing SQL queries for maximum efficiency

Environment: MS SQL Server 2012, MS SQL Server 2008 R2, T-SQL, SSIS, SSRS, SSAS, Visual Studio, MS Visio, Mingle.

Confidential, Denver, CO

SQL Server Developer/ SSIS Developer

Responsibilities:

• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Used to work on Installation, Configuring, Managing, Monitoring, Troubleshooting SQL Server 2008R2/2008/2005 on VM Ware Clustered and Standalone Environments
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Used ASP.Net coding and C# to call the Stored Procedures created with T-SQL
• Used XML and XSLT
• Extracted data from Txt/CSV/XML/Oracle/Sybase/DB2 to SQL server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created SSIS packages for data Importing, Cleansing, and Parsing. Extracted, cleaned and validated.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house by using BIDS.
• Built Cubes with Multi Dimensions and made proper Hierarchy Relationships on Attributes. Made Partitions on Cubes with Aggregates for better Performance.
• Worked in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Prepared various Reports by using Queries and the Data existed in the Cube for Analysis Purposes of the Organization.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Extensively worked on Dimensional Modeling.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports in BIDS.
• Deploying and scheduling Reports using SSRS/Crystal to generate all daily, weekly, monthly and quarterly Reports including current status.
• Expert in automating process by Using SQL Server Agent in creating jobs and error report using Alerts, SQL Mail Agent and SMTP.
• Handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs, Backups and restores.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: Windows 2005 R2, 2007, 2008 MS SQL Server 2003/2005/2005 R2, BIDS, Oracle, .net, Power Designer, Microsoft Outlook, Red Gate, Team Foundation Server, SSIS, SSAS, SSRS.

Confidential, West Haven CT

SQL Server Developer

Responsibilities:

• Designed and developed database infrastructure.
• Developed the databases for the individual departments of the hospital and the central database, which contains information about all the departments.
• Created ER diagrams (physical and logical using Erwin) and mapping the data into database objects.
• Normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Involved in Migration and support of application database from SQL Server .
• Written Complex and Extended Stored Procedures for application developers and some User Defined Functions.
• Used Validation Controls in ASP.NET for validating user inputs.
• Created After and Instead of Triggers to enforce data consistency and referential integrity.
• Created Views, Parameterized Views, Partitioned Views and Indexed Views.
• Created Clustered and Non Clustered Indexes on tables, views, and columns.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Created Packages using SSIS to transfer the date from flat files to data warehouse system.
• Migrated Microsoft Analysis Services to SQL Server Analysis Services (SSAS)
• Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs.
• Wrote MDX scripts to create named queries and calculations.
• Created and administered OLAP cubes (33+ cubes spanning various subjects) on the SQL Server Analysis Services platform using the star schema Method.
• Migrated report system from a custom Crystal Reports system to SQL Server 2005 Report Services. Generated reports by using Repots using SSRS.
• Redesign/ Deploy reports using Report Services 2005.
• Created report models for Report Builder and managed reports using Report Manager.
• Involved in creating Technical Specification Document (TSD) for the project.

Environment: SQL Server EE, Erwin 4.5, SSRS, SSIS, SSAS, ASP.net Crystal Report 10, Windows 2003 Server, MS OLAP, T-SQL, Windows Application, Enterprise Manager, Query Analyzer.

Confidential, Atlanta, GA

MS BI Developer

Responsibilities:

• Worked in Financial Domain in the company in creating SSIS packages and SSRS reports.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2000.
• Created DTS packages to transfer objects from development server to production.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and Maintained Snapshot Replication across multiple server environments.
• Setup and maintained Linked Servers.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in creating Cubes using SQL Analysis Services (SSAS).

Environment: MS SQL Server 2008 R2/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports.