SUMMARY

• 6 years of strong experience in business analysis, data analysis, design, development, testing and implementation of software development projects
• Hands on experience in data integration, data management, data governance, data analytics and business intelligence projects
• Strong understanding of Data warehouse and Business Intelligence concepts including hands on expertise in several ETL and BI tools such as Azure Data Factory, Microsoft SSIS & SSRS, Informatica Powercenter, TIBCO Spotfire, Power BI and Tableau
• Hands on experience in requirement gathering, analysis and development in enterprise data management & data governance projects including expertise in tools such as EBX, Informatica MDM, IDQ
• Strong knowledge of Relational Databases with advance SQL skills to proficiently write complex SQL queries for data analysis, development and validation
• Worked on all stages of the Software Development Life Cycle and have essayed different roles including analysis during requirements gathering, system analysis, design, coding, onsite coordination, and support
• Very good exposure of UML such as use case diagram, context diagram, class diagrams used for Business Analysis, System Analysis, Business Process Management and Business Process Modeling
• Experience in deploying, maintaining and managing web applications
• Well - versed with big data ecosystem and hands on experience in Apache Hadoop, Spark, SparkSQL, PySpark
• Advanced MS-Excel skills including LP based modeling and simulation using Excel Solver
• Diligent team player with advanced analytical, communication, organization and leadership skills

TECHNICAL SKILLS

Database: Azure SQL, Azure Blob, SQL Server, Oracle, PostgreSQL, Peoplesoft, Netezza

ETL Tools: Azure Data Factory, Microsoft SSIS, Informatica Power Center

Reporting Tools: Tableau, Microsoft Power BI, SSRS, TIBCO Spotfire

Big Data Technologies: Spark, HDFS, HBASE, Hive, Cassandra, Sqoop, Flume

Modelling: MS Visio, pgModeler, Erwin

UML Tools: Visual Paradigm, DIA, ArgoUML

Languages: Python, Java, Scala, HTML, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Saint Paul, MN

Azure SQL/ Azure Data Factory/SSIS Developer/ Data Analyst

Responsibilities:

• Analyzed business processes and different systems to develop strategy to integrate source data into customer data management model
• Performed in-depth data analysis of different source systems to identify & define end-user hierarchies for different divisions like Nalco Water, Food & Beverage and Energy etc.
• Owned the design and development of different sources such as Workday, CRM, EDW etc. to integrate to CDM 2.0
• Developed SQL queries to be used in SSIS packages to ingest data from Raw layer to Pre-stage layer for core objects such as Accounts, Sites & Users
• Designed the Pre-stg queries to build Graph Nodes and Graph edges to establish the relationship between core objects and relationship tables
• Developed source queries to perform delta detection during the data ingestion process
• Developed validation stored procedures based on validation rules to allow only valid records to be ingested into CDM
• Integrated data from different sources such as Azure Blob Storage, Azure SQL Database, Azure data lake, SQL server DB, flat files, MS-Excel etc. in CDM
• Designed and developed ETL packages in SSIS and pipelines in Azure Data Factory to transform source data as per transformation logic and ingest that into CDM platform based on defined architecturesof CDM model
• Worked extensively on Azure data factory including data transformations, Integration Runtimes, Azure Key Vaults, Triggers and migrating data factory pipelines to higher environments using ARM Templates
• Engaged with subject matter experts to define and maintain reference data to be consumed during the data ingestion process

Confidential, Decatur, IL

Data Analyst/ MDM Analyst/ IDQ Developer

Responsibilities:

• Engaged with Confidential stakeholders to design conversion and migration approach of legacy data to MDM hub
• Worked extensively on data modelling to design the conceptual, logical & physical data models for the MDM hub
• Analyzed different source systems such as IBM, JDE, MAXIMO etc. to understand the source data and worked with source owners to define data quality rules
• Designed and developed Informatica IDQ mapping for initial conversion load of raw source data to IDQ layer and subsequently to MDM hub.
• Used Address Doctor in IDQ to parse, clean & standardize global address information and enrich as required for different location entities
• Created and maintained consolidated source to target mapping documents by working closely with the source owners and data architects
• Defined match merge rules for initial data load and ongoing authoring of master data
• Owned and managed reference data both for IDQ layer and MDM Layer
• Closely worked with off shore MDM team for development and QA of MDM mappings from Landing tables to Stage tables and Base objects
• Worked on design of workflows to perform CRUD activities pertaining to various components of location domain
• Actively involved in all SIT and UAT activities to validate base objects by writing validation queries to compare source and target objects

