SUMMARY

• Over 9+ years of experience with database development and business intelligence applications as a BI developer in various domains like Finance, Health, Insurance, Retail and information technology.
• Strong experience in requirement analysis, physical and logical design development, resource planning, coding, debugging, testing, support and maintenance of business intelligence applications using SQL Server 2008/2012/2014 , DTS, SQL Server Integration, Analysis and Reporting Services
• Efficient in developing Logical and Physical Data model and organizing data as per the business requirements using Sybase Power Designer, Erwin, ER studio in both OLTP and OLAP applications
• Expert in database activities like database creation and maintenance, performance monitoring, tuning and troubleshooting, disaster recovery, backup/restore and migration.
• Strong experience with SQL Server and T - SQL in constructing joins, user defined functions, stored procedures, triggers, views, indexes, user profiles and data integrity.
• Good experience in writing common table expressions (CTE), indexed views and DML/ DDL triggers for data consistency and data manipulation.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace in Oracle
• Proficient in building workflow solutions and ETL solutions for data warehouse using SQL Server Integration Services.
• Experience in Azure SQL databases. Designed, developed and implemented Enterprise Business Intelligence and Data Warehousing strategy
• Designed and developed SSIS packages using control flow tasks like For Loop Container, For Each Loop Container, Execute SQL Task, File System Task and Data Flow Tasks like Lookup, Derived Column, Conditional Spilt, Sort, Data Conversion, Multicast, Union All and Merge Join.
• Developed Slowly Changing Dimension mappings for Type 1 SCD and Type 2 SCD.
• Expert in Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS with MYSQL Server 2005, 2008R2
• Strong understanding of Data Warehouse principles using Fact Tables, Dimension Tables, Star/Snowflake Schema modeling and data modeling
• Experience in designing, developing and deploying of Cubes.
• Experience in creating role based security and row level security in cubes using SSAS.
• Good Knowledge in design partitions and aggregations for performance tuning in SSAS.
• Experience in developing reports using Excel and SSRS.
• Experience in report writing and creating various reports like Drill down, Parameterized, Cascading, Conditional, table, Matrix, Chart, Ad-hoc and Sub Reports using SQL Server Reporting Services
• Designed and deployed reports with dropdown and drilldown menu option and Parameterized and Linked Reports using Power BI.
• Worked on Power BI and created reports and dashboards.
• Applied DW/BI concepts to manage and monitor accounts and resources in Microsoft Azure cloud.
• Hands on Microsoft Azure Application and Web Development
• Experience in configuring and deploying reports onto Share Point Server
• Experience with waterfall and Agile development methodologies and worked with customers in prioritization and planning sprints.
• Excellent in interacting with Clients, Business Analysts and developers.
• Good knowledge in implementing backup and disaster recovery procedures.
• Strong mentoring skills, capable of leading and motivating individuals to maximize productivity while fostering cohesive teams in a virtual environment.

TECHNICAL SKILLS

Programming Languages: C, C++, T-SQL, PL/SQL, .Net, JavaScript, HTML, CSS

DBMS: SQL Server 2005/ 2008/2012/2014 , MS Access, Oracle 11g/9i, Mongo DB

ETL Tools: SSIS, Import/Export Wizard, DTS

Reporting Rules: SSRS, Tableau, Excel Reporting, Power BI

Analysis Tools: SSAS

Methodologies: Waterfall, Agile, Software Development Life Cycle

Business Processing Tools: Erwin, MS Visio, QGIS

Work Flow Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Access and MS Project

Database Tools: SQL Server Management Studio(SSMS), SQL Server Profiler, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), OLAP, MOLAP, ROLAP, OLTP

PROFESSIONAL EXPERIENCE

PresentSQL BI Developer

Responsibilities:

• Worked closely with business and involved in gathering the user requirements
• Participated in creating conceptual and physical modelling with ERWIN for the flow of data
• Created database links and accessed the data through SQL statements
• Responsible for writing and modifying store procedures, functions, packages for data conversions to create database objects dynamically.
• Created indexes, tables and sequences as per the business requirement and views to maintain data privacy
• Used SQL profiler to identify slow running queries
• Developed data strategy and implementation plan for transitioning MS SQL Server on premise to Azure cloud
• Designed SSIS packages in order to validate, extract, transform and load data into staging and Data Warehouse
• Analyzed the requirements and framed the business logic for the ETL process
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Performed data migration from Excel, Sybase, Oracle to MS SQL Server using SSIS
• Normalized and de-normalized data for Data Warehouse
• Created package to transfer data between OLTP and OLAP databases
• Experience in developing OLAP Cubes, Dimensions and Data Source Views
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional standards in SQL Server
• Developed complex OLAP cubes with fact measures and multiple dimension hierarchies using partitions, KPIs, Perspectives and created various users, roles and assigned necessary permissions.
• Created hierarchies and partitions for improving SSAS cube performance.
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS)
• Deployed and uploaded the SSRS reports to Report Manager and called reports through a URL from .Net API for the end users and involved in enhancements and modifications.
• Involved in migrating SQL Server databases to SQL Azure database using SQL Azure Migration Wizard
• Created various kinds of reports using power BI based on the client’s needs
• Used Collections, Bulk Collections for handling large amount of data in PL/SQL
• Involved in creating visualizations and multiple dashboards in Power BI
• Calculated columns, conditional column, custom columns, created measures in Power BI.
• Responsible for creating SQL datasets for power BI and Ad-hoc reports.
• Design, Develop and Deploy Microsoft Power BI reports.
• Generated Daily, Monthly, Quarterly and Yearly reports in Power BI.
• Created Action filters, Parameters and calculated fields for preparing dashboards and worksheets in power BI.
• Responsible for scheduled job maintenance and trouble shooting.
• Maintained database for inventory, billing and invoice systems and created dynamic stored procedures to retrieve the customer details, payment history by giving related parameters
• Worked with Share Point to publish and share reports.
• Point of contact for all the production issues.

Environment: T-SQL, SQL Profiler, Oracle 11g, Erwin, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Microsoft Share Point Server, Azure, .Net, Power BI

Confidential, Chicago IL

MSBI Developer

Responsibilities:

• Involved in creating Physical and Logical models using Erwin
• Involved in creating extensive dynamic SQL to accommodate business requirements
• Involved in documenting management procedures, plans and processes
• Implemented data strategic techniques for SQL server 2008
• Created complex store procedures, triggers, tables, views and other SQL joins and statements for applications using T-SQL
• Involved in performance tuning using indexing (Clustered, Non Clustered) tables
• Worked on Query Optimization, execution plans, trace flags and SQL Profiler
• Used System tables, System stored procedure, DBCC commands for database maintenance.
• Used BCP Utility in stored procedures to generate output files in text format.
• Used scripts and variables, email notifications for ETL process using Data integrator
• Developing data models and data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema etc
• Performed ETL operations to support data loads and transformations using SSIS
• Extensively used SSIS in creating complex packages using proper control flow and data flow elements with error handling.
• Created, fixed and maintained daily, monthly jobs scheduled
• Wrote stored procedures and user defined scalar functions to be used in SSIS packages in SQL scripts
• Optimized ETL packages by increasing memory buffer size and by increasing Max Concurrent Executable
• Enhancing and deploying SSIS packages from development server to production server.
• Responsible for creating MDX queries in SSAS.
• Normalized and De normalized entities for data warehouse.
• Created and Managed OLAP cubes using SSAS
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS
• Monitored daily processes for different data loads and resolved issues
• Created Power BI Reports using the Tabular SSAS models in PowerBI desktop and published them to Power BI Service using star schema
• Developed custom calculated measures in power BI to satisfy Business needs
• Migrated existing self-service reports and adhoc reports to power BI.
• Used bar charts, bubble charts and Power map to solve business requirements with Power BI.
• Worked on deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports
• Created tabular, matrix, chart, drilldown, parameterized, cascaded reports and dashboards and scorecard reports
• Configured and deployed SSRS reports in different departments onto Microsoft SharePoint Server.

Environment: Erwin, T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Share Point Server, SQL Profiler, MDX

Confidential

SQL BI Developer

Responsibilities:

• Created new databases and objects such as tables, store procedures, constraints and indexes to maintain referential integrity of data
• Develop various T-SQL store procedures, triggers, views and adding/ changing tables for data load, transformation and extraction.
• Performed T-SQL tuning and optimized queries by deleting unnecessary columns, eliminating inconsistent data, normalization of tables and created clustered/ non-clustered indexes wherever necessary
• Developed advanced SQL Queries with multiple table joins, functions, subqueries, set operations and T-SQL stored procedures, user defined functions for data analysis
• Develop and implement databases, data collection systems, data analytics and other data strategies that optimize statistical efficiency and quality
• Involved in data validation and involved in back-end testing and worked with data quality issues.
• Created and customized SSIS packages and used SSIS to load data from different sources
• Performed daily and weekly data loads by scheduling corresponding ETL jobs in SQL server agent
• Created data flow transformations (Data conversions, export Column, Merge Join, Sort, Union all, Conditional Split and more) for existing/new packages
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to development servers.
• Participates in all phases of SDLC while developing logical architecture for SSIS packages.
• Utilized various data flow transformations like lookup, row count, data conversions, conditional split, sort and many more to migrate data between data sources as per business requirements.
• Responsible for validation and deployment of SSIS packages from development to QA and production environment
• Worked on OLAP Cubes in SSAS
• Developed MDX queries and Data Mining Expressions (DMX) queries for SSAS and SSRS.
• Involved in identifying, analyzing and interpreting trends and patterns in large data sets through ad-hoc reports
• Designed and managed various reports like sub-reports, parameterized, drill through, and drill down reports using data warehouse, analysis services or cube as a source.
• Extracted data tables using custom generated queries from Excel, Access/SQL database and providing extracted data as input to Tableau.
• Created Tableau dashboards, scorecards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created SQL queries for testing the tableau dashboards.
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• Created reports and forms using Oracle Apex
• Involved in security related issues by creating user logins, roles, permissions and granting access to database according to their role.
• Documented all processes and tasks of all databases, store procedures, functions, views for future reference and maintenance.
• Point of contact of all production issues.

Environment: T-SQL, MDX, DMX, MS Access, Oracle 9i, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Tableau.

Confidential, Atlanta, GA

MSBI Developer

Responsibilities:

• Actively involved as a part of team for gathering and analyzing the needs of end user requirements, analyzing and designing software solution and database.
• Experience in the development of database in a strategic, logical and creative solutions to challenging problems
• Developed, created and managed complex stored procedure in SQL Server 2008 to support the functionality of various front-end applications and performing different data operations like data profiling and data verification.
• Used SQL Profiler along with data tuning advisor for optimizing complex SQL code
• Ensured integrity on database by creating triggers and constraints to make sure the data is always stored in a consistent way at any given point of time
• Designed and developed SSIS ETL packages to Extract, Transform and Load data from OLTP system to data warehouse and data marts.
• Involved in complete SSIS life cycle in creating packages, building, deploying and executing the packages in development, test and production environments
• Worked on various transformations like Execute SQL Task, Execute Package Task, Conditional Split, Script Component, Merge and Lookup while loading the data into destination.
• Involved in ETL architecture enhancements to increase the performance using Query Optimizer
• Implemented Event Handlers and Error Handling in SSIS packages
• Configured data loading in Slowly Changing Dimension using Slowly Changing Dimension Wizard
• Knowledge of developing reports from cubes for analyzing data, also debugged data connections, Data Sources and Data Source Views
• Implemented attribute relationships and hierarchies to design more aggregations in order to improve summarization performances of queries
• Designed, recorded and executed macros to automate data entry inputs
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection
• Created Parameterized Reports, Cross-Tab Reports, Drilldown reports and Summary Reports using SSRS.
• Created report snapshots to improve the performance of SSRS
• Performed detailed documentation such as Technical Specification, Design Document, Status Reports

Environment: T-SQL, MDX, DMX, MS Access, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Confidential

SQL Server Developer

Responsibilities:

• Involved in Physical and Logical design of the Databases
• Interacted with front end developers and managers to analyze the need of business requirement and developed technical specifications
• Day-to-day incident management; Production issue handling; User follow up
• Created Database Objects-Tables, Views, User defined functions, Triggers, Procedures
• Used .Net provider Data Reader source to read from RDBMS Sources
• Worked on C#.Net
• Perform code reviews, design reviews and performance tuning
• Created SSIS packages to get data from different sources, consolidate and merge into one single source
• Implemented different types of constraints on tables
• Used SQL Profiler to debug T-SQL and slow running queries
• Monitored performance and optimized SQL queries for maximum efficiency
• Created levels of Data Flow Diagram using Microsoft Office Visio
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases
• Used complex queries to pull data from excel as well as other databases to the table that has been designed schema
• Used Tag-smart for linking the files with the database and creating XML files
• Optimized the performance of various stored procedures by redesigning T-SQL queries and changing connection and server level settings
• Generated and validated different reports using Report Builder.
• Performed Administrative tasks like managing roles, users, profiles and creating scheduling maintenances and backups to database
• Troubleshooting problems related with databases, application tools, development tools and minimizing production down issues

Environment: T-SQL, MS Visio, SQL Server Integration Services (SSIS), .Net, Tag smart, Altova