PROFESSIONAL SUMMARY:

• Technical business Analyst with 10 years of experience in IT Industry covering the areas of Analysis, Design, Development, Implementation, and testing,, and project documentation of Business application systems. Excellent leadership, communication and problem resolving skills in high demand quality conscious multi - task environments.
• Experience in working on apache Hadoop open source distribution with technologies like HDFS, Map-reduce, Python, Pig, Hive, Hue, HBase, SQOOP, Oozie, Zookeeper, Spark, Spark-Streaming, Storm, Kafka, Cassandra, Impala.
• Experience in Requirement gathering through participating in interviews, workshops, and JAD sessions with clients, developers, and QA Analysts, and referring to existing system documentation and procedures.
• Hands on experience in using MapReduce programming model for Batch processing of data stored in HDFS
• Experience in configuring Azure Web Apps, Web roles, Worker roles, Azure App Services, Azure application gateway, Azure DNS, Azure Traffic Manager, Analyzing Azure Networks with Azure Network Watcher, Implementing Azure Site recovery, Azure backup and Azure Automation.
• Experience in Middleware analysis, Design, Development, configuration, Testing, Deployment, support and middleware administration of API Connect, Integration Bus/IIB 9.0, 8, 7 and IBM WebSphere Data Power XS40, XI50, XI52 SOA appliances
• Experience in Migration Projects, performing GAP Analysis, creating Software Specific Documents, and assisting the database and security team in back-up and securing the company’s digital artifacts
• Experience using middleware architecture using Sun Java technologies like J2EE, Servlets, and application servers like Web Sphere and Web logic
• Hands on experience in developing and deploying enterprise based applications using major Hadoop ecosystem components like Map Reduce, YARN, Hive, Pig, HBase, Flume, Sqoop, Spark Streaming, Spark SQL, Storm, Kafka, Oozie and Cassandra.
• Experienced in ASP.NET WEB API and Web Services (SOAP & RESTFUL)
• Experience in configuring and creating components of Data Power appliance such as Web service proxy, Multi-protocol gateway, XML Firewall and services.
• Experience in analysis, design of API's in API Connect and API Manager.
• In depth knowledge of User Acceptance Testing (UAT) with experience in creating test cases and test plans & release skill sets. Assisted the Quality Assurance (QA) team to perform Black Box, White Box, Alpha, Sanity, Smoke, GUI testing, Functionality, Regression, System, Unit, Web Service, Performance testing.
• Experience in resolving critical problems in WMQ and WMB on platform Windows, designed and implemented the pub/sub message pattern.
• Good knowledge on web service standards like XML, XPATH, XSLT, XSD, SOAP and WSDL
• Thorough understanding of n-tier architecture, understanding of request and response flow. Understanding appropriate technologies for business requirements (SOAP, REST, AJAX, JSON, and XML). Gathered requirements for Client-Side Validation, and Server-Side Validation. Experience in API documentation
• Experience with Data warehouse architectures, (Centralized, Federated, Hub and Spoke) experience with ETL processes, cleaning and cleansing data, Data Table structures, Schemas, Data Marts and OLAP operations, for example, Roll-up, Drill-down, slice, dice and pivot
• Proficient in using Unified Modeling Language(UML) for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, and document them using MS Visio
• Strong Business Analysis Skills including In depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing and Practical knowledge of Rational Unified Process (RUP).
• Experienced in designing and reviewing of various documents including the Software Requirement Specifications (SRS), Use Case Specifications (UCS), Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents • Conducting JAD, JRP, Brainstorming, Prototyping and Job-Shadowing sessions
• Extensively worked with ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Strong Experience in performing Gap Analysis, Data Mapping, Business Process improvement and system integration Business requirement creation as per the business AS IS AND TO BE criterion and Technology in corporation.
• Good experience in configuring the APIs, Proxy endpoints and API analytics based on technical specifications with Mule Soft API Manager.
• Expertise in querying and testing NoSQL (Cassandra, impala, Hue), RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
• Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Expert in T-SQL, DDL and DML and perform most of the functionality T-SQL Scripts and Batches in SQL Server and Informatica and experience in writing SQL Queries, dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-Defined Functions, Views and Cursor Experience on Preparation of TEST PLAN, TEST PROCEDURES, Manual and Automation TEST SCENARIOS, TEST SCRIPTS, Report DEFECTS
• Extensive knowledge of Software Development Life Cycle (SDLC), methodologies and test processes and Software Testing Life Cycle (STLC)
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Experience in creating multidimensional cubes using SSAS (SQL Server Analytical Services) and OLAP (Creating Cubes) including interfaces with BIDS.

