SUMMARY:

• Information Systems with 4+years of academic and industrial experience in business intelligence and data analysis
• Passionate to learn new technologies and eager to develop applications that simplify complex tasks
• Experience in generating dashboards, user stories and reports for providing actionable insights to improve business processes using business intelligence tools likeTableau, Qlik Sense, Yellowfin BI, Power BI, Spotfire and Excel
• Knowledge of ETL process, extracted, transformed and loaded data in SQL Server Integration tool SSIS and Yellowfin BI tools
• Involved in development and implementation of SSIS and SSRS application solutions for various usages across the department
• Excellent knowledge of SQL databases like Oracle, SQL Server, MySQL and P roficiency in designing and optimizing SQL, ad hoc and PL/SQL queries, views, stored procedures and functions
• Knowledge of statistical packages for analyzing large datasets using R programming, Pythonand MS Excel (Pivot tables and Charts, Advanced excel functions, Statistics, Macros, V - Lookup tables)
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, packages, joins and indexes
• Strong knowledge of data mining algorithms, classification, clustering, and association rule mining
• Very good understanding of data warehousing concepts, data analysis, data warehouse architecture and designing
• Good knowledge on Machine Learning algorithms like Classification and Regression with KNN Model, Decision Tree Model, Naïve Bayes Model, Logistic Regression
• Documenting data mapping document after each assignment and wrote the transformation rules for each field as applicable
• Experience in user requirements gathering, Use Case design/diagrams and analysis, Use Case specifications, Scenarios, Business processes, Work flow diagrams, process flows, Sequence diagrams, Activity diagrams and technical documentation, using Unified Modeling Language (UML)
• Experience in Project management - can produce work breakdown structure (WBS), Integrated master plan and schedule

TECHNICAL SKILLS:

Business Intelligence: Tableau 9/10, Qlik Sense3.2, Yellowfin BI 7.4/8.1,Microsoft Power BI, Spotfire, MS Excel

Programming: R, Python, T-SQL, PL/SQL, MySQL, HTML, CSS, PHP, JAVASCRIPT

Software/Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), MS SQL Server 2008/2012/2015 , Oracle SQL Developer,BMC Remedy, GIT, JIRA, Team Foundation Server (TFS)

Microsoft Suite: MS Excel, MS SharePoint, MS Visio, MS Access Database, MS Word, MS Power point

R Programming: Udemy - License no FG6UUH4WZYS9

Tableau 10 Desktop Udemy: UC-E1HEWXGL

Green Belt: Lean Six Sigma

WORK EXPERIENCE:

Confidential

Business Intelligence Developer

Responsibilities:

• Work with business users to determine business requirements, priorities, define key performance indicators, and develop Business Intelligence solutions and Data Warehouse strategies
• Establish, connect and maintain JDBC, BMC Remedy, Google Analytics, SharePointconnectors to trigger data from Yellowfin transformations and data sources
• Extract data using Yellowfin ETL Transformation fromOracle, SharePoint, Google Analytics, XML and flat files, perform transformations and populate the data warehouse for reporting
• Use SQL queries to mine data from Oracle data warehouse and combine this data with other static data files
• Data cleaning of Flat files, Google Analytics and SharePoint data in Python using Pandas and Numpy libraries and exporting into CMDB database
• Develop and design various statistical reports and dynamicdashboards to highlight data analysis trends and various analytical KPIs as per business requirements
• Automatenumerousmanual tasks and reports using BI, SQL queries, functions which cutthe cost and time by 90 percent
• Create various events like Broadcasting reports and emails, FTP Schedulers, Timeline and Decision-making events in BI
• Deploy and support the Reports, Dashboards and ETL Transformations through various phases of Software Development Lifecycle and manage product delivery by agile methodology
• Participate in sessions with management, SME, vendors, users and other stakeholders for open and pending issues,involved in reviewing/analyzing business requirement documents (BRD) / functional specifications/use cases

Environment: Oracle 11g, Yellowfin BI, SQL, Python, Power BI, Spotfire, Google Analytics, SharePoint, MS Excel, BMC Remedy

