PROFESSIONAL SUMMARY:

• 8+ Years of extensive IT experience as a Microsoft SQL Server 2014/2012/2008 R2/2005 developer and creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs in different domains like Insurance, Banking, Finance and HealthCare.
• Strong T - SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Expertise in database design, development for OLTP (batch processing, online processing), OLAP, ODS, ETL, MDX, data warehousing and data modeling.
• Experience in migrating DTS packages to SSIS, migrating databases from SQL 2005 to SQL 2008, and troubleshoot migration issues, importing and exporting packages to SQL Server and file system.
• Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
• Strong experience in data analysis and modeling.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Integrity using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
• Experience in database performance tuning and query optimization, data integrity and statistics.
• Excellent experience in design and development of Business Intelligence tools like SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 201 2/2008/2005.
• Experience in developing Custom Reports 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).
• Highly Experience in T-SQL (DDL, DML), documentation, coding, programming and using SQL Server 2008/2012. Used Version control tool Team foundation server (TFS) for the entire development cycle.
• Implemented Data Mining using decision trees, association rules, k-means clustering. Familiarity with Data warehousing and analysis skills such as ETL tools.
• Worked on SQL server 2012. Created packages using SSIS 2012.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2014/2012/2008 R 2/2008/2005.
• Hands on experience in using version control software s like VSS, Rational clear case and (TFS) Team Foundation Server.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive experience with Transact-SQL coding in creating complex stored procedures, functions, views, indexes, user profiles, relational database models, data dictionaries, data integrity and appropriate triggers to assist efficient data manipulation and data consistency.
• Experience in designing highly interactive visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Experience in creating interactive reports using Crystal Reports and SQL Server Reporting Services (SSRS).
• Gather requirements and design of Data warehouse and Data mart entities.
• Experienced in agile environment.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Informatica Power Center

Reporting Tools: SQL Server Reporting Services (2012/2008R 2/2008/2005/2000/7.0 ), MS Access, MS Excel, Crystal Reports

Database: MS SQL Server 2012/2008/2005 /2000, MS Access, Oracle 11g/10g/9i

TSQL, PL: SQL, C, Objective C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL

Operating Systems: Windows (95/98/2000/2003 ), Windows 2007 Server, Windows XP, Windows Vista, 8.1, 10, Mac 10.X

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio, MS Project), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

MS SQL Server SSIS/SSRS/ETL Developer

Responsibilities:

• Responsible for writing T-SQL programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Work with business users to get the requirements and write the code.
• Created cross reference tables and ETL routines to standardize the data coming from multiple sources
• Optimizing the code using native tools like execution plan and query analyzer.
• Involved in ETL Architecture, Developing Source to target data mapping (STDM) document defining transformation logic.
• Worked on interface process, which downloads the file from Client FTP and process the applications in production database based on the requirement.
• Translated business logic to transformation logic to generate pseudo code for the ETL process
• Created packages using SSIS 2012 for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Involved in Data migration, data cleansing and writing the retro to fix the existing effected data.
• Worked on Visual Studio 2012 and Synced/loaded projects with TFS 2010.
• Used transformations like Lookup, Aggregator, Sort, Derived Column, Union All and OLE DB Command to implement the transformation Logic and load the target tables.
• Developed the logic to Capture the Error Rows in the data flow and populate them into an Excel file
• Performance tuning the Stored Procedures used in SSIS Packages
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS 2012.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Scheduled and maintained jobs to perform ETL tasks on daily, weekly and monthly basis.
• Design store proc, view, trigger, function for data ware housing.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Developed 2012 SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Involved in all phases of Data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Set up SQL Profiler to trace various Database activities, Application Responses and their Performance in order to tune them.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created mapping for error handling sessions.
• Designed different type of reports: tabular, matrix (cross tab), conditional, list items, charts and sub reports with different sources.
• Converted Oracle and Crystal reports to SSRS.
• Documented requirements.

