SUMMARY

• Overall 10+Yearsof extensive IT Experience inData Analyst/Business AnalystandBusiness Intelligenceapplications inEcommerce, Financial, Health Care and Manufacturing industries.
• Experience in Data Migration, Data conversion, Data Integration.
• In depth knowledge of SDLC phases such as requirement analysis, design, development, implementation, deployment and maintenance with strong understanding of methodologies like Waterfall, Iterative and Agile.
• Developed data mapping documentation to establish relationships between source and target tables including transformation processes using SQL.
• Experienced to work as Data Analyst to perform complex Data Profiling, Data Definition, data mining, data analytics, validating and analyzing data and presenting reports.
• Extensive experience in handlingData Conversion and Data Migrationprojects for various source and target in RDBMS (DB2,SQL Server)as well as File System.
• Experience on business intelligence (and BI technologies) tools such as Data warehousing, reporting and querying tools, Data mining and Spreadsheets.
• Expertise inTeradata 16.20,SQL Server,Informatica, SSIS, SSRS, SSAS, UNIX,Toad,Microsoft Office Suite.
• Experienced in writing UNIX shell scripts, SQL Loader, Procedures/Functions, Triggers and Packages.
• Vast experience of working in the area data management including data analysis, gap analysis and data mapping.
• Excellent exposure in Data Profiling with to Data Warehouse and BI development.
• Worked extensively with Dimensional Modeling and Data Migration.
• Created SQL queries to validate data and PowerShell scripts to automate processes.
• Experience in Performing data validation, transforming data from RDBMS oracle to SAS datasets
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Experience in data analysis, data visualization usingTableau/Microsoft Power BI,model building using statistical/econometric tools likeSAS and R, data mining usingpython, SQL, Hadoop, Spark, Hive,etc.
• Developed SQL scripts for data validation and cleansing.
• Conducted extensive data validation on large data sets, communicated conclusions and recommendations to Project Manager.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Ensured all documents and workflows meets the client requirements.
• Worked with Data Modelers to create a Physical Data Model from the Logical Data Model using Erwin tool.
• Experience with creating reports using Business Objects.
• Excellent understanding of Microsoft BI toolset including Excel, Power BI, SQL Server Analysis Services, Visio, Access.
• Experience in Creating master Data workbook, which represents the ETL requirements such as mapping rules, physical Data element structure and their description.
• Extensively used SAS procedures like means, frequency and other statistical calculations for Data validation.
• Proficient in programming using SQL, PL/SQL.
• Strong knowledge of database management in writing SQL queries using complex joins, grouping, aggregation, nested sub queries, and resolving key performance issues.
• Extensive experience in creating simple and parameterized reports and complex reports involving sub reports, charts and graphs in various BI and data visualization tools like Tableau.

TECHNICAL SKILLS

Programming Languages: C, Visual Basic, C++, VB 6.0, SQL, Hadoop (Hive, Pig), Python, R.

Scripting Languages: MS - DOS, Bash, Korn.

ETL tools: Confidential Power center, SSIS, AbInitio.

Data modeling: Sybase Power Designer, Data Architect.

Frameworks: Struts, Spring, Hibernate, Spring MVC, Spring Web Flow, Spring IOC, Spring AOP, Groovy.

Application/Web Servers: JBoss, Glassfish 2.1, WebLogic, Web Sphere, Apache Tomcat Server.

MSOffice Package: Microsoft Office (Windows, Word, Excel, PowerPoint, Visio, Project).

Visualization tools: Tableau Desktop, Python, Pandas, NumPy, Datorama.

ETL Tools / Tracking tool: Confidential, SSIS, SSAS, SSRS / JIRA.

Database Development: T-SQL and PL/SQL, Microsoft Hyper-V Servers.

Databases: Teradata R12 R13 R14.10, MS SQL Server, DB2, Netezza.

Operating Systems: Windows, UNIX, Sun Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, NC

Data Analyst/ BI Business Analyst

Role &Responsibilities:

