SUMMARY:

• Highly motivated and creative Business Intelligence Developer with over 8 years of solid development experience in MS SQL Server 2016/2014/2012/2008/2005 suite and Microsoft BI stack SSRS, SSIS and SSAS
• Strong knowledge in designing, developing, configuring and fine - tuning MS SQL Server Integration Services (SSIS)
• Hands on experience in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from heterogeneous databases such as Oracle, DB2, Sybase and MS Access
• Hands on experience in developing SSAS cubes for data aggregation and reporting purposes
• Skilled in the design, development and deployment of enterprise ETL packages and reports
• Extensively worked on writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS and Tableau
• Sound DBA experience in replication, database mirroring, migration and deployment
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager
• Adept in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, and validating data
• Highly experienced in designing and developing numerous enterprise reports(SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources
• Complete knowledge in creating MOLAP Warehouse on SQL Server Analysis Services

TECHNICAL SKILLS:

MS SQL Server 2016/2014/2012/2008/2005 , SQL Server Integration Services (SSIS), SQL Server DTS, Data Stage, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI,Tableau, Informatica, Business Objects, Erwin, Rational Rose, Oracle 9i, DB2, Sybase, TOAD 6.0, VB.net, C#, Microsoft Office, Share Point 2007

PROFESSIONAL EXPERIENCE:

Confidential

Business Analytics, SSIS and Business Intelligence Developer

Responsibilities:

• Leading the Mobile Application project
• Research audible applications and business model
• Perform a technical analysis of the platforms available for audible business
• Provide financial, business and market study for audible contents
• Assisted in modifying and utilizing the company’s current traffic data warehouse into projection of the new project
• Added new fact and dimension tables in the data warehouse
• Performed Data modeling tasks, designed and built new database objects.
• Created and optimized ETL Packages to transfer data to the testing server
• Designed and implemented FTP Transformation packages to receive data from a third party analysis system and upload it to the data warehouse.
• Created some lookup and audit transformation packages.
• Performed package configuration.
• Created cubes using the relational data warehouse objects
• Created stored procedures to monitor and modify content management
• Prepare test scripts for QA and run app test
• Modify Requirements and create technical Requirements for app upgrades
• Developed traffic reports using ssrs and excel.
• Involved in Future BI prospect study for the project

Confidential, Denver, Co

Senior BI developer

Responsibilities:

• Joined the BI team in daily scrums regarding data warehouse decisions
• Created objects such as sprocs, functions, indexes to help the functionality of the data warehouse
• Modified some previously created sprocs to help tune performance issues
• Involved in the development of sophisticated reports in collaboration with the integration team to achieve data integrity timeliness and consistency
• Worked on different SSIS packages for moving data to the warehouse and test and apply business rules.
• Advised in updating server to the most current cumulative update to utilize the most current functionalities such as auto refreshing KPI’s which take parameters
• Developed and implemented the parameterized KPI’s
• Studied and suggested the use of cubes to the BI team
• Created sample cubes and demonstrated the advantages to be gained in minimizing server cost and gaining better performance

Confidential

SQL/BI Developer

Responsibilities:

• Created Tabular Reports, Sub Reports, Navigation reports, drill down and drill through reports, parameterized, and aggregation reports in MS SQL environment using SSRS and Visual Studio
• Designed report layouts including report parameters and wrote queries for drill down reports using SSRS
• Created and modified validation scripts using VB and C# in Visual studio
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status
• Developed test cases bases on requirement specifications and design documents
• Interacted with testing team to fix the defects raised during the testing period. Worked closely with the developers and testing team to resolve bug Issues
• Responsible for modification and executing of the test scripts
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor
• Developed and delivered dynamic reporting solutions using MS SQL Server Reporting Services by SSIS such as data conversion, conditional split, bulk insert, merge and union all

Confidential, Seattle, Washington

SQL/BI Developer

Responsibilities:

• Market analysis for ad networks, analyzing the prospect ad providers and ad servers
• Researching potential game and application developers with suitable platform to serve ad
• Evaluated ETL options, including SSIS and Informatica, available to the team prior to proceeding with the project to migrate databases to an AWS environment
• Analyzed and enhanced the workbench environment currently implemented
• Performed SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer
• Performed SSIS Performance Tuning analyzing the ETL Packages and tuning and enhancing the performance of the packages
• Helped to create new database objects as per user/client requirements for the data warehouse
• Consulted with the testing team to fix the defects raised during the testing period and on performance tuning on existing ETL Packages
• Created cubes to be consumed by the reporting team
• Helped create reports from cubes
• Worked on an AWS Platform
• Used php /mysql for integration some mobile app to the platform

Confidential, Atlanta, GA

SQL/BI Developer

Responsibilities:

• Designed and developed Informatica and SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to AMS
• Created functional specification and technical specification from BRD
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers
• Data validation, control and transformation using VB and C# in visual studio.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently
• Established Inner Joins, Outer Joins and created Indexes whenever necessary
• Involved in unit testing of Store Procedure and UI as per requirement on different server (Dev, DIT, and SIT)
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages
• Created Matrix reports, Navigation reports, drill down and Drill through reports, parameterized, and aggregation reports in MS SQL environment using SSRS
• Designed report layouts including report parameters and wrote queries for drill down reports using SSRS
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status
• Developed Test Cases based on Requirement Specifications and Design Documents
• Interacted with testing team to fix the defects raised during the testing period. Worked closely with the developers and testing team to resolve Bug Issues
• Responsible for modification and executing of the Test Scripts
• Involved in integration of the front end with the SQL Server backend
• Created jobs on daily basis and schedule on every minute to update recent data by using SQL Server Agent jobs
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor
• Developed and delivered dynamic reporting solutions using MS SQL Server Reporting Services
• Automated and enhanced daily administrative tasks including database backup and recovery
• SQL Server 2012 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all

Confidential, Seattle, Washington

SQL Server 2005/2008/Teradata and SSRS Developer

Responsibilities:

• This project involved designing SSIS packages to pull data from SQL Server 2005 database and make them incremental
• Added configurations, logging and auditing to the packages
• Created batch files to run the scripts in DEV, QA and PROD environments
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation
• Developed logical and physical data models for schemas using Erwin
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges
• Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints
• Migrated MS access based model to Erwin
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Wrote T-SQL queries, Store Procedures and used them to build packages
• Handled slowly changing dimensions to maintain the history of the data
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS)
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS
• Created reports to retrieve data using Stored Procedures that accept parameters
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script
• Performed daily tasks including backup and restore by using MS SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• 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 2005
• Supported production operation activities, with focus on integration and development of new and existing products and services