PROFESSIONAL SUMMARY

• Having 8+ years of experience in Data Analyst experience with excellent analytical, decision - making and interpersonal skills, always willing to work in challenging and cross platform environment. Data management, Requirement gathering, profiting and analyst roles in a fast-paced environment.
• Well versed with all phases of Software Development Life Cycle (SDLC) including but not limited to the various concepts such as Requirement Gathering. Proficient in Requirement Management, including gathering, analyzing, detailing and tracking requirements.
• Extensive knowledge of SDLC methodologies like Agile (Scrum, RUP), ITIL, Waterfall Incremental and, Rapid Application Development (RAD).
• Strong Knowledge and hands-on experience of SDLC methodologies and Business Process Models (BPM) like Agile Modeling and Waterfall model.
• Extensive experience in building reports and dashboards in Microsoft Power BI by using Azure Data Warehouse and Microsoft Azure Analysis Services, involved in performance tuning of reports and resolving issues within database and cubes.
• Extensive experience in gathering Functional user requirements, creating Use Cases and creating Functional Requirement Document (FRD) as per user requirements in addition to creating Business Requirements Document (BRD).
• Experience in working with product backlogs, sprint backlogs along with creating user stories and prioritizing user stories and keeping track of burn down charts.
• Organized and managing meetings between Business users and MMIS staff.
• Functional knowledge of Medicaid Management Information System (MMIS).
• Extensive experience in development and designing of ETL methodology for supporting Data transformations and processing in a corporate-wide environment using Teradata, Mainframes, and UNIX Shell Scripting.
• Good experience in Production Support, identifying root causes, Troubleshooting and Submitting Change Controls.
• Experienced in handling all the domain and technical interaction with application users, analyzing client business processes, documenting business requirements.
• Possess strong analytical and problem-solving skills and have a quick learning curve. Committed team player and capable of working on tight project delivery schedules and deadlines.
• Strong knowledge of UML Modeling, including Use Cases, Sequence, State and Activity diagrams, Data mapping, participated in architectural design and class design.
• Worked and extracted data from various database sources like Oracle, SQL Server, DB2, and Teradata.
• Experience in working with product backlogs, sprint backlogs along with creating user stories and prioritizing user stories and keeping track of burn down charts.

TECHNICAL SKILLS

Data modeling Tools: Microsoft Visio, ER studio, ER studio, UML Class Diagram, Tableau (Data Visualization/Analyst), Data Warehousing (Fact and Dimension Tables) and ETL Processes, EMR Consultant, Object diagram, Use case diagram, Sequence diagram, Collaboration Diagram, Activity diagram, State Chart Diagram, Deployment diagram, Component Diagram

Programming Language/Tools: ANSI X12 Files, Oracle SQL, Java, XML, Python, HTML, PHP, UML, UNIX/LINUX, Visual studio, Microsoft SQL Server, MySQL Shell, Tableau.

Operating System: Windows 2000, Windows XP, Windows Vista, Windows 7,8 & 10, Microsoft Server Operating System.

Software/Tools: MS Project, MS Visio, Rational Requisite Pro, SQL, Oracle, SAS, TOAD, MS Excel, MACROS, UAT and Waterfall SDLC Methodology, RUP, MS Project, ANSI X12 - EDI, Rational Rose, HP Service Desk, MS Visio, Rational Requisite Pro, SQL. MySQL Shell, RDBMS, Advance SQL.

PROFESSIONAL EXPERIENCE

Confidential, New Brunswick, NJ

Sr. Data Analyst

Responsibilities:

• Responsible for gathering requirements from Business Analyst and Operational Analyst and identifying the data sources required for the request.
• Performed Data analysis on many ad hoc request's and critical projects through which some of the critical business decisions will be made.
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Aggregate functions were executed on measures in the OLAP cube to generate information about dynamic trends including bandwidth consumption and their cost analysis.
• Generated periodic reports from the OLAP cubes based on the statistical analysis of the trends about location and bandwidth data from various time frames and departments using SQL Server Reporting Services (SSRS) to project various KPI's.
• Worked on loading data from flat files to Teradata tables using SAS Pros Import, Fast Load and MS Excel Macros Techniques.
• Expertise in writing MS XCEL VBA CODE, created numerous tools as per business requirements using Teradata as data base server and used user forms and various other function in VBA.
• Helped in Development and implementation of specialized training for effective use of data and reporting resources.
• Converted Celsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility
• Worked on Bar charts, line Charts, combo charts, heat maps and incorporated them into dashboards.
• Validating automated scheduled reports to catch any data issues or missing data before sending out to business customer.
• Worked with ETL team if there are any issues in production data like load delays, missing data and data quality and fix it. Also involved in modification and creation of new data warehouse table design.
• Good experience in creating complex logic to meet the business requirements in building the reports or for their data needs and maintaining quality of data.
• Good understanding of HIPPA compliance requirements and Performed QA on reporting so all our reporting is coming from reliable source and is HIPPA compliant.
• Wrote hundreds of DDL scripts to create tables and views in the company Data Warehouse, Ad-hoc reports developed using Teradata SQL, and UNIX.