SOFTWARE /TECHNICAL SKILLS:

Testing Tools: Quality Center 11. QTP 11.5, MS Visual studio, TOAD, WINSCP

Database: MS-SQL Server- 2016, 2012, NETEZZA TERADATA, Oracle 11gR2,NOSQLCassandra,Hue,Impala ,Mysql

MSBI: SSIS, SSAS, SSRS, SAP BI/BW, INFORMATICA 9.5, Tableau

Operating Systems: Windows 2008, Win NT, Windows 2003 and XP, Linux

Languages: Python, JAVA, JavaScript, PLSQL

ERP Modules: SAP MM /WM, SD, FICO, BW/BI, MS Dynamics CRM, Microstrtegy

Report Tool: Tableau, Confidential SSRS

Big Data Ecosystem: Hadoop, MapReduce, HDFS, HBase, Spark, Scala, Zookeeper, Hive, Pig, Sqoop, Flume and Pivotal HD.

Management Tools: Quality center, SOLMAN 7.1, Rally, Jira

SAP Versions: SAP R/3 4.6, 4.7, ECC 5.0, 6.0

Web Service: Web Logic Application Server10.3, XML, XSD, XSLT, XPATH, JAXP, JAXB, WSDL, SOAP, Spring MVC

PROFESSIONAL EXPERIENCE:

Confidential

Tech Business Analyst

Environment: Tableau Report, Teradata, NoSQL DB Cassandra, Apache Sqoop, Rally, Apache Flumes, Kafka, IXP Autosys, MySQL DB, Agile, Apache Oozie, Scala, Machine learning, Linux, Impala, Toad Oracle, Apache spark, HDFS

Responsibilities:

• Participated in daily Agile Scrum, Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories for the a project of changing the client's software maintenance structure of their various software products.
• Involved in transformations, cleaning and filtering on imported data using Hive, Map Reduce, and loaded final data into HDFS.
• Participated in Installation/Configuration/Maintained Apache Hadoop and Cloudera Hadoop clusters for application development and Hadoop tools like Hive, Pig, HBase, Zookeeper and Sqoop.
• Involved in deploying data from various sources into HDFS and building reports using Tableau involved in Cloudera Hadoop Upgrades and Patches and Installation of Ecosystem Products through Cloudera manager along with Cloudera Manager Upgrade
• Involved in extract, transform, and load (ETL) data from multiple federated data sources (JSON, relational database, etc.) with Data Frames in Spark.
• Participated in data extraction and data ingestion from different data sources into Hadoop Data Lake by creating ETL pipelines using Pig, and Hive
• Involved in all phases of Software Development Life Cycle (SDLC) and Worked on all activities related to the development, implementation and support for Hadoop .
• Involved in development of data pipeline using HDInsight, Flume, Sqoop and Pig to extract the data from weblogs and store in HDFS.
• Worked with applications teams to install operating system, Hadoop updates, patches, version upgrades as required.
• Participated in transformations, cleaning and filtering on imported data using Hive, Map Reduce, and loaded final data into HDFS.
• Involved in Cluster maintenance, commissioning and decommissioning Data nodes, Cluster Monitoring, Troubleshooting, Manage and review data backups, Manage & review Hadoop log files
• Worked with data delivery teams to setup new Hadoop users, Linux users, setting up Kerberos principles and testing HDFS, Hive
• Involved in planning the Hadoop cluster infrastructure, resources capacity and build plan for Hadoop cluster installations.
• Worked closely with Business stake holders, BI analysts , developers, and SAS users to establish SLAs and acceptable performance metrics for the Hadoop as a service offering.
• Interacting with Subject Matter Experts (SME's) and stakeholders to get a better understanding of client business processes and gather business requirements
• Created and Maintained projects supporting documents (technical, business, project level and sops) to meet SDLC standards.
• Involved in Importing and exporting data from different relational databases into HDFS and Hive using Sqoop and performed transformations using MapReduce and Hive
• Worked on loading log data into HDFS through Flume
• Used Oozie to schedule various jobs on Hadoop cluster.
• Involved in Development of multiple Kafka Producers and Consumers from scratch as per the business requirements
• Extensively used Apache Sqoop for efficiently transferring bulk data between Apache Hadoop and relational databases.
• Involved in REST HTTP standard, Domain naming standard for REST API design.
• Tracked tasks and deliverables using Jira (Agile) tool and work with Product owner/Developers (AS Team) to meet the right sprint.
• Documented business requirements, and communicated these requirements with the development team for design and implementation of business solutions
• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
• Involved in creation of WEB API methods for database operations (CRUD) through Entity Framework.
• Attended agile meetings with the project managers and DEV team to get a clear understanding of the business and the applications being used by different Line of business.
• Involved in data Modelling using HIVE for Analytics, File processing using PIG, and Data load management.
• Participated in Designed and development of REST/HTTP APIs, including JSON data formats and API versioning strategy session
• Assisted in documenting data migration (DM) activities and documented Migration Summary Report.
• Collaborated with the front-end design team and back-end team and started converting the static files with the dynamic content with the data is retrieved from the database by the REST API calls.
• Identified processes for developing and documenting detailed business requirements through partnership with end-users, product owners, and analysts
• Performed GAP Analysis of the legacy system and the required screens for personal lines replacement system and created a document that identifies the screen changes with description and values of each field of every screen
• Worked with REST WEB API's to make calls to the web services using URLs, which would perform GET, PUT, POST and DELETE operations on the server
• Involved in the Creation of stored procedure, trigger on the database to provide/insert specific data from multiple tables for Web API services.
• Partnering with the bank stakeholders to give status updates & recommend changes in project requirements
• Prepared detailed design documents to translate business process effectively for developers and product managers using MS Visio.
• Translated business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions
• Documenting user stories in Rally Agile tracking tool to certify proper time-boxing, execution, and completion of relevant tasks
• Grooming the product and sprint backlogs to ensure that the highest priority items make it into the current sprint
• Utilize the Confidential Office Suite (Project, Word, Excel, PowerPoint, and Access), for the creation and management of requirement documentation, project plans, and schedule
• Assisted in tracking and managing operations expenses and post-production activities.
• Performed as a liaison between Stakeholders, Subject Matter Experts (SMEs), Business users, and Development Team to identify the business needs, business rules and business process
• Prepared and maintained requirements traceability matrix (RTM) throughout the project lifecycle.
• Responsible for Importing and exporting data into HDFS and hive during UAT testing.
• Running Sqoop jobs to dump data from existing Oracle database into HDFS for processing and exporting data to RDMS during data preparation
• Used apache spark machine library and spark streaming for data model process.
• Actively participated in platform upgrade from apaches crunch to apache spark for data streaming and processing
• Actively participated in data model for multiple POCs using Spark-Streaming and deployed on the Yarn cluster, compared the performance of Spark, with Storm
• Applied business concepts to design and maintenance an internal database for Advanced Analytics group with MySQL and mem SQL, including database backup, restoring, and optimization.
• Experienced in managing and reviewing Hadoop log files, Supported MapReduce Programs running on the cluster.

Confidential

Role: Tech Business Analyst Confidential Dynamics CRM

Environment: MS SQL 2012, MS SSRS, SSAS IBM NATEZZA, Rally, INFORMATICA 9.5, IXP Autosys, Oracle DB, AGILE, MULE-WEB SERVICE,TOAD.

Responsibilities:

• Conducted workshops with Business users to perform gap analysis and customizations for CRM platform
• Involved in Customization of Confidential Dynamics CRM system, based on functional requirements of the client and use of out-of-the-box features, required configuration and customization for various functionalities and requirements
• Communicated with the business users to gather business requirements about the migration and customization techniques of CRM system.
• Involved in Custom Entities, Custom properties for individual Business Units in MS Dynamics CRM 365 according to the Business Process
• Worked on supporting the CRM 2015 production environment and resolving the issues for CRM production environment
• Used CRM web service and built up a custom administration utilizing WCF to give stretched out functionalities to the basic techniques for CRM
• Involved in Implementation of MS Dynamics CRM process utilizing Marketing, Sales and Service entity modules utilizing different components of Managed and Unmanaged arrangement, XRM custom segments utilizing plugins (C#), work processes, Dashboard/Reports.
• Involved in Development and integration of Dynamics CRM callouts, work processes, information movement, email integration, web forms, and sitemaps to connect in and out of Dynamics CRM Solution
• Participated in Customization forms and views for new modules that was to be added to existing MS Dynamics CRM 2015 framework
• Used SSRS make reports in the framework to give accurate data for business decision making and also created sales pipelines custom reports in CRM
• Participated in design and used spring framework along with JSP, HTML, CSS and JavaScript to construct the dynamic web pages presentation layer for the application.
• Involved in Integration of the ORM Object Relational Mapping tool hibernate to the spring using Spring ORM in our app and used spring transaction API for database related transactions
• Involved in the process of Database Design and ER Diagrams for the application.
• Participated in design and coding of web pages using JSP, Servlets and HTML
• Involved in WebSphere MQ Series integration with the application
• Involved in deployment of Web Services for updating the information to the workflow steps and getting the pre-configured workflow processes.
• Participated in Creation of various RAML resources to implement REST Based APIs as a part of project implementation.
• Extensively worked with making calls to WEB APIs to fetch the data from the back end as JSON response and parse it on the UI for DOM/CSS Manipulation
• Involved in requirement gathering, design, development, testing and implementation of the web application and used Agile development life cycle with daily scrum meetings
• Migration of legacy systems to Confidential Dynamics CRM in the area of commercial services achieving better accessibility and user satisfaction
• Involved in Reviewing the API specification with different stakeholders like API provider team and business owner
• Participated in Creation of stored procedure, trigger on the database to provide/insert specific data from multiple tables for Web API services.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes. Performed Count Validation, Dimensional Analysis, and Data Quality Validation in Data Migration.
• Devised and executed Requirement Traceability Matrix (RTM) and rendered effectual support to QA teams with the development of test plans and test cases
• Involved in AS-IS and TO-BE analysis during Blue Print Phase for gathering information and requirements to prepare blueprint documents
• Worked on different applications and Conducted Gap Analysis between "As is" and "To be" process for the applications. Participated in the Logical and Physical Design sessions and developed Design Documents.
• Participated in Business Blueprint workshop and Involved in the preparation of Functional specs for MS Dynamics CRM Business processes for Sales,maketing,services and fulfilments modules
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Participated and Conducted Joint Application Development (JAD) session with SME and Stakeholders. Conducted Defect Meetings, assign prioritization of defects and escalate to Project
• Worked in Use Cases Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modelling
• Involved in Development of SOAP and REST based web services using WSDL, SOAP, JAXB, CXF, JAX-WS and Restful web services using JAX-RS and JERSY APIs.
• Closely working with business partners, project managers across multiple team to prioritize request, expectation, and scope of work and be able to research on any business problems identified.
• Collaborated with UI/UX team to develop information/interaction architecture, user flows, wireframes, and visual design comps.
• Assessed the information gathered from multiple sources and decomposed complex information into details along with the ability to use the detail to gain understanding of an end-to-end solution.
• Coordinated work among team members and managed project deliverables like Data mapping spreadsheets, downstream systems feed and field level mapping spreadsheets using MS Excel and through regular meeting with internal stakeholders
• Participated in walkthroughs and inspections to ensure business rules, deliverables, and processes are addressed
• Involved in a CRM Full Life Cycle Implementation in CRM Dynamics and documented project testing requirements, defined organizational model and refined project goals by mapping the business process to the standard MS CRM Dynamics functionalities.
• Fully documented and replicated defects for Developers, enabling them to fix Defects faster and meet Production Deadlines.
• Implemented Feasibility and Risk Analysis to identify the business critical and high-risk areas of the application that arose from using multiple data gathering sources
• Performed requirement walkthroughs with the development and QA teams to assist in developing a test strategy.
• Documented the "AS-IS" Business Workflows adhering to UML standards. Conducted JAD sessions to define requirements and finalize the Functional Requirement Document (FRD)
• Actively involved in conducting reviews, walkthroughs and facilitating in requirement definition workshops (JAD) to confirm and playback business requirements for the project
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and thoroughly understanding the business processes.
• Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models
• Worked with multiple ETL sources, extracted and transited data from existing production system to test, QA and production environment

Confidential

Senior Business Analyst

Environment: ECC 6.0, ALM QC, INFORMATICA IXP Autosys, Oracle DB, SAP HANA, Mainframe AS400,, Linux, Ms Visio, Agile

Responsibilities:

• Updated Project manager on status of each requirement on weekly basis including risks, issues, s and progress of each critical milestone. Collected weekly status reports and updated the Project plan accordingly to ensure that all deliverables are met on time and on schedule.
• Involved in development of RESTful web services in Mule ESB based on SOA architecture.
• Developed a high level Business Requirements Document (BRD) and Functional Requirements Specification (FSD) document and had them base-lined from the business owner.
• Involved in Creation of generic data sources from custom tables in SAP ECC. Worked with the ECC development team to ensure these custom tables could be delta enabled whenever possible.
• Involved in SAP BW upgrade and BW on HANA Migration.
• Participated in customization and ABAP development of source system extractors through Customer Exits for transactional and master data extractors using tables for transactional and master data. Open Hub extracts Generated custom extractors with views
• Worked with FI AP, AR extractors with the new virtual cubes in BI for getting instant reporting from daily transactions.
• Involved in architect, design, development and maintenance of HANA data models (Attribute view, Analytical View and Calculation views), HANA Security, data provisioning thru SLT, Import, export and migration
• Participated in Creation of custom info objects with master data attributes and texts. Enhanced delivered master data attributes and by enhancing the delivered master data extractors using both 7.0 and 3.5 paradigms.
• Conducted Quality manual testing to check if the features of the system and integration of the system was up to the user requirements and under the given business rules
• Ensuring all issues, defects are identified during testing and production validation are assigned to the appropriate technology team/partner and worked on bases of priority to resolve them.
• Assisted in the design and build of an advance Enterprise Data Warehousing solution using the SAP recommended EDW model. Created staging DSOs which are used primarily to hold raw data from the source system. Designed second level DSO info providers to merge data from the various staging DSOs into a format which would satisfy the reporting requirements.
• Conducted User Acceptance Testing (UAT) on the broker view (Director's & Officers Liability Coverage and Employment Practices Liability Insurance Coverage) and Business-to-Business Transaction testing.
• Involved in providing solutions to the complex requirements using BW 7.3 Infoproviders (Transient Infoprovider, Virtual Master Data Info Objects, Composite Providers, Multiproviders) for HANA Models and resolved HANA error's like data type mismatch, numeric overflow, etc.
• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams using Rational Rose so that developers and other stakeholders can understand the business process.
• Extensively employed MS Visio to conduct UML modeling - use case diagrams, written use cases, activity diagrams, screen mock-ups, data flow diagrams, class diagrams, business process flows diagrams, and workflows diagrams, thereby assisting development and QA teams in understanding application
• Participated in development write optimized DSO's for EDW layers and standard DSO for consolidation layers and created direct update DSO's and APD for creating history data and for snapshot scenario reports
• Worked with Project Manager in coordinating all aspects of project such as initiation, planning including budgeting, scheduling, task assignment and tracking, Change management status reporting and risk management
• Performed requirement analysis by gathering both Functional and Non Functional Requirements based on interactions with the Process Owners & Stakeholders
• Conducted User Acceptance Testing and Quality Assurance Testing to support functional and maintenance releases
• Facilitated prioritizing and scoping out the Product Backlog Items (PBI), with the input from business SME's
• Worked on Users requirement for development of BOBJ WebI (Web Intelligence & also Analysis for Office) reports and Variants for SAP as well as Non-SAP data sources.
• Translated the strategic and tactical business needs into functional requirements to develop user interfaces and work flows and resolve any conflicts with requirements between business units or between business and technology
• Included a mix mode SAP HANA and SAP BW on HANA approach where there were standalone HANA models, HANA models exposed as Virtual Providers in SAP BW and finally classical BW on HANA models. The latter made use of in Memory Optimized DSOs exposed thru Multi-Providers and BEX Queries and use of in-memory optimized cubes when aggregating data with different granularity
• Involved in creation of "As-Is" and "To-Be" process flow to determine the process and structure the requirements
• Validated SAP HANA Solution on various technical & business parameters including query performance, data compression, and analytics on Business Objects reporting tools. Worked with business team, systems analyst, developers and test team to resolve any follow up and action items.
• Involved in GAP analysis around the identification of design rules and System Process Flows, User administration and requirements.
• Worked on following applications Business Objects, Enterprise Architect, Toad, Plainview (project management), Confidential Suite (Word, Excel, PowerPoint, Visio, Access, Project) • Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Participated in Joint Application Development (JAD) sessions; acted as liaison between the business and development teams.
• Assisted Scrum Master in provided estimates of resources required for assigned projects as well as assisting the product owner in contributing to the development and support of staffing plans and funding request.
• Conducted the Regression tests for already reported Bugs and change requests to test whether fix has been applied or not and to test and ensure the fix does not cause a new problem or break existing functionality
• Closely working with business partners, project managers across multiple team to prioritize request, expectation, and scope of work and be able to research on any business problems identified.
• Thoroughly working with business teams to ensure that business requirements properly met the required level of business technological need.
• Participating in strategy and status meetings to report project issues. Communicating with developers, Functional consultants through all phases of testing prioritize bugs resolution.
• Creating project WBS, collaborating with project teams to get the task executed on timely manner
• Actively involved in the UAT completion process and production validation with different business teams including testing of business process changes, gather test scripts and managing issue resolution through QC (HP quality center) and emails.
• Regularly holding meeting with services delivery managers, technical analyst and developers to review requirements, answer questions, prioritize work, gather examples and provide feedback on the business flow design and proposals.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Working with SAP ECC performance team to schedule jobs and monitor system performance

Confidential

Senior Business Analyst

Environment: ECC 6.0 XML, Office 365, Azure, Confidential Visual Studio, MS SQL Server 2012, SSIS, SSAS, SSRS

Responsibilities:

• Elicited the requirements using techniques such as survey/questionnaires, Interview sessions, Brainstorming sessions, Focus group sessions, Requirement workshops, Root Cause analysis, Document analysis, and Cost Benefit Analysis and Joint Application Development (JAD) sessions with internal & external stakeholders.
• Participated in Configuration of OneDrive for business, Planner, Delve, Yammer and Video365, Office web apps, configuring Claims, ADFS, Azure PasS, SaaS and Cloud Computing methodologies for Office365,
• Participated in Migration of over 700 GB of data from legacy SharePoint sites (WSS 3.0, MOSS 2007, 2010) onto SharePoint O365 environment using Content Matrix Metalogix Tool.
• Involved in development plan and migration of servers, relational databases (SQL) and websites to Confidential Azure cloud
• Experienced in Azure SQL Services - Created Azure SQL database, performed monitoring and restoring of Azure SQL database. Performed migration of Confidential SQL server to Azure SQL database.
• Involved in Creation of Confidential Azure Cloud SQL Servers and Replication Severs.
• Experienced as a Confidential Dynamics CRM Business Analyst. Performed online CRM implementation including analysis, design, data migration, customization,, workflow and deployment.
• Worked directly with the Azure Product team in tracking and resolving defects in the beta Azure IaaS offering.
• Participated in Creation of Azure Web Application projects, updated and deployed ASP.NET Web apps, Web Jobs using visual studio, GitHub and Azure Resource Manager
• Involved in developing the Azure Solution and Services like IaaS and PaaS.
• Used AZURE APP.FABRIC Message BUS to provide valuable functionality for integrating existing systems and building composite applications.
• Participated in design and development of PL/SQL sub programs like stored procedures, triggers and sequences to access Oracle.
• Experienced in Business Analysis, Data Analysis, Quality Analysis and Project Management
• Involved in developing User Stories throughout the Agile Lifecycle as well as created UML diagrams such as Use Case, Activity, ER diagram and Chart diagrams with MS Visio.
• Involved in formal requirements gathering methodologies, and developed reports based on specifications.
• Performed in-depth analysis of workflows, data collection, and report details associated with Epic
• Responsible for defining the key identifiers for each mapping and data modeling process.
• Participated in Requirement gathering from Inception and creating RTM, Functional Specification Documents and Data Mapping Analysis for System Integrations.
• Responsible for documenting the mapping and requirements of group insurance for interface and conversions between the source and applications
• Worked with technical team to improve report performance and performed system testing. Performed tasks like test cases, identifying defects, mockups, quality reporting, data cleansing and data quality.
• Served as a liaison between the internal and external business community (Claims, Billing,, Capitation, Customer service, management, provider management, and provider agreement management) and the project team.
• Recorded requirements in the Requirement Traceability Matrix (RTM) defining each technical requirement in detail from areas like: application software, networks, servers, internet and desktop configuration
• Actively involved in updating internal processes (submit claims, check eligibility), updating data collection and data reporting
• Coordinated tasks with other programmers, business users, database administrator, mainframe team, testing team and development team.
• Involved in meetings to analyze the services and process. Conducted detailed assessment of operational workflow.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements
• Performed rigorous unit testing and integration testing of billing module with DML and FICA preparing several test cases.
• Designed invoice layouts and got developed in Print Work bench with the help of technical team
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Performed rigorous unit testing and integration testing of billing module with DM and FICA preparing several test cases
• Contributed in various phases of solution implementation which includes requirements gathering, business process mapping, solution design, gap analysis, solution configuring, development and testing, migration and post go-live support.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and SQL server 2012 databases.
• Analysis of client requirements in developing business solution for SAP CC, FICA Design, Development, Testing, and transporting to Test and Production environment.

Confidential

Business Analyst

Environment: Quality center, UNIX/Linux Confidential Visual Ms Project, Java, Oracle 11g, Web Sphere, J unit XML, VB Script, J boss, Perl, C#, MS Visual studio, Test Director, python

Responsibilities:

• Reviewed the business requirements document with the business and development team to understand the architecture and functionality of the application
• Participated in development of Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Extensively involved in the SSAS storage and Partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX and SQL
• Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
• Worked with Reporting team to get to an agreement on what level of complexity to be handled by ETL and reporting side
• Participated in development of mappings and SCD type-II mappings in Informatica to load the data from various source to ODS tables Hands on experience with data steward tools like data merge and hierarchy manager in MDM.
• Involved in strategies for data extraction from various source systems, transformation and loading into data warehouse target systems.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner
• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities
• Working closely with the stakeholders for understanding and gathering the software requirements for delivering the best product possible
• Participated in creation of SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Involved in Production Support on Rotation Basis to run and Monitor Daily, Weekly, Monthly, Quarterly and Adhoc loads.
• Identified data requirements from source systems and defined ETL processes for extracting data from external systems
• Responsible for writing complex SQL queries in Informatica Mapping and developing stored procedures using PL/SQL
• Involved in Creation of mapping documents to outline data flow from sources to targets. Parsed high-level design specification to simple ETL coding and mapping standards.
• Participated on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables.
• Actively participate in review meetings with Project Manager to ensure that the development of projects meet business and system requirements for design development testing and production rollover of reporting and analysis projects within Tableau
• Designed views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions
• Performed UAT and participated in writing test plans, and developed different testing strategies like black box testing and load testing
• Acting as a liaison between the developers and Users/Management, playing an instrumental role in resolving conflicts between Stakeholders and technical development team
• Attended meetings with QA and developers to discuss defects
• Conducting JAD sessions to allow different stakeholders to communicate their perspective with each other, resolve any issues and come to an agreement quickly.
• Provided advice on the effective use of resources and ensured requirements traceability by maintaining requirements traceability matrices (RTM's) to avoid scope creep.
• Documents (HLVS), Business Requirement Documents (BRD), Functional Requirement Documents (FRD), and Non-Functional Requirement Documents (NFRD), Requirements Traceability Matrix (RTM), Software Requirements Specification (SRS), Data Mapping document.
• Preparing Workflow diagrams, Gap Analysis - 'As-Is' and 'To-Be' scenarios, designing new process flows and documenting the existing business processes and scenarios.
• Worked with technical team to improve report performance and performed system testing. Performed tasks like test cases, identifying defects, mockups, quality reporting, data cleansing and data quality.
• Served as a liaison between the internal and external business community (Claims, Billing,, Capitation, Customer service, management, provider management, and provider agreement management) and the project team.
• Recorded requirements in the Requirement Traceability Matrix (RTM) defining each technical requirement in detail from areas like: application software, networks, servers, internet and desktop configuration
• Following UML based methods using Visio to create use cases, activity diagrams, Process Flow Diagrams, and Flowcharts.
• Coordinated tasks with other programmers, business users, database administrator, mainframe team, testing team and development team.
• Involved in meetings to analyze the services and process. Conducted detailed assessment of operational workflow.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data
• Contributed in various phases of solution implementation which includes requirements gathering, business process mapping, solution design, gap analysis, solution configuring, development and testing, migration and post go-live support.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Used application life cycle management to log, track, report and maintain the defects, changes, issues and to ensure up-to- date recordings for increased efficiency in production
• Maintained all versions of the document during the requirements gathering process as well as the final approved version on SharePoint
• Analyzed business needs and worked with technical and non-technical teams to overcome challenges worked with business users, stakeholders and SME's amongst the organization
• Worked with business and customer on new initiatives, identify and provide insight and recommendations of what data will be helpful to reach the desired project goals
• Performed UAT and participated in writing test plans, and developed different testing strategies like black box testing and load testing