EXPERIENCE SUMMARY:

• Having 5 Years of extensive experience in Business Analysis, Data Analysis, System Analysis and Data Visualization experience in various domains.
• Hands on experience in writing SQL queries and optimizing the queries in SQL server 2012.
• Extensive knowledge and work experience in RDBMS concepts like Views, Triggers, Stored Procedures, Indexes, and Constraints.
• Performed data analysis and data profiling in SQL on various sources systems
• Experience with Data analysis and SQL querying with database integrations and data warehousing for large financial and manufacturing organizations.
• Involved in conducting data analysis of system defects, SSIS package and Stored Procedure analysis to identify root cause.
• Experience in database management and query management tools for extracting required data findings; writing SQL Queries for extracting, updating and analyzing data.
• Worked as a Tableau Admin/Developer and Analyst in Health care and Finance Environment with Tableau 8.x/9.x (Desktop, Server).
• Experience in creating different Tableau visualizations like Bars, Lines, Pies, Bubble, Bump, Gantt, Motion and Waterfall Charts.
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
• Strong experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, Agile/Scrum, RUP (Rational Unified Process) and Software Testing Life Cycle (STLC).
• Extensive experience in creating Screen Mockups and Wireframes, conducting GAP Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Proven record of Team Management and Leadership skills. Excellent Presentation skills in regards to communicating with both business and technical teams.
• Experience in analysis and review of Software and Business Requirement Documents with strong background in Documentation.
• Experience in Data Modeling creating Star & Snow - Flake Schemas, Fact and Dimensions Tables, Physical and Logical Data Modeling.
• Extensive knowledge on relational database concepts like Tables, Entity Relationships, Primary and Foreign keys, Joins, Views and Indexes.
• Highly proficient in writing User stories, creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams etc. Extensively used Rational Rose and MS Visio for UML.
• Experience in developing Requirement Traceability Matrix (RTM), conducting GAP analysis, system documentation and User Acceptance Testing (UAT).

TECHNICAL SKILL SET:

Languages: R Program

Database Modeling: E-R model, Star model, Snow Flakes model

Oracle Concepts: Partitions, Virtual Private Database, Auditing (Fine grained auditing), Oracle RAC, Performance Tuning (AWR, ADDM), Grid Control, Oracle Jobs, RMAN, Oracle ASM, Oracle Flash back, Oracle recycle bin, Oracle Advanced Queuing, Oracle Streams, Golden Gate

Development Tools: Eclipse, BlueJ, ETL (SSIS, SQL * Loader, IMP/EXP Data Pump), Oracle SQL Developer, SQL Plus, Erwin, TOAD, SSMS, SSIS, SSAS, SSRS, MS Visual Studio, Tableau

Development Methodology: Agile/Scrum, Waterfall

Operating System: UNIX, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Kersey, PA

Data Analyst

Responsibilities:

• Researched and analyzed existing business processes and systems to formulate logical statements of business requirements.
• Looked at the various systems (Origination, servicing system, Data Mart) and understand the transformation.
• Built the lineage mapping document and looked at all the source to be able to document and test the transformation.
• Served as interface between users and Software Engineers to identify software modifications tailored to clients' needs using Leverage (ALS and Policy Link).
• Analyzed how data flows from Point A to B based on line of business (home, auto loans)
• Prepared data lineage mapping documentation.
• Facilitated testing data lineage and prepared data lineage testing documentation.
• Interacted professionally with a diverse group of executives, managers, and subject matter experts.
• Extensively involved in Consumer loan lending process, loan origination, and ALS loan booking process, payment applications, ALS billing & coupon concepts and Citibank, specific external interfaces.
• Assist Data Stewards in their research and testing of their Critical Data Elements (CDE).
• Understand the source systems feeding the Basel Lending Data Mart (BLDM).
• Developed test plans, test cases, assisted in testing. Provide user documentation, user training, and post implementation support.
• Developed test plans and test case scenarios to guarantee the changes to the system design meets business requirements.
• Collaborate with business leaders, IT professionals, and vendors ensuring that management is kept informed of project status and the problems. Issues are escalated appropriately and clearly communicated.
• Demonstrated leadership and partnership skills by interacting with other technology teams within organization to solve problems and deliver solutions.

