7 plus years of IT experience in Business Data Analyst, ETL and Data Warehousing professional with:
Business Intelligence, Business Analysis and Data Analysis
ETL process, AWS Redshift, SSIS, SSRS, SSAS, OBIE &MS POWER BI
Had a good working knowledge on Java and visualization on OOPS concepts
Worked with statistical tools such as R, Minitab, SAS
SQL, UML, XML and web services, documentation, usage and testing
Agile- Scrum, RUP models of Software development life cycle (SDLC)
Proficient in conducting requirements gathering sessions including Joint Application Development (JAD), moderating technical review meetings with excellent conflict resolution skills.
Experience with Big Data technologies such as Hadoop, HIVE and Mapreduce.
Expertise in understanding KPI’s, Business Process Flows, Business Process Analysis and techniques for Process Automation, Improvement and Re-engineering.
Proficient in creating requirements specifications including Project Vision, Project Scope, BRD, FRD, Test cases, Gap Analysis, Data models and Requirements traceability matrix (RTM).
Well versed in developing prototypes and wireframes for Application User Interfaces
Worked with SQL, Postgre SQL and relational databases for querying and reporting purposes.
Good experience with ETL (Extract, Transform and Load) Process using SSIS and reporting tools like TABLEAU & PERISCOPE DATA.
Had good experience in creating scripts
Worked as liaison between business and data modeler, ETL developer to implement EDW, data mapping and Master Data Management (MDM).
Competent in creating Unified Modeling Language (UML) diagrams for Business Process Modeling like Use Case Diagrams (UCD), Activity Diagrams (AD), Sequence Diagrams (SD),
Comprehensive domain knowledge of Know Your Client (KYC), On-Boarding Process, Health care, Mortgage loans, Credit Products, Auto-loan application process, Market Research Data, Info Work Bench, Client panning, Documentum.
Good understanding of Claims Management System- Claims Work Bench (CWB); Claim’s inception, submission, settlement and archival.
Experience in working with QA team in generating test plans, test scenarios, test cases, and managed complete defect tracking life cycle using various defect tracking tools.
Expertise in collaborating with Scrum team members including Product Owner and Scrum Master; proficient in creating SCRUM artifacts like User Stories / Backlogs, Burn-down charts.
Strong facilitation skills in change management and conflict resolution at various stages of project life cycle by streamlining communication among project stakeholders and interacting with the Change Control Board (CCB).
Adept in defect tracking. Creating UAT test cases and collaborating with software testing teams for creation and execution of test cases for regression, integration and systems testing.
Involved in Pre-Production activities to ensure zero defects and supported Post-Production Validation (PPV) for issues reported by the user group in the production environment.
Proficient in creating user manuals and conducting user-training sessions.
Bachelor of Technology in 2011.
Requirement Management Tools
Power Designer, MS Word, and Excel.
RUP, Waterfall, Agile.
SQL, UML, XML, Python
Business Modeling Tools
Power Designer, MS Visio
SSIS (MSBIDS 2008, 2012), OBIE
Project Management Tools
MS Project, MS Excel, SharePoint.
Defect Management Tools
AWS Redshift, S3, MS SQL Server, MS Access, Hadoop, Hive
MS Office including Visio, SharePoint, MS Project, Lotus Notes.
Tableau, Periscope Data, SSRS
Cigna, CT, USA Jan 2017 – Present
Healthcare Management System: Cigna is well renowned as a healthcare service provider across the globe. The project entails responsibility for administering, developing and maintaining the BI environments and providing day to day support within the wider IT delivery team. As a Data Analyst, the Master Data Management (MDM) project involves supporting and coaching to other members in relation to BI tools such as OBIE.
Administered Business Objects environments including user security, folder structures and publishing of content
Created ETL pipelines for data flow from various sources into raw and summary data using OBIE Edition
Analysed the pattern on data and found the best suited algorithm for predictive analytics
Hands-on experience with installing, configuring, developing on, and tuning HDFS and Hadoop
Created pipelines to transfer data flow from MongoDB into AWS Amazon S3 clusters
Monitored the MDM environment for issues and resolve as needed.
Coordinated planned upgrades, enhancements and maintenance outage windows including monitoring for potential system upgrades, service packs and Fix packs.
Collaborated with IT Staff, Systems Analysts, and business subject matter experts, to support the MDM environment.
Identified and implemented best practice models for different aspects of Business Intelligence developments and implementations.
Implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
Gathered requirement and proposed possible solutions to satisfy business needs and designed/ created star, snowflake schema models.
Environment: Tableau, OBIE, MDM, SAS, PostgreSQL, AWS Redshift, MS Visual Studio, XML, Agile, SQL Server, MS Word, MS Excel, Hadoop
Crowdfire Inc, NYC, NY Mar 2016 – Jan 2017
Business / Data Analyst
Social Media Marketing tool: The project entails the development of an enhanced product named Crowdfire app. The main objective of the project is to implement Data Migration process to support the new functionality that requires an upgraded data formats and increased data volume. This transition process facilitates all the data by providing a consolidated view of the data associated with customer information, contracts, products, risk metrics and KPI’s and KYC details. This data is eventually drilled by the business users through dashboard – reports for investment decisions.
Created dashboards and charts in Periscope Data by writing complex SQL queries from AWS Amazon Redshift data source
Performed analysis using Mixpanel & Google Analytics to ensure the timely adjustment/optimization of campaigns, along with other client-specific analysis such as customer segmentation, profiling & competitive market research
Allocated AWS S3 with different clusters and objects to include data flow from AWS Glacier and into Redshift Spectrum
Manipulated large data sets & evaluated IT/IS deliverables by collaborating with multiple teams & reviewing technical system requirements to extrapolate significant results from various performance metrics
Involved in defining the source to target data mappings, business rules and data definitions
Performed data profiling in the source systems to avoid data anomalies and ensure data quality
Coordinated Phased Data Migration process to handle large and complex volumes of data and address dashboard reporting capabilities.
Supervised and worked closely with data coordinators, and other team members to provide technical support and end user training on the developed applications.
Authored progress and completion reports, which were then submitted to project management on a weekly basis.
Created scripts using Python language and libraries such as numpy and panda
Utilized SQL queries to perform data cleansing through imposing data constraints
Published functional requirements, Screen prototypes on portal for access by all project participants.
Produced Requirements Traceability Matrices to support the application development that included Business Requirements, Actor Survey, Use Case Survey, Supplementary Specification Survey, Analysis Model, and Design Test Case Survey.
Assisted QA department to write and execute Test plans and Test Cases; and worked on UAT
Environment: Postgre SQL, MS Office, MS Visio, Jira, AWS Redshift, Periscope Data, Python platform
KS&R, New York City, NY Feb 2014 – Dec 2015
Customer Segmentation Market Research: The main objective of the project is to manage the client’s customer data, segment them and conduct surveys. The data is then transformed into valuable reports from master data warehouse as a part of MDM. The data which is collected from various sources are then stagged and business transformation is applied before being loaded into data warehouse.
The project followed the Agile methodology and required involvement in all phases of the SDLC
Coordinated and participated in brainstorming sessions with the Product Owner and SMEs in understanding the requirements pertaining to the Customer Segmentation in order to design the Business Requirements Document (BRD)
Created Process Work flows for the end-to-end solution, Functional Specifications, and Project Initiation documents along with Review of Existing Scope document.
Analyzed Product Scope and future phase requirements and prepared the Functional Requirement Document (FRD).
Responsible for Documenting Work flows and results of business analysis and obtaining sign-off from client on specifications.
Responsible for documenting functional specification documents based on user requirements using Use Case Modeling.
Created the meta-data to identify raw and summary data in the data warehouse as a part of MDM.
Facilitated Business Process Modeling of As-Is and To-Be internal process as per BPM notations common to stakeholders and developers using Power Designer.
Skillful in creating Tables, Views, Indexes and other SQL joins
Coordinated in developing optimized SQL Server stored procedures, functions, and database views
Distributed Trading Reports in multiple formats using SQL Server Reporting Services (SSRS)
Responsible for Data Analysis using Business Intelligence tools to Extract, Transform and Load critical data.
Designed & coded standalone application in .NET & HTML through MS Visual Studio TFS that parses query strings & fetches data from SQL Server database & generates batch of Email templates with unique User IDs.
Identified data patterns by designing corresponding machine learning algorithms using Java & Weka
Designed & implemented ETL strategies for integrating data into transactional systems & data warehouses
Developed Visual Studio scripts to automate, systemize SSRS report delivery thereby reducing error proneness
Performed end to end data integrity testing by creating & executing positive/negative test scenarios using JIRA
Cleansed source data by identifying data inconsistencies & produced Tableau reports in SQL Server environment
Worked with the Business Objects developers to provide input for generating automated and ad-hoc Business reports.
Involved in Data Warehouse design for the Asset Management module.
Assisted system testers in QA activities like designing, creating and reviewing the test scripts and test cases.
Environment: Agile Methodology, SQL Server, Tableau, MDM, Microsoft Office Suite, Microsoft Visio, Microsoft Project, SSRS
Cisco Systems (Tech Mahindra Inc., India) Jan 2013 – Jan 2014
Business Intelligence Analyst
EDW- Large Scale Services (LSS): EDW captures all the data movement and transformation occurring within Sales systems like Sales Crediting, Claiming & Adjustment, Hierarchy, Territory Management Planning, and Reporting across Cisco. As part of large scale services project, the principle objective was data migration from Oracle apps 11 legacy platform to R12.inorder to ensure business continuity with source and facilitate migration process for seamless BI reports. This process not only addressed the issues of handling huge data loads across the enterprise, but also supported Ad-hoc reports for OLTP/OLAP systems. As a HealthCare Business Intelligence Analyst, my prime responsibilities were to gather the business requirements from the data warehouse analysis team, develop ETL mappings for data migration and support change requests management
Identified stakeholders of the project; prepared interview questionnaire for requirement elicitation on benefits, claims submission and CWB enhancements; interviewed SMEs and documented requirements. Gathered user and business requirements through interviews, surveys, prototyping and observing from subject matter experts.
Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software. Documented both Business Requirement Document (BRD) and Functional Requirement Document (FRD).
Extensively involved in implementing the Software Development Life Cycle phases from identifying requirements to conducting UAT.
Gained exposure to OLTP/OLAP systems to develop ETL mappings using SSIS
Documented all custom and system modification.
Authored progress and completion reports and submitted them to the project manager on a weekly basis
Conducted User Acceptance Testing (UAT) and verified performance, reliability and fault tolerance issues
Performed Gap analysis by identifying existing processes and technologies and documented the enhancements needed to meet the end state requirements.
Suggested measures and recommendations to improve the current application performance.
Involved in preparing a simple and detailed user manual for the application, intended for a novice user.
Environment: Oracle, SQL Server 2010, XML, Visio, MS Project, Quality Center, MS Excel, MS Word.
Tata Consultancy Services, Chennai, India Dec 2010 – Jan 2013
Business/ Data Analyst
Claims Management System: USAA is one among the top 10 providers of home and automobile insurance across the United States. The purpose of this project was to enhance its Claims Work Bench (CWB) application module, which handles all auto and home insurance claims, from inception of claim until settlement and archiving. The project was entailed to migrate from existing legacy systems to web-based interactive claims processing systems associated with CWB module in order to help insurers improve efficiency, reduce the cost of service and support, and improve the speed of response and customer satisfaction studying important metrics (KPI)
Gathered user and business requirements through interviews, surveys, prototyping and observing from subject matter experts.
Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software considering all important KPI’s. Documented both Business Requirement Document (BRD) and Functional Requirement Document (FRD).
Interviewed key stakeholders to prepare Requirements Specification document & project artifacts for project kick-off
Acted as a liaison between clients & technical developers to elicit requirements, document system design
Coded part of auto loan application module in PS customized framework using Java/J2EE & SOAP XML Web services with Object Oriented Programming concepts (OOPS)
Worked for an Agile Database team with 8 members providing guidance on data architecture & design documentation
Launched Pilot Phase of the loan application process to gather results regarding maximum profit yielding component
Planned and defined system requirements to use case, use case scenario and use case narrative using the UML methodologies.
Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion.
Used SQL queries for organizing and abstracting data from MS Access databases as well as created reports using SSRS
Created mock-up forms in MS Access for better visualization and understanding of the software solution
Environment: Java, OOPS, MS Visual Studio, XML, Waterfall, SQL Server 2008, MS Word, MS Excel, MS Access.