SUMMARY

• Around 8 years of experience in IT with Database applications and Business Intelligence/ETL design & development, and Data Analysis in Production, Development, Testing and Staging Environments.
• Expertise in MS SQL Server 2017/ 2014/2012/2008 R2/2005 Full stack of MSBI products like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis services (SSAS).
• Contributed in the Organization’s/Client’s adaptability, agility, and ability to manage constant change through innovative ideology that made me success in the project.
• Expertise in defining the business process flow and gathering business requirements and analyzing user data processing needs to develop/enhance appropriate reporting systems.
• Initiated to implement technological solutions in a cost - effective way by determining the requirements of a project and communicating them clearly to the project/product stakeholders, facilitators and partners.
• Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Oracle and DB2 to MS SQL Server using SQL Server Integration Services (SSIS).
• Experience in designing, deploying and scheduling ETL solutions using SQL Server SSIS packages involving various control flow items like Loops, Bulk Inserts, Incremental Loads, FTP and Emails Alerts.
• Pro-actively worked with other ETL developers in solving complex data mappings and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Experience in providing Logging, Error handling by using Event Handler .
• Experienced in technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Worked in Normalizing and De-normalizing the tables & maintaining Referential Integrity.
• Skilled in developing SSAS Cubes, Dimensions, Facts and data source views, SSAS-Data Mining Models and Deploying cubes, Processing SSAS objects, and Creating named calculations and named queries.
• Good experience with SSRS through developing, troubleshooting deploying reports, creating report schedules, subscriptions, managing and securing reports.
• Experienced in SQL Server Reporting Services (SSRS 2014/2012) in generating complex reports in cascaded reports, parameterized reports and Ad-Hoc reports.
• Created Reports, Scorecards, KPI’s, and Dashboards using Performance Point Server 2007/SharePoint Server.
• Extensive use of DAX (Data Analysis Expressions) functions in creating Power BI Dashboards, Reports and Tabular Models.
• Expert in Configuring/Managing Power BI Gateways, Shared Datasets, Roles, Security Groups and Automated Refresh of Power BI Reports/Dashboards.
• Extensively used Date/Time, Filter, Logical, Time Intelligence and Math DAX functions in Power BI Reports.
• Expert in creating Calculated Tables, Calculated Columns, Complex Measure/Measure Groups, Hierarchies in Power BI Reports.
• Expert in creating Power BI Data Models (Star & Snowflake Schema), Meta Data Mapping and solid understand in Cardinality and Cross Filter Directions.
• Conceptual exposure in Azure Cloud platform including Azure Data Lake and Azure Data Factory and have knowledge in on-premise
• Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions (UDF’s), Cursors and Indexes using T-SQL.
• Normalization techniques on database tables, building relationships among tables using primary and foreign key constraints and worked on both Star and Snowflake Schemas as part of Data modelling.
• Expertise in creating/modifying Tables, Views, Stored Procedures, User Defined Functions (UDFs), Common Table Expressions (CTEs), Joins, Indexes, Triggers and Cursors scripting in T-SQL.
• Expertise in writing Sub-Queries and Joins to simplify complex queries involving multiple tables and established relationships between tables using Primary Key and Foreign Key Constraints.
• Expertise in creating, scheduling, monitoring, maintaining old and new SQL jobs, using SQL Server Job Agent.
• Experience in working with Agile and Waterfall methodologies in SDLC
• Good team player and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Databases: MS SQL server 2014/2012/2008 R2, Oracle 11g/10g/9i, My SQL

Programming Languages: SQL, PL/SQL, Transact- SQL, C.

ETL Tools: BIDS/SSDT, SSIS, SSAS, SSRS. Informatica Power Center 9.5 (Basics)

OLAP/Reporting Tools: MS Access, Excel, MS SQL Server Reporting Services 2014/2012/2008 R2, Power BI (Intermediate).

SQL Server Tools: SSMS, Query Analyzer, BCP, SQL server profiler, SQL Server Agent.

Data Modeling Tools: Visual Studio 2010, Microsoft Visio, Business Intelligence Development Studio (BIDS).