Environment: Microsoft Office Suites (word, Power point, Access, Excel, Outlook, Project, Visio), Windows, Share point, Quality Center, SQL, UML, Clear Case, Crystal Reports.

Confidential, Tampa, FL

IT Business/ Data Analyst

Responsibilities:

• Created Risk Reports, utilizing Microsoft Excel and PowerPoint, for the Service Delivery Leadership Team to review and take action upon.
• Created Safety Engagement reports which were presented on Safety Leadership Days to promote the importance of safety in any environment of the company
• Created User Guides via PowerPoint slides for ServiceNow detailing every step of current Service Delivery processes with images and clear visuals
• Placed Risk and Audit reports on Team Hub to display how effectively these areas are being managed
• Assisted in efforts to move the current Risk Register from excel to a more advanced and automated version on SharePoint.
• Involved in gathering business requirements, designed data maps and data models. Created Internal and External Design Documents and Transaction Definition Documents.
• As a member of Center Of excellence (COE) team provide solutions for the critical issues of the projects Data @finger tips, DSFM (India), Dealer Franchising and staff augmented matrix and support until they are on track.
• Involved in Relational Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools.
• Developed high Level Design of ETL Packages for different requirements in MS SQL Server 2008 for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) using SSIS.
• Extensively created detailed design documents, report templates and enrollment details, Tabular/Matrix Reports, chart Reports for key performance indicators, Summary Reports, Parameterized Reports, dash board reports and sub reports.
• Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported Reports into various formats from (PDF, Excel) and resolved formatting issues.
• Involved in deploying reports, schedule reports, and created groups and users. Used role based Security to control access to folders, reports and resources. Worked in creating and modifying data driven subscriptions, fine-tuning of standard subscriptions. Published and scheduled Business Objects Reports to users using Scheduler.
• Involved in installation of Sql Server 2012 on virtual machines and also Configuration of SQL Server Reporting Services 2012 to run in SharePoint server 2010 to enable the power view mode in share point server and also involved in installing the share point server 2010 on windows servers.
• Involved in designing, implementing the User metric dashboard POC, Score Card Automation POC and Resource management POC using both power view and tableau Ad-Hoc reporting tools.

Environment: Erwin, RUP, DTS, Query Analyzer, Business Intelligence Development Studio (BIDS), MS Excel, MS Access, MS Visio, MS SQL, Windows.

Confidential, Hoboken, NJ

Data / Business Analyst

Responsibilities:

• Utilized Business and Data Analysis skills to understand the Functional requirements to understand the data and write technical specifications
• Created Process Models and Workflows, to Modify Legacy Systems Architecture, to be in line with the End State Vision.
• Gather business and technical requirements for new and existing applications.
• Participate in requirements prioritization and work with development team estimate the level of effort.
• Conducting JAD sessions and collaborating with the team and stakeholders.
• Analyze and document business requirements and communicate requirements to different stakeholders during formal and informal review session.
• Translate high-level requirements into detail requirements suitable for software design and development.
• Gathered and Documented requirements in UML and Use Cases, constraints, and set priorities.
• Worked on creating the physical data models and logical data models.
• Involved in ascertaining the Level of Effort and Finalizing the Project Charter after an initial Scope Analysis.
• Used SQL queries to check the desired results and used Testing Queries to validate the Data Quality
• Extensive Involvement in End-to-End UAT Testing, with both CSV file and Actual Back-end Database Testing.
• Created Mock Up Production Like Data For UAT.
• Assisted in Created number of classes and objects, table aliases, contexts, pre-defined conditions and defined hierarchies

Environment: MS SQL Server, MS Visio, MS Office Suite, SQL, Crystal Reports, ER Studio.