SUMMARY:

• Strong 10+ years experience in Data Warehousing implementation using SQL SERVER Integration Services (SSIS), SQL SERVER Reporting Services (SSRS).
• Extensive experience in Extracting, Transforming and Loading (ETL) data into centralized databases from and to wide variety of data sources like Excel and Spreadsheets, Text files, SQL SERVER and Oracle using Integration Services and SP's. Also, good in validating and testing that the data pumped is valid.
• Strong Experience in Microsoft (MSBI) Business Intelligence, ETL Data Warehouse, OLTP & OLAP using MS SQL Server Integration Services (SSIS) 2014/2012/2010/2008 R2/2008, MS SQL Server Reporting & Analysis Services(SSRS&SSAS) 2014/2010/2012/2008 R2/2008andMSSQLServer 2014/2010/2012/2008 R 2/2008/2005.
• Extensive Experience in ETL Data Warehouse Ralph Kimball Methodologies for supporting Data Extraction, Transformation and Loading processing using MSSQL Server Integration Services (SSIS) 2014/2012/2008 R2/2008 and Loaded process fromHeterogeneous / Homogeneous Data Sources, performed Data Verification, Data Cleansing, Data Integration, Data Import & Export. Applied various Transformations such asLookup, Fuzzy Lookup, Merge, Merge Join, Conditional split, Multicast, Derived column, Cache, Slowly Changing Dimension (SCD Type1, Type2, Type3).
• Rich Experience in Multi - Dimensional Modeling such as STAR Schema, SNOW Flake Schema.
• Proficient in Multi-Dimensional Data Analysis, Data Modeling. Built and deployed CUBES using SQL Server Analysis Services (SSAS) 2012/2008R2/2008. Built dimensions, measures, hierarchies, calculated attribute, KPI, perspective, partitions, actions and MDX query.
• Hands on experience in writing SSIS script/script component task using C#,VB script for customized data manipulation of complex SSIS packages
• Performed relational data modeling (Logical & Physical) and dimension data modeling. Explored No SQL Databases such as MongoDB & DynamoDB(AWS), TALEND.
• Experienced in writing SQL Queries, Views, Materialized Views, PL/ SQL Procedures, Functions, Packages, Triggers, Cursors, Collections, Ref Cursor, Cursor variables, System Cursor, Dynamic SQL, Exceptions. Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in importing multiple data source into Tableau, created charts, tables and visualization design.
• Proficient in creating Worksheets, Dashboards, stories using Tableau Desktop and publishing them on to the Tableau server. Experience in creating Drill Down, Drill Through, Parameterized, Cascading, Conditional, Table (List), Matrix (Crosstab), Charts, Sub-Reports, Indicators, Bar Graphs & Line Graphs, Dashboards,Ad-hoc and Crystal Reports using SSRS.
• Experience in ETL Tool using Informatica Power Center 8.0/7.1 and built various ETL Transformations such as Aggregate, Rank, Sort, Joiner, Filter, Router, Normalizer, Lookup (connected & unconnected).
• Experience in development of coding in C# while working with SSIS.
• Extensive Experience in Software Development Life Cycle (SDLC) Methodologies such as Waterfall, AGILE, SCRUM, RUP (Rational Unified Process), Extreme Programming, Iterative Development, System Analysis & Design concepts.
• Experience in MS SQL Server database development and administration including server installation, configuration, maintenance, tuning, optimization, migration, and monitoring.
• Sound expertise in Scheduling Database Tasks like Jobs, Alerts Emails and Notifications.Experience in SharePoint 2010 and Shared documents with people, managed versions of files. Familiarity with Performance Point dashboard functionalities.

SKILL:

C# (10+ years), ETL (10+ years), EXTRACT, TRANSFORM, AND LOAD (10+ years), MS SQL SERVER (10+ years), SQL (10+ years)

TECHNICAL SKILLS:

OLAP & BI Tools: MS- SQL Server 2008/2005/2012 , MS-SSRS2010,2012, MS-SSAS, COGNOS 10.0/8.0/7.x COGNOS EP Series7/7.1/7.3 (Impromptu, PowerPlay, Transformer, Access Manager, IWR, Scheduler, Power Prompts, COGNOS Query), ReportNet 1.1, Outlooksoft, Business intelligence server 8, web, web administrator, project builder, Tableau 10.3ETL Tools: Microsoft SQL Server Integration Service 2014/2012/2008 R2, Informatica Power Center 8.6/8.0/7.1, Informatica Power Mart, Informatica Repository Manager 8.6/8.0/7.1, Informatica Designer 8.6/8.0/7.1, Informatica Workflow Manager 8.6/8.0/7.1, Informatica Workflow Monitor 8.6/8.0/7.1

Data Process and modeling tools: ERwin 4.0, Rational Requisite Pro 2001, Power Designer 10.x, Rational Rose 4.0, UML2.0, ProcessModeler, Quest's TOAD

Databases: Oracle 11g/10g/9i/8i/8.0, SQL Server 2000/2005/2008/2012 , UDB DB2, MS Access 03/07/10, MySQL,TERADATA,Sybase

Languages: T- SQL, UDB SQL, SQL *plus, PL/ SQL, VB .NET, C# .NET, Visual Studio .Net, VB, HTML, XMLUnix Shell Scripting, AWK, XML, Interactive SQL .

Development tool: TOAD 8.5, SQL, SQL *Plus, SQL Analyzer, SQL *Loader, Explain Plan, TKProf, Query Analyzer.

Workflow Tools: MS-Project, MS-VISIO, MS-Excel, MS-Word, MS-PowerPoint, MS- FrontPage.

WORK EXPERIENCE:

Sr . SQL / BI Developer

Confidential, Norfolk, VA

Responsibilities:

• Understand the existing PDI System and create the better architecture for new GPI system to replace PDI.
• Load the CRF and Facets data using SSIS and Informatica ETL loads.
• Creating reusable ETL control parts and package templates to utilize them across multiple markets
• Created and developed Web Pages using .NET, HTML5, JavaScript, AngularJS, CSS3 and server side and client side controls.
• Experience in using ASP.NET, MVC and AngularJS to build Single Page Applications (SPA).
• Developed cross - browser/platform HTML5, CSS, and JavaScript to match design specs for complex page layouts while adhering to code standards
• Creating Common Data Format process flow to utilize them across multiple markets
• Implement table partitioning to avoid table level locking issues when different operating company's data process is initiated at the same time by locking at partition level.
• Apply the Business rules on the data coming from multiple operating markets. Maintain the business rules in a table for visibility to all required processes.
• Load the processed data through RAM processing into FACETS.
• Create the visualizations using Tableau reporting tool.
• Data profiling and ongoing data analysis on the sources and implement the business rules accordingly.
• Assist team in understanding the existing data and create the required data models for the development.
• Set the Standards for ETL development for the team to follow on naming standards and best practices for the meta-data, event handling and logging.
• Code review for the team before handing over to testing team to verify the better logic and standards being followed.
• Utilize SVN for code maintenance and code check in's.
• Worked in an Agile Methodology (Scrum) to meet timelines with quality deliverables.

Environment: SQL Server 2012, Windows server 2008, C#.Net, .NET Framework 4.5, ADO.Net, Win Forms, WPF, WCF, MVC, Web Services, SVN, Tableau, Informatica.

SQL Server BI Developer

Confidential, Houston, TX

Responsibilities:

• Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2008 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Used SSIS transformations and data conversion to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Implemented SSRS Security and Deployed Reports to report server.
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Fine - tuned the current SSAS cube for performance improvement and created proper partitions and designed aggregations to enhance the performance of the SSRS reports.
• Worked on calculating measures and dimension members in SSAS using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models and developing reports using MDX and T- SQL .
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance. Performed T-SQL tuning and optimization of queries for reports that took longer execution time.
• Experience in writing DAX in MS Power BI Desktop.