• Responsible for creating critical compliance test analysis documents andBusiness Requirement Documents (BRD).
• UsedMS Visioto carry out theBusiness Use Case ModelingandBusiness Object Modelingeffort to develop the business architecture for rapid and controlled application development.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Implemented advanced SQL queries usingDML and DDLstatements to extract large quantities of data from multiple data points onMS SQL and Teradata SQL Assistant.
• Designed series of scripts to automate pricing processes using SQL, PowerShell, and VBA
• Experience in Data Migration, Data conversion, Data Integration.
• Modelled the present system and performed a completeGap Analysisto map it to the 'to be' developed system.
• Developed varioustableau BI charts on assortment planning and reporting
• Working on live site issues to fix slow running stored procedures, triggers etc. and provide Root cause analysis.
• Developed ETL for Data Extraction, Data Mapping and Data Conversion for various application and processes.
• Used MDM tool to support Master Data Management by removing duplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data and filter data as per requirements.
• Involved in Data mapping, logical data modeling used SQL queries to filter data within the database tables.
• MDM to resolve data issues to recognize the inconsistent and duplicate data and finding useful relationships to improve business performance.
• Experience in Data Analysis, understanding trends and patterns in data.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, various other data sources toMS SQL Server by developing SSIS (SQL Server Integration Services)packages.
• Performed Risk Analysis of the requirements to identify the key business risk areas for the project and prioritized the application development.
• Tested the brokerage and financial services applications like Equities, Fixed Income, Investment Research, Investment Deposits, Accounts Activity, Balance Holdings, Portfolio Management, E-statements, Retail Consumer Lending, Mortgage Modules, Integration Module
• Provide technical platforms for end users using SQL, Powershell, Access, XML etc. to revamp efficiency of daily task
• Extensively usedSSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• CreatedSSISpackages to implement error/failure handling with event handlers, row redirects, and loggings.
• Created SSIS packages in such a way that they can be dynamically deployedinto Development and Production Environments.
• Experience in data conversions using SQL queries, PL/SQL stored procedures in TOAD, SQL Developer.
• Created and ConfiguredOLAP CubesusingSQL Server Analysis Services (SSAS).
• Extensively involved in SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports usingMDX and SQL.
• CreatedKPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
• Developed dashboards and ad-hoc reports using MS Power BI, Tableau and SSRS for senior management team for analysis.
• Manage the Order to Cash track which includes Oracle modules such as Order Management, Inventory, Shipping, Service Contracts, Install Base, AR - Billing, Invoicing and other applications such as SFDC, Service Source and Key server
• Deployed Tableau dashboards in production after user acceptance test clearance.
• Created different tabular reports using Power BI features and enhanced them based on user requirements.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
• Experienced in all phases of theSoftware Development Life Cycle(SDLC) including requirements gathering, analysis, design, implementation, testing and deployment as well as software engineering methods.
• Provided continued maintenance and development of bug fixes for the existing and newPower BI Reports.
• Published dashboards on an intranet site using SharePoint Server.
• Worked with Oracle Support / Metal ink to resolve bugs and defect management.
• Collaborated with different stakeholders from various business units to validate and approve compliance tests independently.

Environment: Relational data models, Test Cases, Data Marts, PowerShell,Oracle 10g, Data conversion, Data warehousing, SQL, Power BI, Python, R, ETL, Star schema models, predictive analysis, Python,Smart Draw, SDLC, MS Project, SharePoint, DFD, GAP Analysis, MS Excel/PowerPoint/Word, Windows, Tableau, hive, Pig.

Confidential, Boston, MA

Data Analyst/ BI Business Analyst

Responsibilities:

• Worked with the business users to define business requirements and analyze the possible technical solutions.
• Kept a track of all QAT and UAT bugs/defects and helped the testers to resolve the issues and made a report of all the defects which were resolved.
• The Insurance Company had an objective to develop a web tool to provide a premium estimate and provide insurance web purchase facility to clients. I reported to the project manager for the same regards and our team succeeded in delivering the ecommerce based web portal.
• Strong experience in design and development of ETL process from Staging to Data warehouse and to Data Mart.
• Strong Work experience onEcommerce portals web applicationdevelopments,B2B,B2C, Content Management Systems for Ecommerce likeATG.
• Responsible for all web development, E-commerce and optimization and web strategy and corporate website and self-service intranet site.
• Created custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations.
• Gathered requirements for the integration of Point-Of-Sale (POS) system with the supply chain system.
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirements gathering.
• Experienced to use analytical tools (Google analytics, Adobe analytics & Core metrics) for reporting of ecommerce conversions, engaged visitors, readers, calls of actions, bounce rate, social engagement tracking and email tracking.
• Prepared PowerPoint slides to effectively communicate with the business users and stake holders in the meetings.
• Conducted the AS-IS and TO-BE analysis of the business process using GAP analysis
• Identified gaps and performed gap analysis with respect to CMS (Content Management System) requirements
• Provide best practice recommendations in the areas of Order Management System and CRM.
• Analyzed trading partner specifications and created EDI mapping guidelines
• Used Restful web services for implementing the Business Logic.
• Gathered requirements from the stakeholders and followed the UML based methodologies using rational rows for business modeling.
• In depth knowledge of relational databases and enterprise-wide system interfaces Proficient with Supply Chain Management (SCM)
• Responsible for preparing data dictionary, SQLQueries and read Java code for Developers to fix defects and change request.
• Integrated the acquisition of new retail chain and buying process RMS (retail merchandise systems) into the existing application.
• Created wireframes and storyboards.
• Designed and worked on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications.
• Experience using Oracle, MySQL database and understanding database schemas
• Responsible for E-commerce website developed in Hybris Platform for new enhancement of existing B2B and B2C applications.
• Expertise in MS Office Suite, MS Project for Project Plan, MS Visio, Rational Rose, Rational Requisite Pro, Rally.
• Established connectivity to all major buy-side vendor order management systems (OMS).
• Designed and developed project document templates based on SDLC methodology.
• Performed Functionality, Integration, GUI, Regression, Usability and System testing.
• Experienced in interacting with business users and executives to identify their needs, gathering requirements and authoring Business Requirement Documents (BRD), Project Charter and Project Approach Documents
• Used DATABASE Testing for data mapping, Data testing between web applications, inserting data, retrieving data using SQL queries and Sybase Rapid SQL.
• Worked with several J2EE based application development teams to provide them Middleware solutions like Weblogic, WebSphere, Web service, MQSeries etc.
• Knowledgeable and experienced e-commerce Business Analyst for Oracle E-Business Suite with an emphasis on O2C including I Store, Order Management, Service Contracts, and Advanced Pricing.
• Responsible for strategy, circulation planning, modeling, forecasting and implementation of catalogs and direct marketing campaigns.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Experience in design of Data Warehouse/Data Mart, Star Schema, ODS, ETL process, Data Requirement Analysis, Data modeling &ER-Diagrams, DB2, Development, Testing, Data Documentation and Implementation of Business Applications.
• Helped the Business Users while performing the UAT testing and helping them resolve the defects in the environment.
• Performed extensive data modeling to differentiate between the OLTP and Data warehouse models
• Experience in Working with DBA team to provide application support and troubleshoot any issues related to Oracle e-Business Suite.
• Responsible for implementing supply chain Management (SCM) and operations solutions.
• Utilized UML and source-to-target mapping to cause a clarified understanding of the project and the ETL process, and worked alongside the ETL development team to sort out issues and maintain a consistent completion of stories in JIRA.
• Ensured issues are logged and dealt with clear issue resolution and risk contingency plans.
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Hosted status meetings, demos and presentations for the stakeholders and other team members.
• Responsible for Resource management, budgeting and structuring project teams to ensure maximum performance.
• Conducted user meetings, gathered requirements, documented requirements, conducted JAR/JAD sessions.
• Interacted with Development and Testing teams on compliance and analyzing the business requirements and application developments as per the system and functional specifications.
• Developed and maintained project schedule and periodically updated the project team on the project status and the progress made at regular intervals.
• Prepared user manual and performed user acceptance testing.

Environment: SQL, PL/SQL,MDM, ETL,PowerBI SQL Navigator, Quality Center, XML, Power BI,Triggers, Visio, Teradata, Visio, Agile, Tableau, Mainframe systems, MS SQL Server,ETL, MS Excel, Windows Server.

Confidential, Orlando,FL

Data Analyst/ BI Business Analyst

Responsibilities:

• Facilitate all agile ceremonies including sprint planning, daily stand-ups, grooming, review and retrospective sessions.
• Functional Knowledge of Medicaid Management Information System MMIS.
• Conducted meeting with SME’s and business owners to identify Functional and Non-functional requirements.
• Conducted the defect report using Document Generator in JIRA.
• Gathered Requirement for Data Mart integrating data from UDB/DB2, Oracle, SQL Server, text, Excel, and Access.
• Utilized Power BI to create various analytical dashboards that helps business users to get quick insight of the data.
• Interacted with Subject Matter Experts (SME), Business Owners; Conducted detailed interviews with them, recorded the requirements, and reviewed the gathered requirement by both technical and business people to break down functional requirement and document detailed User Stories.
• Analyzed the business process to identify gaps with the implementation in New Market by creating Process Flow diagrams in Visio.
• Created Business Requirement Document (BRD) and subsequent Scope document.
• Clarifying the requirement to help IT team understand and provide extensive information related to requirement with help of business owners and proxies.
• Worked in Agile process of the project management based on SDLC.
• Created verified and edited, corporate body, subject, and series headings in MARC.
• Multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, WebSphere and Congo’s.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Used Back-end testing using SQL queries to validate the data in the back-end Oracle Database.
• Identified bugs and interacted with team lead and developers to resolve the bugs.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on business Requirements, technical specifications and/or product knowledge.
• Involved in preparing Test Cases based on business requirements.
• Working with different IT & Business groups to understand and determine the Impacts to the Data Warehouse and/or Data Marts for different projects.
• Responsible for efficient document management using MS SharePoint and to update the document and transmit the information to all stakeholders
• Supported worked with different project and teams for documenting requirements.