Other Tools: MS Office, MS Excel, MS Project, MS PowerPoint and MS Visio, and has conceptual exposure in both Azure Cloud Platform and Salesforce CRM Administration at beginner level.

Operating Systems: Windows 10/8/7/XP/Vista, MS-DOS.

Web Development: HTML, XML, and Visual Studio 2015/2017

Project Management: Scrum Framework, Agile and Waterfall methodologies.

Project Business: Business Analysis, Requirement Gathering, and Analyze them as per business needs, Process Improvement Strategies, Mentoring Junior Developers in the team, and Efforts & Resource Planning.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

POWER BI Consultant

Responsibilities:

• Understand the functional workflow of information from source systems to destination for transactional data.
• Working on multiple projects as a BI consultant on contractual basis, to fulfill the project requirements and designed documentation and created Power BI Dashboards in SoW’s for BDA and Dole.
• Used Erwin for data modeling, analytics, and data mapping for ETL process prior to load into Serner DB, along with some ancillary data sources for Kansas State’s Medicare management data and member services.
• Worked in another project with DXC for data mapping, analysis and involved in cyber security by migrating data from physical servers to (Cloud Systems) Alien Vault.
• Extensive use of DAX (Data Analysis Expressions) functions in creating Power BI Dashboards, Reports and Tabular Models.
• Expert in creating Power BI Reports, Dashboards, Power BI Apps using Power BI Desktop and Power BI Service.
• Expert in creating applications using Power Apps, Microsoft Flow and embedding into Power BI Reports/Dashboards.
• Extensively used Date/Time, Filter, Logical, Time Intelligence and Math DAX functions in Power BI Reports.
• Expert in creating Calculated Tables, Calculated Columns, Complex Measure/Measure Groups, Hierarchies in Power BI Reports.
• Expert in creating Power BI Data Models (Star & Snowflake Schema), Meta Data Mapping and solid understand in Cardinality and Cross Filter Directions.
• Good Knowledge in designing/creating Paginated Power BI Reports.
• Develop SSIS packages to export data from different sources like Oracle database, SQL Server, CSV files, Excel Files and load into staging and ODS after performing certain cleansing and profiling process.
• Implemented Error Handling and Event Handler at Packages to keep track loading process and error recovery.
• Created certain functions and stored procedures for reports and SSIS packages to implement the logic.
• Updated some pre-existed packages for performance point of view to load and process data faster.
• Created Indexes on the dataset to improve performance of the SQL query.
• Worked with cross-functional teams for some connection tickets regarding modifying some customized reports, dashboards and packages.
• Created some parameterized, drill down, drill through reports for logistic department for warehouse.
• Involve in handling tickets for changing report structure by discussion to end users.
• Involved in deployment process of reports on server and handle report security and report delivery to end user.
• Involved in upgrading the entire life cycle of the project

Environment: Erwin Tool, Oracle DB, Microsoft Report Builder 2016 (SSRS), Microsoft Visual Studio 2014/2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and Power BI Desktop.

Confidential, Duluth, GA

BI Report Developer

Responsibilities:

• Understand the functional workflow of information from source systems to destination for transactional data.
• Develop SSIS packages to export data from different sources like Oracle database, CSV files, Excel Files and load to destination for merging with JDA system.
• Load data from data mart to staging and ODS after performing certain cleansing and profiling process.
• Implemented Error Handling and Event Handler at Packages to keep track loading process and error recovery.
• Created certain script task for loading data from FTP server to packages and use incremental load to verify those data.
• Used report builder to create some new reports which replaced old reports which running on old analytics system.
• Created tabular, pie, graph charts for all transactional data for analytics processes.
• Created certain functions and stored procedures for reports and SSIS packages to implement the logic.
• Updated some preexisted packages for performance point of view to load and process data faster.
• Created Indexes on the dataset to improve performance of the SQL query.
• Worked with support team with some connection tickets regarding modifying some reports and packages.
• Work with JDA team to resolve some data issues in tables and views.
• Involved in scheduling, creating snapshots and subscription for the reports using SharePoint server.
• Created some parameterized, drill down, drill through reports for logistic department for warehouse.
• Involve in handling tickets for changing report structure by discussion to end users.
• Involved in deployment process of reports on server and handle report security and report delivery to end user.
• Involved in upgrade the entire logistic process from current system to JDA.