Environment: MS SQL Server 2000,2008,2012,2014, Power Pivot, SQL SSIS, SQL SSRS, T- SQL, Oracle, Visual Studio 2010, .NET(C#, VB), Autosys Scheduler, Windows XP/Server 2012, MS Office 2010. Programmer Analyst Confidential Responsibilities:

• Understand the existing multi - hop manual process and automate the process flow using SSIS ( SQL server 2016) ETL and T- SQL .
• Design the data model for the automation solution to make it centralized for the other line of businesses.
• Load the multisource data from on-prem databases to Azure Blob using Azure blob storage service in JSON format.
• Fetch the data from Azure blob data service using SSIS Azure tasks Azure feature pack for SQL server 2016 and implement the incremental load of the data into intermediate database.
• Creating reusable ETL control parts and package templates to utilize them across other point of sale automation systems on various Line of Business across the organization.
• Created GUI in ASP.Net using .NET controls, C# and writing of common controls (*.ascx).
• Involved in designing Web applications using MVC 4.0, Entity Framework, jQuery and JavaScript for Client Side validation, CSS and HTML.
• Developed web forms using Master Pages, HTML controls and CSS Style sheets for the unique look for the page.
• Implemented Web services and WCF (SOA) for the communication between client and server using SOAP.
• Developed the web application using AJAX, JSON, HTML and performed validation using JavaScript.
• Implement table partitioning to avoid table level locking issues when different operating company's data process is initiated at the same time by locking at partition level.
• Apply the Business rules on the data coming from multiple operating companies. Maintain the business rules in a table for visibility to all required processes.
• Load the processed data into final view point centralized data ware house for further Power BI reporting.
• Assist team in understanding the existing data and create the required data models for the development.
• Set the Standards for ETL development for the team to follow on naming standards and best practices for the meta-data, event handling and logging.
• Code review for the team before handing over to testing team to verify the better logic and standards being followed.
• Creating Linked Services, Data Sets for Azure Blob storage and maintaining them.
• Utilize Team foundation server for code maintenance and code check in's.
• Explore Azure services for Analytics.
• Worked in an Agile Methodology (Scrum) to meet timelines with quality deliverables.

Environment: SQL Server 2016 on Azure, Azure Blob storage service, Windows server 2012, Team Foundation server, .NET Framework 3.5, Visual Studio 2010, ASP.NET4.0, C# .NET, ADO.NET, WCF, WPF, Ajax, jQuery, CSS, XML, HTML, Web Services, MVC JavaScript SQL & Database Developer Confidential Responsibilities:

• Created Stored Procedures and used them in the mappings by using them as Connected and Unconnected Stored Procedure Transformations in the mappings. Created, rolled back and committed transactions in SQL queries, used collections, inserted various kinds of constraints and indexes to enhance the queries.
• Assisted in designing Conceptual Data Model to capture system functionality and build a framework for the software development phase by using Flowchart, ER Diagram, Use Case Diagram, Data Flow Diagram, Activity Diagram, and Sequence Diagram.
• Developed and Deployed Complex Reports, used multiple data providers and created master/detail, cross tab, and charts.
• Designed several SQL Server based SQL using bulk load ..etc packages to extract data from XML files and load them into their Oracle8i Database.
• Optimized aggregations in cubes with the concept of storage models in view and created virtual dimensions using SQL server analysis manager.
• Improved the performance of queries by introducing clustered and non - clustered indexes on tables in the data base. Use SQL profiler to identify long running queries.
• Created MDX queries to create custom pivot reports and calculated members in the cube.

Environment: MS- SQL Server 2005, MS- SQL Reporting services, reports scripter, Perforce, SQL, T- SQL, Windows 2003, MS Excel SSIS 2012, MS SQL Server Reporting Services (SSRS) 2010, MS Visual Studio 2012 and 2015, Windows 10, GIT, SVN, Jira. Senior Software Engineer Confidential Responsibilities:

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team.
• Implementation and delivery of BI platform solutions to develop and deploy ETL, analytical, reporting and Graphs on SQL Server 2005/2008 using SSAS, SSIS, SSRS.
• Studied existing OLAP system(s) and extended it to include new sources of data and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Developed, deployed and monitored SSIS Packages for new ETL Processes.
• Created the SSRS reports as the visual representation to the business users.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split and Data Conversion.
• Written Stored Procedures for the extraction of data.
• Testing the product.
• Assisting in Production implementation.

Environment: SQL Server 2005/2008, Oracle C#.Net, windows 2003.