Confidential, Windsor, CT

Business Intelligence/ Data Analyst

Responsibilities:

• Gathered and analyzed business requirements by engaging with Confidential ’s stakeholders
• Worked closely with Data Architect and SMEs to extensively analyze different source systems to identify & understand gaps
• Wrote advanced SQL queries for in depth analysis of source systems’ data
• Worked extensively on analysis of different sources such as ACORN, MAS, WMRA, CCDB, CorpDB Etc. and designed source queries for integration to Sherlock Data Warehouse
• Collaborated with data stewards analyze and integrate Snapshot source system to data warehouse and developed source query to include images from this source for different dashboards and reports
• Gathered and documented all business logic in functional specifications document to be used as reference by all development & QA teams i.e. Database, Dashboard, Reports, Portal
• Created and maintained consolidated Dashboard/Report to source matrix and data dictionary by working closely with the ETL team and Data architects
• Worked closely with offshore portal development team and Client IT team for seamless integration of dashboards and reports with client’s existing customer portal
• Engaged with QA and UAT team for validation of all deliverable dashboards & reports and closure of defects raised during UAT

Confidential, Plano, TX

Business Analyst/Data Analyst

Responsibilities:

• Engaged in the project since inception stage
• Analyzed client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis
• Created and documented Business case, Business Requirement Document and Functional Specifications Document
• Designed high-level process models in Visio
• Regularly interacted with stakeholders to understand business problems and come-up with solutions
• Critical evaluations on the information gathered from multiple sources and appropriate escalations on different project levels.
• Created Use case, activity, sequence and class diagrams as per UML 2.0
• Worked as single point of contact between the client and development team
• Led the off-shore development team to achieve deliverables in a timely manner
• Created test cases for functional, regression and integration testing
• Worked with DB team in writing SQL queries using joins, database connections and transformation rules to migrate legacy data from Dispute Suite & convert data and load into new system using stored procedures
• Worked in each phase of SDLC and post production support

Confidential

Responsibilities:

• Involved with both the mobile & web application teams since conceptual stage
• Gathered requirements by understanding market needs and played a vital role in the conceptual phase
• Created and documented Business case, Business Requirement Document and Functional Specifications Document for the Web Application
• Created detailed end to end process flow & data flow diagrams for the whole project as well as individual components like smart prospecting
• Played key role in design of business dashboards and email marketing campaign functionality for the business user
• Led the off-shore web development team to work in tandem with the mobile and backend development team for timely delivery
• Worked with database team for data modelling and database design tasks
• Collaboratively developed test cases including functional, regression and integration testing with the testing team
• Efficiently managed the flow of information between teams and ensured timelines are met for each task

Confidential, Houston, TX

Data Analyst

Responsibilities:

• Analyzed hospital data to provide integrated insights on the patient inflow and its effect on resource utilization and revenue
• Extensively used Tableau for analytics and visualization needs of the project
• Provided ability to drill down on disease groups by slicing and dicing patient data
• Created cutting edge visualizations using tree maps and heat maps and provided the ability to perform ad-hoc reporting
• Created different chart objects like Bar Chart, Line Chart, Text Tables, Tree Maps and Scatter Plots for visual representation findings for further analysis
• Analyzed service data to identify and visualize in-service ports and out of service ports across various time periods.
• Performed survival analysis on customer base to measure the propensity of the customer to disconnect
• Designed visualizations using Tableau to display hour over hour, day over day and week over week for service interruptions and reduced speeds in the network
• Developed visualization to display the utilization of the available ports in near real time

Confidential, Dallas, TX

Intern Consultant

Responsibilities:

• Assessed the “As Is” process map and identified scope for improvement
• Evaluated how Confidential can best interface with its suppliers by leveraging technology
• Focused on improving supplier scorecard by benchmarking best-in-class scorecards in practice
• Provided recommendations to enhance supplier collaboration and streamline pricing updates