SUMMARY:

• Over 8 years extensive experiences in Information Technology industry, especially in Microsoft Business Intelligence and SSIS ETL design and implementation area.
• Solid understanding in OBIEE ETL design and implementation using BI Server and BI Server Repository, data visualization and BI Reporting using OBIEE BI Reporting Dashboard/Scoreboard and BI Scheduler and OBIEE System administrative and maintenance area.
• Experience in gathering requirements directly from users, creating / designing the proposed solution, and building the new OBIEE application.
• Experience in data warehousing techniques for data analysis, data profiling, data cleansing, transformation, consolidation, integration, data import, data export using various Source(Oracle, MS SQL Server, XML and Flat Files) and Target.
• Solid hands - on skills on BI reporting development area using business intelligence modeling, reporting and data management tools such as SQL Server Reporting (SSRS), Integration (SSIS), and Analysis Services (SSAS); Crystal Reports etc.
• Strong Experience with Online Analytical Processing tools (OLAP), designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems, fact and dimension tables modeling of data at all the three levels: view, logical and physical.
• Expertise experience in relational database design, data extraction, transformation and writing stored procedures, functions, triggers, CTE, views and from large and complex data sources using Microsoft SQL Server (SQL,T-SQL), Oracle (SQL * Plus, PL/SQL) etc.
• Adequate experience with dimensional modeling using Star Schema and Snowflake Schema, OLAP/DW, OLTP, Physical and Logical Data Modeling using different data modeling tool Erwin.
• Good understanding of Data Integration patterns, ETL Performance, Parallelism Strategies and Debugging/Troubleshooting performance problems.
• Expertise in design and implementation of various types of Slowly Changing Dimensions (SCD).
• Skilled at building and deploying multi-valued parameterized reports including matrixes, charts, and gauges in SSRS.
• Results-Driven with ability to take initiatives and meet deadlines in a fast paced changing environment; Strong analytical and communication skills with the enthusiasm to learn new technologies.

TECHNICAL SKILLS:

Database: Microsoft SQL Server 2012/2014/2016, Oracle 11g/12c, MySQL

Language: SQL and T-SQL, C/C++/C#, Java, PowerShell, HTML/CSS, Java Script

MS BI Stack OBIEE: SSIS, SSRS, SSMS,BI Server, BI Server Repository, BI Presentation Server, BI Scheduler

Development: DevOps, Agile/Scrum, JIRA, Rally, Svn, Git/Github, TFS

Dev Tools: Visual Studio 2012/2013/2015

PROFESSIONAL EXPERIENCE:

Confidential,Charlotte, NC

Sr. Microsoft SSIS and Business Intelligence Developer

Responsibilities:

• Involved in the full lifecycle of BI development including requirements gathering, design, development, testing, and providing end user support for a full stack Microsoft BI Platform.
• Creating Data Models, Data Sets, Customize Reports and Schedule Report Jobs in OBIEE BI Publisher.
• Responsible for all activities related to the development, implementation, administration and support of reporting using OBIEE.
• Build BI Server repositories from scratch, performed business modeling and mapping, created security profiles, create variables, send for testing, deploy to OBIEE Presentation Services
• Key contributor to Business Intelligence (BI) & Data Management Strategy including: Information Architecture, Data Architecture, Master Data Management Architecture, Metadata Architecture and Information Delivery Life Cycle (IDLC).
• Lead and worked as primary ETL Developer of our Business Intelligence team to assist in the design and development of data feeds, interfaces, data warehouses and enterprise reporting platform.
• Follow the specifications provided by the Data Architect for development of SQL Server Integration Services based solutions for migrating data in both OLTP and Data Warehouse environments.
• Work with other developers, data architects, DBAs, project managers, and client business users to develop ETL specifications and resolve client questions around problems and enhancements.
• Prepare an analysis document with the recommended solution. Analyze, Design, Develop, and Test dimensional models. Create, test and maintain models within SSIS and other ETL tools.
• Analyze, develop, test, maintain and support very complex data/process models, reports and processes in the Microsoft ETL environment using SSIS and SSRS.
• Design, develop, and support complex integration processes (including interfaces) using SQL Server technology such as T-SQL stored procedures and C# code.
• Build new data sets and data structures as required to support business needs, and for managing the distribution, replication, and archival of data.
• Help implement the data strategy, data governance processes, and maintenance of business definitions, policies and glossaries for data assets.
• 24X7 level support for the production systems.

Confidential,Southlake, TX

Senior Microsoft SQL Server and BI Developer(SSIS)

• Participated throughout the project life cycle, from requirements to production implementation, with emphasis on development, testing and implementation of data warehousing infrastructure, analytic reports and tools.
• Worked with the Information / Data Architect and Database Designer / Modeler to help implement the physical data model to support the mission critical OLTP and OLAP production databases.
• Performed business analysis as it relates to business intelligence, data warehousing, and operational reporting systems.
• Collaborate with third party expert to develop the OBIEE Reports by accessing the Oracle database in the IT industry with prime focus on implementation of various Business Intelligence and Data Warehouse / Data Marts that covers gathering Business Requirements, GAP Analysis, Design / Modeling (Star and Snow flake), Development, Testing, Implementations and Documentation.
• Creating Metadata Objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboards, Pages, and Reports) using OBIEE Admin Tool.
• Performed the statistical analysis of data in the warehouse; Reviewed the customer’s requirements and determine if the business processes for gathering, cleansing, and ensuring the quality of data were adequate. Analyzed the options for preparing a BI solution.
• T-SQL development included queries using joins, subqueries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Responsible for the creation of BI reports, dashboards and other forms of information designed to gain new insights, monitoring key organizational and operational measures, and providing visibility of performance throughout the organization and customers.
• Designed and enhanced the SSIS ETL packages and processes, implemented data transformation rules and data validations into the enterprise data warehouses (EDW).
• Troubleshooted the technical issues and tune at all layers of the ETL platform including the database, the data source, SSIS package, and the presentation layer.
• Managed the existing third-party data exchange relationships and worked with vendors, partners, and clients to define, implement, document, and maintain data exchange files, file specifications, and supporting business processes.
• Develop MS SQL Business Intelligence (BI) reports and applications and other reports and applications using T-SQL, C#, and other designated tools.

Confidential,Pittsburgh, PA

Data Analyst

• Executed different phases of SDLC including gathered and analyzed business requirements, designed and modeled them into diagrams and documents, monitored function and structure implementations, designed test scenarios.
• Translated the business requirements into technical designs to map and load data from source systems to data warehouses, downstream applications, and trading partners.
• Data architecture and dimensional data modeling design. Defining and assessing architectural options. OBIEE reporting tools. Installing, upgrading, and patching OBIEE 10/11g.
• Performed development, testing, and deployment in a SQL Server environment, including data modeling, database design, and coding of functions, stored procedures, and triggers.
• Designed and developed the data extracts and integration processes using SSIS, T-SQL and C#.
• Designed and developed the advanced reporting and visualization tools, building dashboards, auditing and troubleshooting data issues, and building analytical solutions.
• Designed Test Plan and Test Cases according to Functional Requirements and design specifications of the application and executed them with testers. Implemented Unit Testing Stored Procedures, Functions, Packages and Triggers.
• Implemented Test Plans using both automated and manual testing methods, and resolve and document software issues based on test results.
• Acted as a technical point of contact in support of new and existing data exchange relationships.
• Provided 24X7 level production support service of Data Warehouse as well as ETL jobs used to support the Data Warehouse.

Confidential,PA

Microsoft SQL Server Developer (T-SQL)

• Participated in the full life-cycle development process from definition and design to production delivery.
• Analyzed and assessed the existing business systems and operational procedures to identify process and system improvement opportunities.
• Built and maintained T-SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed and developed reports using Microsoft SQL Server Reporting Services (SSRS) and Crystal Reports.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development.
• Assisted with design, testing, support, and debugging of new and existing ETL and reporting processes.
• Performed the root cause analysis for issues and provided effective and timely resolution for our critical Data Warehouse platform.
• Developed the detailed test conditions and test cases to ensure quality of queries and data.
• Maintained the data repository with data definitions, relationships, linkages and sources.