Environment: Micro Strategy Desktop/ Server 13.10, SSIS, Tableau,PowerBI, SSRS, Teradata SQL Assistant, Teradata Administrator, SQL Developer, Power Designer, MS Office Suite Word, Excel, PowerPoint, SharePoint 2010, MMIS,MITA,SOA, Erwin, COBOL, PL/SQL, HTML, Java, XML, MS Office, MS Visio, MS Access, DB2, EDI, UML.MMIS.

Confidential

Data Analyst/ Business Analyst

Responsibilities:

• Experience in the Data Analysis,, Data Quality, Data Integrity, Design, Development, Implementation
• And Testing of Business Intelligence applications using ETL and ELT methodology.
• HandsonexperienceofSQL-DataManipulationLanguage DML,DataDefinitionLanguageDDLand
• Extensive knowledge of advanced econometrics and statistics skills and tools such as SQL, R, Excel, Mat lab.
• Working knowledge with python data wrangling libraries.
• Knowledge of Power BI and Tableau Desktop report performance optimization.
• Assisted data analysts to develop logical data models, source data cleansing and data profiling. Essentially applied business rules in the transform phase.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse /ETL Andreporting team.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Financial modeling and numerical methods for equities and derivatives using MATLAB and VBA.
• Designed supervised and un supervised machine learning and implemented with python
• Expert on maintaining and managing Microsoft Power BI and Tableau reports, dashboards and publishing to the end users for Executive level Business Decision.
• Experienced in managing users, groups, sites, permissions and roles on Tableau server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services(SSRS)
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata
• Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.
• Created conversion scripts by writing SQL queries and PL/SQL procedures using TOAD or other comparable SQL development tool for Member Management.
• Experience in writing complex SQL queries involving multiple tables with inner and outer joins, stored procedures.
• Interview customers and capture data requirements
• Familiarity with both dimensional and relational databases
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development.
• Experienced in managing users, groups, sites, permissions and roles on Tableau server.
• High level analytical and problem solving skills, with a demonstrated ability to investigate complex issues and make informed decisions
• SQL's Database Diagram used to create Table Relationships, and testing of Table Relationship was performed to validate Referential Integrity

Environment: Rational Suite, SAS/ Base, Microsoft.NET, Crystal Reports, Basel, SQL, Teradata, ETL, SQL SERVER, SME’s, SDLC, UML, Agile, Teradata, MS-Visio, MS-Project, SCRUM, MS-GP, Rational test Suite, UML, Windows NT, UNIX, PL/SQL.

Confidential

Business Analyst

Responsibilities:

• Developed complex mappings to extract source data from heterogeneous databases Tera- Data, SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Used Team Foundation Server to provide source code management, reporting, requirements management, project management for agile software development, build lab management, testing and release management capabilities.
• Worked in ETL environment involving Informatics/Data Stage and Business Intelligence tools like Cognos, Tableau, and Business Objects.
• Initiated Requirement gathering, analyzing, validating, and authoring use cases using UML.
• Prepared Use Case documents for all system requirements and followed the RUP process
• Interacted with Legal & Compliance team to include regulatory aspects.
• Used Siebel Customer order management to simplify the complex of tracking products across multiple catalog and systems, present-targeted product bundles for greater revenues, reducing operating costs.
• Held JAD, RAD sessions, finalized business requirements & prepared functional specifications
• Involved in Inception Phase and prepared logical data models, BRD, supporting document indoors containing essential business elements, definitions and descriptions of the relationships between the actors to analyze and document business data requirements.
• Using Power BI to create various analytical dashboards that helps business users to get quick insight of the data.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
• Documented various phases of product life cycle, and details of each iteration execution.
• Arranged meetings & Managed meeting minutes & created Business process flows in BPMN
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Performed billing functions for clients, insurance carriers, and Third Party payers.
• Wrote SQL commands and procedures, to check for newly provisioned Mortgage and credit data for consistency and updated invalid fields with proper value.
• Worked through the testing lifecycle by developing test cases, test plans, manual tests
• On HP Coactively involved in developing, executing and managing User Acceptance Testing (UAT).
• Used TSS to process safe secure payments, keep track of all finance billing information.
• Analyzed complexETLrequirements/tasks and provided estimates/ETCs and researched Oracle data using Oracle warehouse builder used Visio to draw flowcharts and swim lane diagrams.
• Used MS Project for project scheduling, worked with coders in development
• Effectively implemented the Change Management and Configuration Management process.
• Performed change configuration management and defect management
• Analyzed business requirements and constructed business logical models.
• Prepared user guide & support documentations. Expanded existing filing resources, trained team on it
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Worked on generating various dashboards in Tableau Server using differentdatasources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.

Environment: Rational Suite, SAS/ Base, Crystal Reports, SQL, ETL, SQL SERVER, SDLC, UML, Agile, Teradata, MS-Visio, MS-Project, SCRUM, Rational test Suite, UML, Windows NT, UNIX, PL/SQL