Environment: MS SQL Server 2014/2012/2008 R2, MS SQL Server Reporting Services, Crystal Reports, Oracle reports, SSIS 2012, ETL, DTS, Data Modeling, Data Warehousing, Visual Studio 2014/2012/2008 & 2005, SQL Profiler, T-SQL, XML, MS Access, Excel.

Confidential, lake Mary, FL

MS SQL Server SSIS/SSRS/ETL Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2000, 2005, 2008.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created adhoc reports using Import and Export Wizard.
• Handled Tableau admin activities granting access, managing extracts and Installations
• Used Tableau to visually analyze data and create consise and actionable dashboards
• Created backup scripts to take periodic backups for the content on Tableau server.
• Defined group level security standards for Tableau.
• Built connections to/pulling data from AS400, mainframe/db2 and Oracle. Used MS SQL Server 2012 SSIS to create SSIS tasks such as Conditional Split, Derived
• Column, which were used for Data Scrubbing, data validation checks during Staging and before loading the data.
• Pulled the data from multiple database sources such as UDB/DB2/TeraData/SysBaseand flat file sources that include CSV, Excel, and Mainframe (SAS).
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Strong experience in creating and publishing packages in Framework Manager.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008.
• Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS and Created Ad-Hoc Reports, Summary Reports, Sub Reports.
• Used SQL Server 2008R2/2012 Reporting Services (SSRS) for generating reports which resulted in efficient decision-making.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analystand customer Representatives for various categories and regions based on business needs using SQL Server Reporting Services (SSRS)

Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/2008/2012/2014, TSQL, Pl/SQL, Visual Studio 2008, Oracle 11g, Cognos, Qlikview, Lotus Notes, SSRS, SSIS, OBIEE, Informatica, Erwin.

Confidential, San Jose, CA

SQL/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Responsible for writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Work with business users to get the requirements and write the code.
• Created cross reference tables and ETL routines to standardize the data coming from multiple sources
• Optimizing the code using native tools like execution plan and query analyzer.
• Involved in ETL Architecture, Developing Source to target data mapping (STDM) document defining transformation logic.
• Worked on interface process which downloads the file from Client FTP and process the applications in production database based on the requirement.
• Translated business logic to transformation logic to generate pseudo code for the ETL process
• Created packages using SSIS 2012 for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Involved in Data migration, data cleansing and writing the retro to fix the existing effected data.
• Worked on Visual Studio 2012 and Synced/loaded projects with TFS 2010.
• Used transformations like Lookup, Aggregator, Sort, Derived Column, Union All and OLE DB Command to implement the transformation Logic and load the target tables.
• Developed the logic to Capture the Error Rows in the data flow and populate them into an Excel file
• Performance tuning the Stored Procedures used in SSIS Packages
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS 2012.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Scheduled and maintained jobs to perform ETL tasks on daily, weekly and monthly basis.
• Design store proc, view, trigger, function for data ware housing.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Developed 2012 SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Involved in all phases of Data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Set up SQL Profiler to trace various Database activities, Application Responses and their Performance in order to tune them.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created mapping for error handling sessions.
• Designed different type of reports: tabular, matrix (cross tab), conditional, list items, charts and sub reports with different sources.
• Converted Oracle and Crystal reports to SSRS.
• Documented requirements.

Environment: MS SQL Server 2014/2012/2008 R2, MS SQL Server Reporting Services, Crystal Reports, Oracle reports, SSIS 2012, ETL, DTS, Data Modeling, Data Warehousing, Visual Studio 2014/2012/2008 & 2005, SQL Profiler, T-SQL, XML, MS Access, Excel.

Confidential, CA

