SUMMARY:

• Microsoft Business Intelligence Developer with over 5 years of experience in Healthcare, Banking and IT domains.
• Expert in Database design, development and maintenance of database applications on SQL Server in OLTP/OLAP/BI environment.
• Experienced in writing and debugging complex T - SQL queries, dynamic-queries, and other T-SQL constructs.
• Strong understanding in Software Development Life cycle.
• Mapped data from logical data model and physical data model into database objects
• Competent in designing ETL applications.
• Data Mapping Skills, Data Migration Techniques, Scheduling and Maintaining ETL Framework for different processes.
• Designed and developed reports using SSRS, Power BI.
• Successfully developed business reports using SSRS in deadline-oriented environments.
• Good understanding of SSAS, OLAP cubes and Tabular Model.
• Focused, meticulous and a team-player with great enthusiasm to provide game-changing solutions to client needs while holding excellence in leadership skills.

TECHNICAL SKILLS:

Application software: Microsoft Office (Word, Excel, PowerPoint), Visio, UML

Database management systems: Microsoft Access, My SQL

Programming Languages: Java, C, C++

Methodologies: Agile-scrum, Waterfall, Rational Unified Process (RUP)

Operating Systems: Windows 10/8/7/XP, Linux

ETL Tools: SQL server business development studio (BIDS), DTS, SQL server

Management Studio (SSMS), SQL server integration services (SSIS).

Analysis and reporting services: SSAS, SSRS, SSAS, Microsoft Power BI, MS Excel.

SQL server Tools: SQL server management studio, Database engine, Import and export wizard

Architecture: Relational DBMS, Client-server architecture, OLTP, OLAP

Version Control: SVN, TFS, JIRA

PROFESSIONAL SUMMARY:

Confidential, Atlanta, GA

MSBI Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Worked on development of SSIS packages for various inbound/outbound data, OLAP data architecture as well as Report functionalities in SQL Server 2012.
• Planned, designed, and implemented processes to Extract transform and load data from external sources into local databases.
• Installed and configured SQL Server 2008R2/2012 in Test environment with latest service packs and migrated few databases.
• To keep track of data manipulations using Audit functionalities.
• Developed physical data models and create DDL scripts to create database schema and database objects
• Implemented Error Logging using Event Handlers and implemented logging in SSIS Packages.
• Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.
• Created Customized and interactive dashboards using multiple data sources.
• Created Dimensions with the cube wizard and individually and Generated Named calculations and named queries.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Developing SSIS packages to bring data from Claims databases to data warehouse tables.

Confidential, Alpharetta, GA

MSBI Developer

Responsibilities:

• Met with business users, gathered business requirements and prepared the documentation for requirement analysis.
• Provided training to the business users on how to use new data warehouse, browsing cubes from Excel and assisted them in rewriting their existing queries to point to the new warehouse.
• Created centralized data warehouse (ODS) and developed de-normalized structures based on the requirements and to improve the query performance for end users.
• Created ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Created and Designed a Multi-Dimensional Analysis (Configured OLAP Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views and Star schema) using SQL Server Analysis Services (SSAS).
• Worked with SSAS tabular model (BISM) and created dashboards and reports using power view, power pivot and SSRS.
• Handled database server tuning, application tuning, maintaining documentation, and capacity planning and database security.
• Used data quality services (DQS) to cleanse the data, remove duplicates and improve the quality. Created domains in DQS and exported the activity results into SQL tables.
• Did debugging using break points and data viewers and performance tuning of ETL data flows.
• Created various SSIS packages to populate the data from flat files, Excel and Access into ODS (SQL Server). Performed full loads for current data and incremental uploads for historical data (transaction based data).
• Created and configured SSIS package configurations using SQL server table and environment variables and loaded data from XML, Flat files and SQL Server incrementally.
• Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS packages.
• Configured OLAP Cubes (Star Schema) using SQL Server 2014 Analysis Services and Performance tuning MDX and dimensions design and scaling to large numbers of users.
• Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Designed SSAS tabular models and created dashboards and reports using power view and deployed them in Share point server.
• Developed various types of reports drill down, drill through, matrix and sub reports using SSRS.

Confidential, Atlanta, GA

SQL Developer

Responsibilities:

• Created stored procedures, tables, functions, indexes, triggers, and views. Event, summary, and detail transaction tables were linked by table id. Intermediate tables created with summaries of each day to improve performance.
• ETL - Pull data from many differing input sources, transformed all data to fit landing table’scolumn definitions. Loaded landing tables.
• Created stored procedures to process data feeds to load main tables for transaction summary and transaction details. Since a process outcome per record was needed, cursors were implemented. Standard try/catch, begin/commit transaction, and output inserted.bed balance event detail id into were standard.
• Created stored procedures, functions, and lookup tables to provide data for liquidity drill down screens chart and table. Data totals between screens and row counts were required to tie back. Also used 'sum over rows with unbounded proceeding and current row' to calculate a running total per row, which was required since data was displayed per half hour increments.

Confidential, Alpharetta, GA

Client Relationship Consultant

Responsibilities:

• Developed sourcing strategies to recruit high caliber candidates through online social networking, job boards, community involvement, professional networking, and local media resources
• Interviewed and assessed candidates’ qualifications through a combination of behavioral interviews and competency-based evaluations
• Facilitated interviews between the candidate and client, including candidate preparation and client brief
• Facilitated Adecco-specific and client specific hiring and on-boarding processes
• Maintained and updated thorough, accurate, and compliant documentation of all client, candidate, and temporary interactions via technology solutions

Confidential, Marietta, GA

Graduate Assistant

Responsibilities:

• Assisted faculty members in literature research.
• Tutored students in finance related courses
• Assisted faculty member in grading student assignments
• Performed various administrative tasks including preparation of power point presentations, data research and analysis

Confidential

QA Tester

Responsibilities:

• Involved in identifying test conditions, designing test cases, reviewing test cases and executing test cases
• Involved in testing the functionality and usability of the system for end user perspective
• Performed Regression testing for every new build version
• Documented and communicated test results
• Participated in daily and weekly status meetings and conference calls

Confidential

Management Intern

Responsibilities:

• Assisted in constructing a ‘competitor array’ to assess strengths and weakness of all thecompetitors
• Developed new quality guidelines and standards to improve overall quality performance in thehouse-keeping dept.
• Trained employees with new quality programs
• Co-ordinated marketing events to create brand awareness