Confidential

Business Intelligence Analyst

Responsibilities:

• Converted business requirements into technical specifications for developing business intelligence and SQL reports
• Define, designed and built BI dashboards, reports and metrics to meet the needs of Credible and Partner stakeholders
• Wrote complex SQL queries using joins, subqueries, views and stored procedures to retrieve data from the database
• Use various transformations such as an Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner to design ETL mappings to ensure optimized queries in ETL process
• Expert level capability in Yellowfin calculations and applying complex, compound calculations to large, complex data sets
• Performed ad-hoc requests for clients using customized SQL queries and maintain a 95% satisfaction on reports and tickets
• Engineered the concept of auditing the partner state reports using null data and data validation business rules using Yellowfin business intelligence tool and reduced the partner efforts by automating the reports to almost 90%
• Product owner and QA owner for 100+ product backlog item (PBI) over time and have a 96% report release efficiency
• Acted as a subject matter expert (SME) on state reports and Yellowfin BI for partners and work on numerous partner calls
• Involved in creation and execution of test plan, test scenarios and test cases - integration testing, negative testing and UAT
• Implemented permissions for users and ensure user security according to various clearance levels of business users

Environment: MS SQL Server 2015, Yellowfin BI, SQL, SSRS, TFS, JIRA, SSIS, T-SQL, MS Excel

Confidential

Business Analyst

Responsibilities:

• Gathered and documented functional and technical report requirements and translated requirements into reporting solutions
• Extensive experience in creating data models, graphical interactive UI and dashboards using Qlik Sense by extracting data from multiple sources like MS SQL Server 2012and Flat Files
• Developed Qlik Sense Dashboards based on DAR (Dashboard Analysis & Reporting) principle using Filters, Chart (Drill Down, Drill Up and Cyclic Grouping), List Box, Input Field, Table Box, Calendar, Date Island
• Implemented and tuned procedures, functions, triggers, views and tables along with the development of queries and models in MS SQL server 2012 and SQL Server management studio
• Communicated Project Requirements, Business Issues, created Solutions and made recommendations.Performed GAP Analysis, Data Analysis, Data Requirement Analysis and Data Mapping
• Defined Functional Requirements and segregated them into high level and low-level use cases, activity diagrams using UML
• Developed applications in Qlik Sense Desktop and shared the apps with the team through Qlik Sense Cloud, showcased stories and presented dashboards to business users and cross functional teams
• Documenting and diagramming business requirements, processes, business plans development and strategies
• Produced System Diagrams, Business Requirements Documents, Report Specifications, Workflows and other documentations as required for Project Analysis, Planning and Design

Environment: MS SQL Server 2012, T-SQL, Qlik Sense 3, MS Excel, MS Office, SAS, UML

Confidential, Baltimore

Data Analyst

Responsibilities:

• Designed and developed database schemas in MySQL database to store business school student and faculty data
• Created surveys in Survey Monkey and made reports on responses received for different business requirements
• Evaluated end of semester faculty and student feedback evaluations, effectively communicated the analytical results and insights drawn from the reports and dashboards to support academic decisions using Tableau and MS Excel
• Worked on Microsoft SharePoint projects to automate different tasks saving manual efforts for business managers and faculty
• Oversaw the department’s ticketing system, created reports and dashboards to keep track of the open and resolved tickets
• Generated ad hoc and bi-weekly pay reports using SQL server reporting services (SSRS) and utilizing complex functions to query the database to generate different types of tables, calculated fields, charts, lists and drop-down list parameter reports
• Designed packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)

Environment: MS SQL Server 2008, T-SQL, Tableau 9, Python, MS Excel, MySQL, SSRS, SSIS. SharePoint, Survey Monkey

Confidential

Junior Business Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system with critical business users and stakeholders
• Provided support to the Sr. Analysts about decoding and decrypting business requirement documents
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP
• Designed the system, prepared UML and sequence diagrams using Rational Rose
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML)