PROFESSIONAL SUMMARY:

• 7 yearsof experience as a BI developer/Analyst in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) and SQL server.
• Experience in MS SQL Server 2012/2008 R2 with MSBI stack SSIS, SSAS, and SSRS. Expert in Business Intelligence solutions in Data warehousing / Decision Support Systems using ETL tools like Informatica, DataStage and worked on OLAP, OLTP and Data Warehouse Reports using Business Objects and Crystal Reports.
• Involved in all phases of the Software Development Life Cycle (SDLC) from analysis, design, development, testing, implementation and maintenance with timely delivery, requirements gathering, functional gap analysis, module setup script generation testing and production support.
• Experienced in Data loading using PL/SQL, SQL Server Integration Services packages (SSIS), Oracle Data Integrator (ODI) and developed dashboard reports using SQL Server reporting services (SSRS).
• Experience 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)
• Experience in designing conceptual, logical and physical database models using Erwin.
• Extensive experience with Database Backups, Recovery Procedures, Backup strategies and scheduling.
• Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database Consistency Checks using DBCC Utilities.
• Excellent Confidential -SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Dimensional Modelling and Data Visualization using SSAS, Microsoft Power BI, Power Pivot and Database design using RDBMS.
• Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes withSSAS and in adding calculations using MDX.
• Good knowledge of SSRS Architecture and Hands on experience in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.
• Experience in creating reports by using Dashboards Strategy Experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8.2, 8.1, 8.0, Tableau 7 and Tableau 6.
• Experience working in Agile and Waterfall model working methodologies.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and soft skills.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C#, ASP.NET JAVA, Cosmos.

Database: SQLSERVER 2008/2012/2014 , ORACLE 11g/10g/9i/8i

Web Technologies: HTML5, HTML4, CSS3, XML, Java Script.

Design& Simulation Tools: SQL Server Management studio, Oracle Designer, Erwin Modeler, TOAD Modeler, Visual studio, Oracle SQL Developer, PL/SQL Developer, B.I.D.S for DTS

Microsoft Office Suite: MS WORD, MS EXCEL, MS VISIO, POWERPOINT, OUTLOOK.

Tools: SSIS, SSRS, SSAS, Tableau, Power BI, Informatica, Power Pivot, DataStage, QlikView, Cognos, JIRA.

Operating Systems: MS Windows 10/8/7/XP, UNIX

EXPERIENCE:

Confidential, Dallas, TX

Business Intelligence Developer/Analyst

Responsibilities:

• Worked with other functional teams within IT and the Business to identify opportunities for process improvement and assist in the implementation of those agreed.
• Developed complex calculated measures using Data Analysis Expression language(DAX).
• Used SSIS and Confidential -SQLstored procedures to transfer data from OLTP databases to staging area and clean data and store in Centralized SQL Database.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2008 R2/2012 Analysis Services (SSAS) and Reporting service (SSRS).
• Developed Ad-Hoc report model and charts using SQL Server Reporting Services (SSRS) based on requirements
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS. Worked on data validation using VLOOKUP functions and table formulas in MS EXCEL.
• Used Model Mart ofErwinfor effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Created Stored Procedures and performed Index Analysis for slow performing SSRS reports to bring down the report rendering time from 15 mins to 30 seconds.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL* Loader, SQL Developer, Oracle Enterprise Manager, Windows 2000, ETL Tool, SSIS, SSRS, TABLEAU 8.0, UNIX

Confidential, Culver City, California

Senior Data Modeler

Responsibilities:

• Developed logical and physical database (using ER-win, Normalization, Dimension Modeling and Enterprise Manager).
• Worked with Business Analyst clients to clarify business requirements, map them to systems capabilities, and recommend technical solutions.
• Involved in Analysis, profiling and cleansing of source data and understanding the business process. Built ODS integrating the source systems for ad-hoc reporting.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Normalization techniques to normalize the data in ODS. Forward Engineered the physical data model and generated DDL script using Forward Engineering option in Erwin.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor. Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Assisted in entering and updating Issues onto JIRA Agile application.
• Monitored the Production batches and fixed the issues within SLA.

Environment: Oracle 12c/11g, MSSQL Server2012/2014, SSIS, SSRS, TABLEAU 8.0, SSAS, SQL*Loader, Erwin 9.5, SQL*Plus, Confidential -SQL.

Confidential, Detroit, Michigan

BI Developer/Analyst

Responsibilities:

• Involved in translating business requirements into technical design specifications.
• Based on business requirement, developed Complex SQL Stored Procedures, Views, Triggers using Confidential -SQL to implement the business rules and transformations.
• Worked with Business Intelligence Manager to plan BI strategies, create BI road map and budget plans to deliver on organizations Business Intelligence needs. Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Worked on Database Security like Encryption of Critical Database Login information.
• Developed complex SQL queries using stored procedures, common table expressions, temporary table to support Power BI and SSRS Reports.
• Monitored Health Reimbursement Arrangements (HRAs) or Flexible Spending Accounts (FSAs).
• Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports inSQL Reporting Services (SSRS).

Environment: MSSQL Server2008R2/2012, SQL*Loader, SQL Navigator, Power BI, SQL*Plus, UNIX, ORACLE SQL DEVELOPER, ETL, MS Excel, TOAD.

Confidential, Chicago, IL

SQL Developer

Responsibilities:

• Prepared business use cases understanding document by capturing the use case, based on proposed solution and challenges.
• Worked on Data discovery, Aggregation and Transformation based on business use cases and requirement.
• Performed normalization of database to reduce redundancy to achieve maximum system performance.
• UtilizedODBC for connectivity to Teradata via MS Excel to retrieve automatically from Teradata Database.
• Performedtuningandoptimizationof complexSQL queriesusingTeradata Explain.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• IntegratedBI Publisherwith OBIEE to build reports in word, excel and doc format.
• Worked closely with Analytics department reporting team and deployedTableaureports and publishing them on theTableauserver.

Environment: MSSQL Server 2012, Oracle Database 10g, SQL Loader, Tableau, Oracle Forms 10g, TOAD, EXPORT, IMPORT, Confidential -SQL, MS-Excel.

Confidential

Jr. Data Analyst

Responsibilities:

• Designed and developed Entity-relationship Diagram and Data Dictionary up-to- date after any alterations were made to the metadata and data in each table.
• Created SQL Agent jobs to run SSIS packages. Data discovery, Aggregation and Transformation based on business use cases and requirement.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Created Data-storage migration space to move physical data block from one to another disk for visualization purpose.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Analyzed database requirements from the users in terms of loading dimensions and fact tables using SSIS Packages.
• Physical Migration of the Developed reports onto the Development SSRS server.
• Developed UNIX Shell scripts to automate various periodically repetitive database processes.

Environment: MSSQL Server2012, MS Excel, Confidential -SQL, SSIS, SSRS, SQL *LOADER, SQL*PLUS

Confidential

Jr. SQL Developer

Responsibilities:

• Using triggers for block processing, interface events, master-detail relationships, message handling, mouse events, navigation, query-time processing, transactional processing, validation and key processing.
• Extensively involved in Coding PL/SQL, Packages, Procedures, Functions and Database Objects according to Business rules. Experience in using Arrays in stored procedures and processing it.
• Written and modified Shell Scripts to automate the data loading. Designed Confidential -SQL scripts to identify long running queries and blocking sessions.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
• Implemented indexes for performance tuning. Data loaded into the database using SSIS 2005 from flat files.