Environment: Oracle 10G/11g, PL/SQL, Congo’s, Qlikview, SAS, Tableau, Visio, Spot fire, SQL Developer, Teradata SQL ETL, Data Processing, Data migration, Data modeling Adobe Analytics, MS-Windows/Microsoft Office Suite, VB.NET.

Confidential, Mountain View, CA

Sr. Data analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Participated in the ETL migration ETI to Data Stage and in the DBMS migration Oracle 11g to Teradata.
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality issues for Basel II Credit Risk Mitigation System (CRMT)
• Worked closely with testing team and helped in testing the Informatica mappings, workflows, Abinitio Graphs and Teradata scripts.
• Used Python modules like Pandas and date time to perform extensive data analysis.
• Created context-sensitive on-line help files for a wholesale banking software. This involved creating animated help screens, writing RTF files, capturing screens, creating hotspots and compiling help files.
• Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Involved in supporting over the counter (OTC) derivative trade capture and straight through processing (STP).
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Used Python programs automated the process of combining the large datasets and Data files and then converting as Teradata tables for Data Analysis.
• Worked closely with the Enterprise data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Worked on GAP Analysis for RDR and HUB Tables for each source system populated in RDR and HUB.
• Interacted with users for verifying user requirements, managing change control process, updating existing process flow, and FRD and TDR documents.
• Analyzed application requirements with UML modeling (MS Visio) and documented Dialogue application output management and FileNet Enterprise Content Management solutions
• Involved w data profiling for multiple sources and answered complex business questions by providing data to business use.
• Heavily interacted with Data Warehousing team in Metadata Modeling and gathering requirements for product catalog Data load specifications for Data mapping and Data Modeling.
• Utilized Enterprise Service Platform (ESP) for creating categories/elements, and data marts for the OLAP application in order to meet the compliance reporting requirements.
• Worked with SQL and Data Warehousing for arrangement of customer data.
• Wrote SQL queries to perform Data Validation and Data Integrity testing.
• Generated graphical reports using python package Numpy and Matplot Lib.
• Developed views, functions, procedures, and packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Developed Python programs for manipulating the data reading from various Teradata and convert them as one CSV Files.
• Data objects such as Connection, Command, Data Adapter, Data Reader, Dataset, Data Table and XML for consistent access to SQL data sources
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Various versions of the documents generated during the project were maintained and managed using Rational Clear Case and performed defect tracking using Rational Clear Quest.

Environment: Crystal Reports, Toad, Dashboard, Oracle 10g, PL/SQL, Teradata SQL ETL, Tableau Desktop 8.0, 7.0, 6.02, Tableau server Data Processing, Data migration, Data modeling Windows 7, C#, Asp.Net, ADO.Net SIEBEL, Excel, SAS, JIRA, Tableau, Spot fire, Share Point.

Confidential, Los Angeles, CA

Business Analyst/Data Analyst

Responsibilities:

• Gathered of functional and system requirements for Software Development.
• Extraction of information from relational and dimensional databases, MSSQL (2008, 2012) using SQL and presenting Excel as needed.
• Proposed software enhancement and changes to database table structures based on results from data extracted and analyzed.
• Working with other team members in prioritizing project requirements. (Network Pro Development).
• Organized join application and development (JAD) sessions to disseminate results from requirement gathering and to keep track of project progress.
• Performed business modeling and analysis as required.
• Performed data queries to present technical reports using data Visualization.
• Achieved ad-hoc analytic tasks with complex data collection, evaluation, and analysis among relational databases.
• Delivered high-quality analytic deliverables and clearly and concisely communicated results to the diverse audience and stakeholders.
• Established routine and effective rapport with team lead, BA lead and project manager allowing myself to get insights of the project that play a part in understanding the nature of the product/service/requirements.
• Facilitated joint application development sessions for gathering and defining data conversion and business rules/ETL requirements.
• Investigated and documented technical interface requirements that would best suit the needs of the technical architectural development assumptions.
• Executed SQL to extract data from different sources and presenting the data in an easily understandable way for the business process data flow design of each project documented.
• Defined and documented queries for generating drill down and drill through reports in SSRS.
• Documented ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, failure reports with the error description.
• Wrote data analysis relevant queries in SQL server RDBMS dataset development including T-SQL programming.
• Created plans and lead the technical team-members, supporting Project Managers, to ensure that the solution architectural vision gets realized
• Worked with new EMRs to sandbox test work flows
• Designed and developed creative alternative architectural approaches wherever conventional ones are not possible
• Developed and delivered at least one architectural recorded training session per quarter for other members of the Client Services organization
• Installation, configuration, and working knowledge associated with Interface Engines (e.g. Cloverleaf, Mirth)
• Presented weekly status on technical approach, and roadblocks for new EMR connections
• Provided project management and team leadership.
• Provided guidance for the structuring of programming requests.
• Created data sets for analysis using database and analytic tools.
• Presented data and information to achieve business goals.
• Identified risks and communicated possible solutions.