SUMMARY:

• Over 6 Plus years of IT experience as a Techno Functional Business Analyst, with experience in analysis, design, development, deployment, testing, and implementation of projects in various domains
• Experience in all phases of Software Development Life Cycle (SDLC) including requirement gathering from business users, data analysis, planning, scheduling, design, documentation, process mapping, development, testing and implementation using iterative approach as per Agile (Scrum) methodology
• Proficient in documenting Business Process Design, authoring Business Requirements Document (BRD), Use case Specifications, Functional Specification Document (FSD)
• Proficient in analyzing and creating Unified Modeling Language (UML) Diagrams such as Use case diagrams, Data flow diagrams, Business flow diagrams using MS Visio
• Experience in Extracting, Transforming and Loading (ETL) data from multiple databases, Excel, Flat file to MS SQL Server by using BCP Utility, DTS, SSIS Services and Talend.
• Working knowledge on SQL Server Reports using SSRS 2008/2012 including Tabular, Parameterized, Drill Down, Drill Through, Cascaded, Sub Reports and Matrix (Cross / Tab Report).
• Experience in conducting Manual Testing and User Acceptance Testing (UAT)
• Able to effectively converse, relate and liaise with multifunctional teams including business owner, stake holders, mangers, architects, developers and QA
• Strong analytical, administration and problem - solving skills dedicated to maintain the high-quality standards.
• Excellent organizational, interpersonal, communication, leadership skills and ability to work independently.

PRIMARY SKILLS:

• VB.Net
• SQL
• XML
• Basic
• C/C++
• HTML
• SQL Server Tools
• SQL Server Management Studio
• SSIS
• SSAS
• SQL Server Data Tools
• SSRS
• Operating systems
• Windows 2000, 2003XP, 2007, 2008
• Integration Servers/ Middleware Applications
• SQL Server Data Tools
• IIS 6/7/8
• I nformatica
• Microsoft .Net Framework
• Talend
• Tools and Methods
• SQL Server Management Studio
• TOAD
• Microsoft Project
• Microsoft Visio
• AutoCAD
• Swish
• Visual Source Safe
• Microsoft SharePoint
• Oracle SQL Developer
• Testing Tools
• Bugzilla

EMPLOYMENT HISTORY:

Confidential, Ft Worth, Texas

Sr. Data & Reporting Analyst

Environment: MS SQL Server 2016, SSIS, SQL Server Management Studio, Tableau, MS Visio

Responsibilities:

• Assisted the Project Manager with project scope and project plan.
• Collaborated with the technical team to understand the current data architecture and to define data requirements related to the new functional requirements.
• Conducted interviews with Business SMEs and stakeholders, Project Managers and developers to get a better understanding of client business processes and gather business requirements.
• Performed comparative study between multiple BI Tools and recommended the BI Tool that best fits the business requirements.
• Created enterprise level current and future Data Flow Diagrams (DFDs) and state transition diagram using MS Visio.
• Created Business Requirements Document (BRD), BI Tool Comparison, Strategy and Project Completion documents.
• Created Change Request as per the client’s requirements / enhancements.
• Created time estimates and resource allocation for project team tasks and completed assigned tasks in a timely manner with a high level of quality
• Conducted daily scrum meeting to discuss current tasks and status.
• Designed and developed dynamic SSIS packages to extract data from multiple sources to destination tables
• Implemented Incremental Data Load
• Created and executed test plans based on validation requirements and conducted User Acceptance Testing (UAT)

Confidential, Dallas, Texas

Business Analyst / ETL Developer

Environment: MS SQL Server 2012, MySQL, SSIS, SSRS, Talend, Amazon Web Services, SQL Server Management Studio

Responsibilities:

• Actively involved with business users and technical manager in SDLC phase for requirements gathering and business analysis.
• Gathered and documented existing client architecture and data to perform gap analysis between client’s system and Confidential .
• Assisted in Joint Application Development (JAD) sessions for project definition involving analyzing requirements, creating proof of concept, user interface, database schema and system design.
• Incorporated Agile Scrum methodologies, assisted in roles of Scrum Master following sprint/standup sessions and used Excel extensively to write user stories.
• Developed and implemented Data Mapping documents to depict data flow between external sources to target with all transformation rules.
• Implemented data transformation and data cleansing rules for migration using ETL tools.
• Conducted Manual Testing, User Acceptance Testing, Smoke Testing, Regression Testing, Performance Testing and Data Validation.
• Created technical design documents based on the requirements, assumptions, business rules and transformations.
• Designed and developed ETL architecture using Talend’s Data integration and mappings based on different business use cases and rules to load data from multiple sources (MySQL, Oracle, MS SQL) and flat files to target tables.
• Prepared ETL standards, Naming conventions to transform data from various EHR (Electronic Health Record) system vendors like: GE Centricity, Greenway, Athena.
• Created joins, sub-queries, functions and views to support efficient data manipulation.
• Generated different types of SQL Server Reports like Tabular, Parameterized, Drill Down, Drill Through, Cascaded, Sub Reports and Matrix (Cross / Tab Report) using SSRS 2012.

Confidential

ETL Developer / Business Analyst

Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, Windows Sever 2000/2003, SQL Server Management Studio

Responsibilities:

• Actively participated in interaction with business users, team lead, DBA’s and technical manager to fully understand the business requirements.
• Documented Business Requirements Document (BRD), Functional Specification Document (FSD) and Technical Design Document (TDD).
• Involved in User Interface (UI) analysis with the business team to validate accuracy.
• Tracked and prioritized the bugs that need to be fixed using Bugzilla.
• Supported development of UAT test scripts and reviewed User Acceptance Test Plan (UATP)
• Adhered to IT risk management changes and policies according to client operations.
• Conducted audit tasks to assess IT controls and ensure availability, accuracy and security under all conditions.
• Created Joins, sub-queries, Stored Procedures, Indexes, Functions and Views to support efficient data storage and manipulation
• Wrote stored procedures and triggers to capture inserted, deleted and updated data from OLTP systems.
• Created SSIS Packages using Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Developed dynamic packages using SSIS and implemented Incremental Data Loading.
• Generated different types of SQL Server Reports like Tabular, Parameterized, Drill Down, Drill Through, Cascaded, Sub Reports and Matrix (Cross / Tab Report) using SSRS 2008.
• Involved in analyzing, designing and building of OLAP cubes with SSAS 2008.
• Identified the dimension, fact tables and designed the data warehouse using star schemas
• Scheduled daily and weekly Jobs and Alerting using SQL Server Agent.
• Conducted Performance Tuning by using unblocking and row transformations for better performance of SSIS packages.
• Developed SQL Server configurations files for SSIS packages.

Confidential

Technology Sales Engineer

Responsibilities:

• Identify new opportunities in the market and qualify leads.
• Present company services, product lines and procedures to qualified prospects.
• Serve as a consulting partner that manages and interprets customer requirements ensuring proactive communication to understand, anticipate and meet their needs.
• Develop competitive business plans, product presentations, RFI / RFP.
• Support and lead the technical team for proof of concept.
• Engaging in marketing activities such as Roadshows, Trade shows and Conferences for increasing brand awareness and market penetration
• Make prospecting cold calls to customers and industry specific leads on a daily basis.
• Research products in order to differentiate between company’s software and competitors and educate clients on the benefits and ROI from company products.
• Product Experience: Avaya - Unified Communications

Confidential

Software Engineer Trainee

Responsibilities:

• Prepared Case Study Analysis to gather requirements and analyze in order to propose the design and architecture for the Cost Estimation Software.
• Developed & deployed Cost Estimation Software for the jobs undertaken by the company in VB.Net & SQL Server 2000.
• Actively supported business users for change requests.
• Conducted knowledge transfer and user for the software.
• Extensively involved in system installation, troubleshooting and maintenance of company systems.