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 wif advance SQL skills to proficiently write complex SQL queries for data analysis, development and validation
• Worked on all stages of teh Software Development Life Cycle and has 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 wif 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 wif 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 teh 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 teh Pre-stg queries to build Graph Nodes and Graph edges to establish teh relationship between core objects and relationship tables
• Developed source queries to perform delta detection during teh 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 wif subject matter experts to define and maintain reference data to be consumed during teh data ingestion process

Confidential, Decatur, IL

Data Analyst/ MDM Analyst/ IDQ Developer

Responsibilities:

• Engaged wif Confidential stakeholders to design conversion and migration approach of legacy data to MDM hub
• Worked extensively on data modelling to design teh conceptual, logical & physical data models for teh MDM hub
• Analyzed different source systems such as IBM, JDE, MAXIMO etc. to understand teh source data and worked wif 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 wif teh 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 wif 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 wif Confidential ’s stakeholders
• Worked closely wif 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 wif 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 wif teh ETL team and Data architects
• Worked closely wif offshore portal development team and Client IT team for seamless integration of dashboards and reports wif client’s existing customer portal
• Engaged wif 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 teh 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 wif stakeholders to understand business problems and come-up wif solutions
• Critical evaluations on teh 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 teh client and development team
• Led teh off-shore development team to achieve deliverables in a timely manner
• Created test cases for functional, regression and integration testing
• Worked wif 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 wif both teh mobile & web application teams since conceptual stage
• Gathered requirements by understanding market needs and played a vital role in teh conceptual phase
• Created and documented Business case, Business Requirement Document and Functional Specifications Document for teh Web Application
• Created detailed end to end process flow & data flow diagrams for teh whole project as well as individual components like smart prospecting
• Played key role in design of business dashboards and email marketing campaign functionality for teh business user
• Led teh off-shore web development team to work in tandem wif teh mobile and backend development team for timely delivery
• Worked wif database team for data modelling and database design tasks
• Collaboratively developed test cases including functional, regression and integration testing wif teh testing team
• Efficiently managed teh 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 teh patient inflow and its TEMPeffect on resource utilization and revenue
• Extensively used Tableau for analytics and visualization needs of teh 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 teh 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 teh propensity of teh 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 teh network
• Developed visualization to display teh utilization of teh available ports in near real time

Confidential, Dallas, TX

Intern Consultant

Responsibilities:

• Assessed teh “As Is” process map and identified scope for improvement
• Evaluated how Confidential can best interface wif 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