SUMMARY:

• 9 years of total IT experience in the Business Requirements Data Analysis, Application Design, Development, Implementations and Testing of Data Warehousing and Database business systems for various IT and telecom industries.
• Expert in Data Modeling, Data Analysis, Data Visualization, and Modern Data Warehouse concepts. Designed Various Reports/dashboards to provide insights and data visualization using BI/ETL tools like SSIS, OLTP, OLAP, Business Objects, SSRS.
• Performed Scope Analysis, Stakeholder Analysis, Gap Analysis, and Traceability Matrix and used Visio for Business Process Modeling adopting UML Standards.
• In - depth knowledge and practical experience of using Waterfall, Agile, Scrum, Rational Unified Process, Business Process Reengineering, Unified Modeling Language, System Requirements Specification and Functional Requirements Specification, Rapid Application Development, and MS Visio
• Experience in creating DDL, DML and Transaction queries in SQL
• Excellent conceptual and technical skills to create Business Requirements Document, Functional Specifications Document, Process Flow Diagram, and Detailed Design Document.
• Articulate with Data Conversion, Data Quality, Data Profiling, Performance Tuning, and System Testing and implementing RDBMS features.
• Experienced to work as a Data Analyst to perform complex Data Profiling, Data Definition, Data Mining, Validating, and analyzing data and presenting reports.
• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.
• Experienced in assisting the team in making any important business improvement decisions by providing the relevant analysis through audits for various site specific and global programs.
• Proficient in Software Development Life Cycle (SDLC), Project Management methodologies and Microsoft SQL Server database management.
• Engineer process to extract data from various source and support systems and data warehouses to support data conversion requirements
• Excellent analytical, communication skills with clear understanding of business process flow, SDLC life cycle.

TECHNICAL SKILLS:

• RUP
• UML
• Agile
• Waterfall
• SDLC
• MS Visio
• MS Office (Word
• Excel
• PowerPoint
• Project
• Outlook
• Access)
• MS SharePoint
• Tableau
• MS SQL Server
• Rational Requisite Pro
• Rational ClearQuest
• HP Quality Center
• SPSS Modeler
• R Programming
• Python
• OFSAA Functional
• VB
• Statistical Modeling
• & techniques.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Business System Analyst

Responsibilities:

• Worked horizontally across the multifunctional team. While analyzing and highlighting the Functional, Technical & Business process gap with the best possible solution. Which includes collaborating with the data warehouse team to bridge the gap between business and functional team.
• Involved in preparing Logical Data Models/Physical Data Models.
• Work with multiple teams over the weekend to perform releases. Ensuring all instruments can be traded and are compliant with AMEX regulations
• Consults with lead or manager to discuss testing approach
• Independently query data from multiple relational databases (RDBMS) for analysis and remediate exceptions by writing procedures using SQL
• Working closely with IT and Operations partners to identify area which require monitoring and create business as usual (BAU) processes to satisfy the requirement
• Performing project analysis including Impact Analysis and undergoes Gap analysis against requirements.
• Undergoes the Risk analysis, preparation of Risk tracker and manage it regularly.
• Works with business SMEs, Delivery teams in gathering the requirements & documents inline of Agile methodology. It includes identification high level business needs, Preparation of Duck-creek specific Detail Requirement docs (DRS), Screen field Design Doc, Preparation of Application Work Flow.
• Facilitate the Requirement gathering meetings with Business SMEs and Technical Team.
• Set up the meeting with Business technical team to understand the Common page level requirements.
• Works closely with Project Management, providing inputs during project planning and throughout the development life cycle to ensure business objectives are met.

Environment: Windows, Quick Test Professional 8.2, Rally, Benchmark Factory, SQL Loader, PL/SQL, Oracle, MS-Excel, Jira, VB, OFSAA Functional.

Confidential

Sr. Business Analyst

Responsibilities:

• Worked with Data science team to Manage/ Co-ordinate project activities and mission critical applications following ITIL Methodologies. Extracting the information from raw data and proving constructive inputs to take data based action for the improvement of the project.
• Involved in preparing Logical Data Models/Physical Data Models.
• Identify source systems, their connectivity, related tables, and fields and ensure data suitably for mapping.
• Worked with BI and/or Oracle in a multi megabytes environment.
• Designed & Developed logical & physical data model using data warehouse methodologies, including Star schema - Star-joined schema, conformed dimensions’ data architecture, early/late binding techniques, data modelling, designing & developing ETL applications using Informatica.
• Worked in entire life-cycle beginning from Requirements gathering, Data Model Design, ETL Design, Report Design, Testing, and Migration to Production and Post Production Support.
• Working with ETL Lead and Business Analysts to ensure design integration and consistency across subject areas
• Determined data rules and conducted Logical and Physical design reviews with business analysts, developers, and DBAs.
• Experienced in Data Transformation and Data Mapping from source to target database schemas and data cleansing.
• Worked on data mapping process from source system to target system.
• Developed and maintained Data Dictionary to create Meta data Reports for technical and business purpose.
• Worked on Performance Tuning of the database, which includes indexes, optimizing SQL Statements.
• Worked with reversed engineer Data Model from Database instance and Scripts.
• Experienced in Designing Database with prominent activities like maintaining sequences, index, primary key, foreign key, manipulating columns and tables.
• Running Monthly Segmentation jobs with interfaces to BI
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting, and rolling out the deliverables.
• Running Quality checks using SQL Queries and keep synchronize all databases with Erwin model and across all environments.

Environment: Windows, Quick Test Professional 8.2, Quality Center 8.2, Benchmark Factory, SQL Loader, PL/SQL, Share Point, Oracle, MS-Excel, Jira, VB

Confidential

Business Analyst

Responsibilities:

• Worked as Business Analyst for Confidential, Client was Virgin Media is an American worldwide communications company which provides communications and data services to residential, business, governmental and wholesale customers.
• Researched and analyzed both source data and target data for bill validation between legacy system and Virgin Ensemble system using Oracle SQL developer and PL/SQL developer
• Coordinated with development team to identify and resolve the issues during data conversion process
• Streamlined various processes to fine tune the quality of data using various data manipulation techniques for a data conversion project
• Developed SQL queries to identify the discrepancies on customer accounts and their products between legacy and target system
• Assisted other team members to make them understand the data conversion process and the SQL queries written for data analysis purpose
• Worked on understanding categorizing, organizing, and interpreting heterogeneous data sets
• Used python based data manipulation tools such as Pandas, Matplotib, PostgreSQL to clean corrupted data before generating business requested reports
• Developed series of SQL queries to compare customer data for different categories including recurring charges, bundles, discounts, usage etc.

Environment: Pandas, Matplotlib, PostgreSQL, DB2, JCSL, Endevor, FileAid, Visual Source Safe.

Confidential

Assistant Team Lead

Responsibilities:

• Worked on the project with predictive analysis team via using qualitative and quantitative methods to research, compile and analyze processes and outcomes. And planned necessary action to curb down the protentional churn customer numbers and retain them.
• Wireless services and mobile commerce. Confidential had over 307 million customers across its operations at the end of November 2014.
• Mapped data elements to the source data files by identifying business requirements. Design documentation and business requirement specifications were used in establishing the relation between the data elements and source data.
• Provided clear and concise documentation regarding requirements management plans, functional requirements, and supplemental requirements.
• Provided the sequence diagrams, flow diagrams, use case diagrams and ER diagrams for various modules in the project using Rational Rose.
• Provided performance tuning and capacity planning on Tera data to help scale the system and optimize performance.
• Designed Logical (relationship, cardinality, attributes, and, candidate keys) and Conceptual models of database using VISIO.
• Performed data collection and analysis using BI, Operation management tool and MS Excel
• Converted the logical model to physical data model, and created objects, aggregation strategies, partition strategies, Purging strategies as per new architecture.
• Helped the BI, ETL Developers, Project Manager, and end users in understanding the Data Model, data flow and the expected output for each model created
• Worked with DBA to create the physical model and tables. Scheduled multiple brain storming sessions with DBA and production support team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions.
• Developed target mapping spreadsheets for ETL team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, Transformation Rules, and corporate meta-data definitions.
• Managed Traceability matrix to trace Business Requirements, Functional Requirements, and Use Cases.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with Data Quality issues.
• Managed the meta data repository containing data elements, semantics, and business rules.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.

Environment: Oracle 12c/11g, Windows 7, PL/SQL, MS-Access, SQL SERVER, MS Office, VISIO.