SUMMARY

• Around 6 Years in Business Intelligence (BI) associate with solid understanding of Data Management System, Business Requirements Gathering, Business Process Flow, Data Analysis, Data Mapping, Data Transformation, Reporting, multidimensional Data Modeling (Cube) and Business Analysis, Database Migrations.
• Professional expertise in all phases and methodologies of Software Development Life Cycle including Waterfall, Agile/Scrum, Hybrid.
• Emphasis on DRY principle, generic code development.
• Worked with GIT Repositories, Bitbucket source.
• Worked in different database & data warehouse environment as Microsoft SQL Server 2017/ 2016/ 2012/2008 R2/2008, Oracle 9i/10g/11g/12c, Oracle SQL Developer version 3.0/4.0, MySQL, Postgres 9.2, Anaconda (Python Programing), Microsoft C#.Net
• Worked in different BI tools such as MSBI, Tableau, QuickSight(AWS), ProClarity (Multidimensional Cube browsing) and PowerBI
• Professional expertise in all modules of MSBI such as SSRS, SSIS, SSAS.
• Proficient in developing Complex and graphical reports with and without Excel Office writer SSRS plugin. Extensions, package development (for ETL) and Cube designing and processing, MDX queries, PL - SQL, T-SQL.
• Proficient in Microsoft Office Excel with Macro Wring, Conditional formatting, Data Table related Applications such as Pivot, Implementing Formulae.
• Functional experience with concentration on Project Management, Business Analysis, Use Case Modeling using UML, Data Modeling, Change Management, QA Testing, Task Distribution, Sprint and Scrum Meetings.
• Expertise in Data mining, Machine Learning, AI with Python Programing. Also Worked on Deep Learning using CNN.
• Proficient in conducting Requirement Gathering Sessions (JAD) with end users/Stakeholders as Product Owner.
• Worked closely with Stakeholders, End Users and Business users.
• Proficient in conducting Knowledge transformation sessions with teammates, Superiors, also with Business Users.
• Expertise in Defect management as Defect Prevention Coordinator, involved in Test Log, Defect Log, Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Worked efficiently on multiple projects spanning over different releases at the same time.
• Documentation and version control using JIRA, SVN, SharePoint at each phase of development and deployment with proper signup/approval.
• Wring and publishing case studies for Development practices and open issues with solutions/ workaround with external Software/Tools used in Project.

TECHNICAL SKILLS

Programing/Scripting Languages: SQL, PL-SQL, Python, C, C++, MDX, Java

Languages: Go Language, R, C#.Net, JavaScript, PHP, HTML, VB Script, Shell Script

Frameworks & Tools: MSBI (SSIS+SSRS+SSAS), MS SQL Server 2016/ 2012/2008 R2/2008, MySQL, Git, ProClarity, Soft Artisans plugin, Clould9, MS Office products

Secondary: Tableau, PowerBI, Redshift(AWS), QuickSight(AWS), Conda, Rstudio, TensorFlow, Hadoop, Maven, IBM Blumix IOT, Intel Galileo Gen 2 IOT, Arduino s/w

Environment: / Platforms: Linux, Windows

Project Management Skills: Agile- Kanban Process, Conducting meetings/sessions for KT, requirement analysis, Problem Solving, Sprint and Scrum meetings, Defect Prevention (coordinator), Documentation, User story Writing, Task Distribution

Interested Areas: Software Engineering, Business Intelligence, Data Mining, Data Analytics, Machine Learning, Data Structure

PROFESSIONAL EXPERIENCE

Confidential, Chicago

MSBI Developer

Responsibilities:

• Designed T-SQL stored procedures and functions in SSIS and SSRS.
• Designed user defined functions, stored procedures, views and sub queries.
• Designed and built dynamic ETL packages to extract data from different sources such as SQL Database, Oracle, CSV, and Excel for incremental and full data warehouse refresh.
• Transformed and cleansed source data through Lookups, Stored Procedures, Derived Column, Fuzzy Lookup and expressions.
• Used SSIS Data Flow Tasks, SQL Merge, and OLE DB Command to load data to SQL database, staging area, and data warehouse (DWH).
• Used SSIS variables, parameters, and expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc.
• Used SSIS Error Log Provider for SQL Server to implement Package and Container level error and event handling to a SQL Server DB.
• Used Integration Services Catalogs and SQL Agent to schedule execution of SSIS packages.
• Monitored and maintained existing ETL packages and Reports to fix issues and bugs and troubleshooting.
• Designed and built SSRS Reports (Standard and Multi tab Reporting) and tabular summary reports with drill down and drill through features using MDX and T-SQL.
• Published SSRS Reports to site and Reporting Manager.
• Designed Cascading parameterize reports using SSRS
• Documented and checked in Business Intelligence (BI) artifacts to a source control.
• Determined business and systems requirements and modified reports according to the requirement of the end users.

Environment: SQL Server 2014/2012/2008/ R2, SSIS, SSAS, SSRS, Windows NT, Microsoft Access, Team Foundation Server, SharePoint, Power Pivot, T-SQL.

Confidential, Fort Wayne, IN

Assistant

Responsibilities:

• Worked as an Analyst for Database, Web Page designing, Software Engineering and Operating System courses at Confidential .
• This role includes developing demo projects (with front end back end development) web development
• Database lab work - Data Analysis, Reports, Database Concepts, Performance tuning using Execution Plan, preparing for lectures notes/slides, Project Documentation.

Environment: SQL Server 2013, Git, Bitbucket, MySQL, Apache PHP, Oracle SQL Developer, Cloud9

Confidential

MSBI Associate

Responsibilities:

• Communication with Clients throughout SDLC process, for Business understanding, Requirement change & gathering through incremental development
• Signup process, product information and reviews. Also maintaining documents and records simultaneously throughout SDLC process
• Implementing Business ideas/rules /concepts/ problem solving, creating equivalent logical code and formulas in report with data visualization which helps users to work efficiently and decision making.
• Designed and developed complex reports with graphical visualization using SSRS and office writer (Excel Reports).
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Involved in store procedures and TSQL development for reports and ETLs.
• Unit testing, defect tracking, creating test log for each project/product/artifact.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Automation of process for specific user group using web applications and Excel macro.
• Facilitate JAD sessions with several internal and external teams. Taking session with clients/end users to give training and awareness of product before UAT starts.
• Created dimension hierarchies and cube calculations, actions, partitions, aggregations and perspectives using SSAS.
• Created multidimensional OLAP Cubes and modified the Relationship between Measure groups and dimensions using SQL Server Analysis Services.

Environment: SQL Server 2008 (onwards), SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), ProClarity, MDX, Soft Artisans Office writer (Plug in), MS Excel (macro), SVN, SharePoint, JIRA, Tabulae