Environment: Oracle DB, Microsoft Report Builder 2016 (SSRS), Microsoft Visual Studio 2014/2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).

Confidential, Southfield, MI

MSBI Developer

Responsibilities:

• Gathered business requirements from business firms to understand and formulate the design of the EDW & Leather Market Forecast.
• Participated in the meetings between Business Users and EDW team to gather the Technical/functional requirements.
• Involved in JAD sessions with users explaining the data flow and sequence of events.
• Worked as a contact between the Business Users and BI technical team to convert the business requirements into technical requirements.
• Worked in developing technical solutions to business problems, or to advance a company's sales efforts, begins with defining, analyzing and documenting and managing the requirements at the project level that can help to fulfill business needs.
• Created functional requirement specifications and supporting documents for business systems.
• Created SSIS packages to move data from BPCS (ERP System) to SQL Server and to move data from Sources to Staging and to EDW
• Built various SSIS packages having different tasks and transformations for various business areas
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created traces using SQL Server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Created Dashboards using SSRS and Power BI where needed.
• Extensive use of DAX (Data Analysis Expressions) functions in creating Power BI Dashboards, Reports and Tabular Models.
• Involved in creating Power BI Reports, Dashboards, Power BI Apps using Power BI Desktop and Power BI Service.
• Extensively used Date/Time, Filter, Logical, Time Intelligence and Math DAX functions in Power BI Reports.
• Expert in creating Calculated Tables, Calculated Columns, Complex Measure/Measure Groups, Hierarchies in Power BI Reports.
• Involved in creating Power BI Data Models (Star & Snowflake Schema), Meta Data Mapping and solid understand in Cardinality and Cross Filter Directions.
• Good Knowledge in designing/creating Paginated Power BI Reports.
• Analyzed the gaps, streamlined the existing process, proposed and implemented new processes to build reporting platform moving away from citric reports
• Reverse engineered the existing applications to evaluate GAPS and recommended solutions considering new requirements in order to support the new Leather Market Forecast Initiative.
• Developed reports in SSRS charts, graphs and maps for better visualization.
• Designed drill-down and drill-through reports in SSRS, drill-through reports that can navigate to other reports or to other URL

Environment: SQL Server 2014/2012, T-SQL, Windows 10, Visual Studio 2015/2012, SSIS, SSRS, SSAS, MS-Visio, Microsoft-Office 2016, Power BI Dashboards.

Confidential, Maple Grove, MN

MSBI Developer

Responsibilities:

• Actively participated in the meetings between Business Users and Technical team to gather and discuss the business requirements and convert them into technical/functional requirements.
• Initiated to implement technological solutions in a cost-effective way by determining the requirements of a project and communicating them clearly to the project/product stakeholders, facilitators and partners.
• Designed SSIS Packages to perform the extract, transfer, and load (ETL) operations with existing data into SQL Server through OLTP database from different data sources.
• Worked with SSIS Data flow task, Transformations, For-loop containers and Fuzzy Lookups, Data conversion and configured data in slowly changing dimension.
• Worked with team to Develop and Extend the OLAP Cubes, Dimensions and data source view.
• Designed and implement Data Mart, Facts, Dimensions and OLAP Cubes using dimensional modeling standards in SQL Server 2012 that maintained data.
• Worked in the complete Data Warehouse development life cycle and actively supported business users for change requests during the project development.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
• Worked with the team in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created dashboards and custom reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed several drilldown and drill through reports using SSRS as needed by clients.
• Used Joins, sub-queries, Stored Procedures, Indexes, and Views for involving multiple tables from different databases to integrate the data as business requirements
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2012 and 2014, SSIS, SSAS, SSRS, Import/Export tools, SQL Server Agent, MS Access, T-SQL, and Windows10.