SQL/BI Developer (SSIS/SSRS)

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2012/2008R2 using SSAS, SSIS/DTS, SSRS.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Responsible for creating and designing SSIS 2012 packages.
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database.
• Based on business requirement, developed Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Involved in creating custom objects, workflows, Visual Flow, Page layouts, Email alerts, templates and data validation, triggers and test classes.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Use package configuration to migrate SSIS package from one environment to other.
• Used Team Foundation Server (TFS) for central repository as a versioning control.
• Used Team Foundation Server 2010 to source control, data collection, reporting, and project tracking Purpose.
• Use event handling to send e-mail on error events at the time of transformation.
• Design and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema and snow-flake schema.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild
• Modified the queries to achieve better performance
• Created 3NF normalization forms
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.

Environment: Business Intelligence Development Studio (BIDS), SQL Server 2012/2008/2005, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft Management Studio, Microsoft Visual Studio 2005, ASP.NET 2.0, C# Net 2.0, Windows Server 2012/2008/2003, CA ERWIN Team Foundation Server, SQL Profiler.

Confidential, Whitehall, Ohio

SQL/ BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created DB Objects like Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL. Worked on Performance point server and created management reports.
• Monitored SQL jobs to increase the performance at job level and CPU usage level and also involved in the performance tuning of Indexes.
• Created SSIS packages to pull data from text files, XML files, SQL server and excel and exported to excel spreadsheets, flat files and vice versa.
• Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages.
• Extensively worked on mappings, incremental data loading, and SSIS transformations that include: lookup, filters, aggregators, scripts, multicasts, derived.
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS.
• Ensured performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary
• Performed Query optimization and Performance Tuning of stored procedures, Functions using SQL Profiler and Database tuning wizard.
• Created configuration files to deploy SSIS packages across all environments.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculated the metrics that were revealed in the functional analysis
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Expert in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions. Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Generated multiple Enterprise reports (SSRS) 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, Parameterized Reports.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, 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 warehouse.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Build efficient SSIS Packages for processing Fact and Dimension tables with complex transforms.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.

Environment: MS SQL Server 2008R2, SSIS, Business Intelligence Development Studio (BIDS), SSAS, SSRS, Oracle, DB2, ASP.Net, .Net Framework MS - Visio, MS- Access, Perl & MS- Projects, XML, IIS.

Confidential

SQL Server Developer

Responsibilities:

• Created Table, Stored procedures and user defined functions.
• Performed data conversions from Flat files into a normalized database structure.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Responsible for creating constraints, Indexes, and Views.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Involved in Performance tuning, query optimization and execution plan of queries for better performance.
• Rebuilding the indexes at regular intervals for better performance
• Created triggers, views, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Configured Server for sending automatic mails to the respective people when a DTS process fails or succeeds.
• Transformed data from various data sources like Excel, Flat file using OLE DB connection by creating various DTS packages.

Environment: SQL Server 2005/2000, Windows 2000 Advance Server, Windows 2003 Server, XML, T-SQL, MS Excel, MS Access, VB.NET 3.0, Crystal Reports, SSRS, and DTS.

Confidential

MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in different phases of SDLC process of design, development and testing of License Information Repository application using SQL Server.
• Participate in up gradation and migration of data from SQL 2000 to 2005
• Modified a number of existing stored procedures based on the changes made to existing tables.
• Migrated DTS packages to SSIS packages.
• Worked with slowly changing dimensions type 2.
• Created SSIS packages to perform cube processing from staging to Analysis Services Cube.
• Developed aggregated queries to populate the fact tables.
• Created a MOLAP Cube on SQL Server 2005 Analysis Services as an alternative prototype to an existing relational data mart.
• Handled millions of records on changing dimensions as well as facts in SSAS.
• Developed numerous reports off OLTP Servers using Reporting Services by writing T-SQL queries, stored Procedures with parameters, charts and multiple datasets.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005 Reporting Services.

Environment: SQL Server 2005/2000, Windows 2000 Advance Server, Windows 2003 Server, XML, T-SQL, MS Excel, MS Access, VB.NET 3.0, Crystal Reports, SSRS, and DTS, SQL Server 2005, SSIS Packages, SSAS, SSRS, Product Studio and Windows.