PROFESSIONAL SUMMARY:

• Microsoft Business Intelligence Developer with over 9+ years of experience in Healthcare, Banking, Retail and Insurance 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.
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
• Thorough knowledge of addressing Performance Issues and involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files.
• Expertise in Unit Testing, Functional Testing, System Integration Testing, Review Test Cases and Test Results.
• Strong understanding in Software Development Life cycle.
• Analyze, design and provide technical solutions in a consultative capacity for business scenarios.
• Mapped data from logical data model and physical data model into database objects.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Data Mapping Skills, Data Migration Techniques, Scheduling and Maintaining ETL Framework for different processes.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL Server 2000/2005/2008.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Designed and developed reports using SSRS, Power BI, Tableau.
• Successfully developed business reports using SSRS in deadline-oriented environments.
• Good understanding of SSAS, OLAP cubes and Tabular Model.
• Experience with Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards.
• Created Scorecards/Dashboard in SSRS/Power BI.
• Scheduled and monitored SSRS and Tableau report subscription and deliveries such as Email Delivery and File Share Delivery as required.
• Created apps and apps workspaces in Tableau.
• Expert in developing and modifying multidimensional cubes using SQL Server Analysis Services (SSAS).
• Designed complex data intensive reports in Tableau utilizing various graph features such as gauge, funnel, line better business analysis.
• Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas and user-defined functions.
• 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:

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: SSIS, SSRS, SSAS, Microsoft Power BI, MS Excel, Tableau, SAP Business Objects 6.x, BIRT.

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

Data Modeling Tools: Microsoft Visio 2000/2003, Altova tool

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling

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

Version Control: SVN, TFS, JIRA

Big Data Platforms: Amazon AWS, HDFS, Redshift

Other Tools: Autosys CA Workload Automation Tool

PROFESSIONAL EXPERIENCE:

Confidential, Durham-NC

Datawarehouse Developer

Responsibilities:

• Involved in gathering, understanding and validating the project specifications.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints and business rules using T-SQL.
• Closely working with category for implementation master data management (MDM) of new products, customers and vendors.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services.
• Developed complex T-SQL queries for the ETL packages.
• Designed packages in SSIS with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.
• Good understanding and experience in SQL with new features.
• Create and maintain data model/architecture standards, including master data management (MDM).
• Used master data management (MDM) to define data.
• Built Synchronous and Asynchronous scripting component for different modes of output.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Created user variables, property expressions, script task in SSIS.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Designed Cascading (Collapsed), Printable, interacted reports (drill-down and sorting functionality).
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Gave an advance Power BI to top stakeholders and team members.
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.

Environment: SQL Server 2017, T-SQL, SSMS 2017, MS SQL reporting Services, Visual Studio 2017, MS-Excel, Power BI 2019, SSAS, SSRS, Service Now Project Management Tool.

Confidential, Durham-NC

SQL BI / MSBI / Datawarehouse Developer

Responsibilities:

• Organize stand-ups with Business Analysts, Developers and DBAs to discuss documented initial requirements, access controls and weekly deliverables. Created and assigned JIRAs on weekly sprint.
• Use of T-SQL Fine Tuning, Performance Tuning and Error Handling Techniques in Pre-Staging and Stage load steps.
• Developed SSIS ETL process for Enterprise Program Integrity to migrate off of existing data coping with the fluctuating requirements.
• Keeping a track of XML extracts Ftp’d into Data Warehouse - Extracts that included trade, position and data reports at the End of Day (EOD) and pre-scheduled times throughout the day.
• Developed ETL process to consume EUC extracts (.txt and .csv), perform ELT, load into Datawarehouse and generate output file in elf format.
• Created log tables for Process log, Package log, error log, Number of files and row count.
• Extensive use of Stored procedures and Execution plans to process and load data into final tables and output Trade, Position, Profit & Loss data for consumption by elf output files.
• Created multiple email alerts based on various conditions (like, load complete/failure, SFTP download error, files archival error) within SSIS and SQL Agent Job.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Provided Production support after Go-LIVE and to end user with Pre-Process and Post-Completion documentation before signing off.
• Involved in assisting SSRS report re-design. Re design included both report level and database level changes.
• Responsible for stylish design layout like Pie charts, Graphs and Linked Reports.
• Designed complex data intensive reports in Tableau utilizing various graph features such as gauge, funnel, line better business analysis.

Environment: SQL Server 2017, Oracle 9i/10g, Visual Studio 2013 and 2015, MS-Excel, AutoSys CA Workload Automation Tool, Red Gate SQL Compare Tool, JIRA.

Confidential, Durham-NC

SQL BI / MSBI / Datawarehouse Developer

Responsibilities:

• Coordinated with the technical team to transform the relevant/approved BRD to FRS.
• Worked on modifying table structures for entire application using designed index and views to speed up query performance.
• Developed SSIS packages to load data from the flat files pipe delimited and comma delimited to the staging tables and normalized tables.
• Fine-tuned the SQL queries, improving the database performance by 5%.
• Usage of T-SQL to categorize child care providers according to their number of kids to gain child care subsidies.
• Developed business logic according to the end client requirements and created SSIS packages.
• Worked on ETL tools to segregate customers records according to benefits acquired depending on their number of kids.
• Created SSIS packages for Incremental Loading only for child care subsidies data into Data Mart.
• Worked on creating parameterized report summaries on top of fact tables for each subsidy information.
• Worked on creating reports on excel data by loading data from excel into a staging database using SSIS.
• Created table structures for the process. Generated parameterized reports with static and dynamic pages based on the subsidy information.
• Involved in Creation of Dimensions using star and snow flake Schema in SSAS.
• Used Power BI tools and DAX queries to clean, transform and model raw customer assets related data.
• Used Power BI built-in and custom visuals to create dynamic dashboards for provider subsidy data.
• Deployed reports to the server and scheduled deployment with subscriptions.

Environment: SQL Server 2014, 2016 Data Tools (SSIS, SSRS), Power BI, MS-Excel, JIRA

Confidential - Secaucus, NJ

BI Developer

Responsibilities:

• Involved with Business Analyst to gather requirements and translate requirements to develop strategies and governance practices that help move the business forward.
• Analyze the scope of customers requirements for data migration projects, design and document solid migration plans and deliver migration services.
• Involved in bulk Data Migration from different sources to SQL Server 2012 as per project needs for data analyzing using SSIS.
• Migrated data from Netezza into staging area and retrieved metadata structure.
• Created views to restrict access to specific rows and columns in tables for security.
• Involved in designing database by applying Stored Procedures and Constraints according to business logic
• Developed ETL using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) from disparate data sources on strong understanding of source and target data structures, ETL processes and Data warehouse schemas.
• Removed duplicate values by creating packages in SSIS using Lookup and Fuzzy Lookup.
• Utilized parameters to configure SSIS packages, improving the migration process.
• Developed Incremental Load using SCD in SSDT Visual Studio to load updated data from clients.
• Design and develop Reports from Data Warehouse using SSRS & SQL Stored Procedures.
• Experienced in 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.
• Experienced mentoring MSBI interns in the company with the architecture and making familiar with OLTP data.

Environment: SQL Server 2012, 2014 Data Tools (SSIS, SSRS), MS-Excel, JIRA