SUMMARY

Spearheaded the entire project life cycle, outlining budgets, timelines, deliverables, incorporating project specifications into business, meticulously allocating and refining budgets, analyze, design, verify, maintain the systems performing Data Analysis, Modeling, Cleansing, Transformation, Migration, Performance Tuning, and Troubleshooting to achieve business goals

AREAS OF EXPERTISE

• Project Management & Business Analyst
• Implementation & Quality Assurance
• Risk & Requirement Analysis
• Data Analyst
• Confidential Care Domain
• E - commerce Platform
• SQL, PL/SQL
• SAS, Tableau Analytics
• Power BI and VBA Macro

TECHNICAL SKILLS

Development Platforms: Windows, Linux, Unix, IBM Mainframe z/OS

Programming: SQL, PL/SQL, MySQL, SAS, C/C++, Visual Basic, VB.NET, Java, VB Scripting, Unix scripting

Database: DB2, Oracle 9i/11g, PostgreSQL, SQL Server 2008/2012, Microsoft Access

Tools: Informatica PowerCenter 7.x/8.x, SASv8/v9, Microsoft Office, HP Application Lifecycle Management(ALM)/Quality Center, Rational Clear Quest, Rally, TBA (Total Benefit Administration), Salesforce CMT, SAP HMC/HAC

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Wauwatosa, WI

Responsibilities:

• Analysed and interpreted the data from different sources including Oracle, GLPROD,confidential, Salesforce systems
• Validated reporting data sources, its linkage and ensure the data quality meets required specifications
• Identified and defined new processes to analyse the data, built logics, formula’s, macros to replicate the approach
• Performed Importing, cleansing, transforming, validating and modelling data to understand and draw conclusions
• Designed and developed databases for collecting, storing data and design it for input and data collection mechanisms
• Developed system maintenance Standard Operating Procedures (SOP’s) and perform associated maintenance activities
• Anticipated challenges or roadblocks successfully mitigating the risks while achieving desired outcomes for client
• Worked closely with Production support/loading team to explain the changes required to build the impex for SAP Hybris
• Owned ecommerce order failure to ensure real-time resolution & processing the order manually or through Application
• Generated customized salesforce reports for business and performed administration work for accounts to manage
• Built Test scripts and verified different Hybris modules, discount coupons, modalities multi-carts and order integration
• Analysed data to ensure accuracy by performing data validation, cleaning & manipulation

Data Analyst

Confidential, North Brunswick, NJ

Responsibilities:

• Worked on requirements, functional specification to facilitate acceptance of desired features, functionalities between external and internal stakeholders
• Involved in daily Scrum, Iteration/Sprint meeting to plan the stories that needs to be developed and tested in the upcoming sprint based on the priority and estimates the effort
• Demonstrated excel spread-sheets through different representation and made it interactive dynamically using radio and checkbox functionality
• Built Informational, Strategic and Analytical Dashboards for evaluation and facilitated decision making for clients
• Collected, cleansed and provided modelling and analysis of structured & unstructured data used for major business initiatives
• Built and executed Test script, constraints, excel customized report for better understanding and for data validations
• Managed and ensured consistency of operating procedures, testing standards and batch job documentation standards
• Owned production deployment of system updates & led troubleshooting procedures to ensure real-time problem resolution
• Developed PL/SQL procedures to create database objects dynamically based on user inputs along with conversion scripts using stored procedures, functions and packages to migrate data
• Used SAS reporting to design customized report for better understanding and to optimize the approach Initiatives - Improve the Audit report
• Automated Audit Report to verify the existing data to generate the issues.
• Clean-up process improved through this approach and more than 30% of data issues were corrected

Lead System Analyst

Confidential

Project Management

Responsibilities:

• Managed workload across a group of assigned clients, assessed risks, prioritized tasks, and delegates assignments, to meet on time and on budget targets
• Conducted performance management conversations with associates to monitor performances in monthly review meetings. Generated Maestro performance reports to track progress of development goals, utilization and work quality
• Coordinated tasks with various shared services teams including Operations Support, Billing Services & Fulfilment Communication teams to deliver a complete solution to the client.

Confidential

Data Analyst/Developer

Responsibilities:

• Served as a primary contact for Confidential clients to provide guidance on e-commerce platform and data management
• Built and execute manual Test Cases, defects were raised in the ClearQuest for logging, tracking and reporting bugs
• Verified and validated regression, negative, integration, functional testing, GxP compliance to produce a bug free product
• Supported Production environments, executed workflow and defect management in ClearQuest to reduce defect counts
• Worked closely with Vendors, Data and Domain Managers to provide solutions to complex client demands using SAS, SQL
• Developed SAS macros for creating tables, graph, data cleaning and reporting and to support routing processing.
• Involved in creating the Object Repositories, Test scripts and executed those and validated reports running batch job
• Modified spread-sheets and utilize VLOOKUP, pivot tables/charts to build visual dashboards to achieve analytical goals
• Built complex Confidential benefit eligibility report & SQL, MySQL queries to test application for data integrity to validate the data
• Optimized existing code for weekly report runs such as Annual, Confidential saving account, and New Hire Enrolment
• Designed and verified Informatica mappings transformations such as expression, joiner, aggregator, lookup, update strategy, and filter for Data warehouse

System Analyst

Responsibilities:

• Built complex benefit eligibility reports to meet business needs using Procedures including Sort, Frequency, and Means. Optimized existing SQL code for weekly reporting runs such as Annual enrolment, Confidential savings, and new hire enrolment
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL, MySQL and PL/SQL language for the top management for decision making
• Carried out data extraction and data manipulation using PROC SQL, PROC MEANS, PROC FREQ, PROC REG, PROC SORT, PROC REPORT to create preferred customer list as per business requirements
• Analysed system functionality using Gap Analysis, Impact Analysis, Risk Analysis, Test Planning and Designing
• Played a lead role in developing Test Cases, loaded them to Quality Center/ALM and executed for various source systems
• Developed complex queries in DB2 to create custom reports to meet client requests and performed internal data verification
• Built a SAS job to automate a manual testing process to verify datasets that were cross-referenced with requirements. Generated weekly defect reports to ensure continued quality control
• Worked on Informatica Power-Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Worked with business resource manager to assign available resources to value-added projects. For example, started a defect reduction team to track recurring system & data issues, performed root case analysis and implemented fixes

Configuration Specialist

Confidential

Responsibilities:

• Analysed results, prepared key presentations and recommendations for Confidential care data
• Designed, recorded, and executed Test Scripts in ClearQuest & utilize macros (VBA) to automate the manual effort
• Used complex Excel formulas to manipulate large datasets, evaluated data to be used for analysis and purge the bad data
• Coordinated with Requirement Analyst on any requirement clarifications when there is any ambiguity in the requirements
• Coached team members on Queries, ClearQuest, Testing tools required to execute, debug, log and report the issues
• Developed PL/SQL Stored Procedures, queries for Back-end testing and SAS procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process and developed procedures using Dynamic SQL
• Analysed business process workflows and assisted in development of ETL procedures for moving data from source to target
• Executed test cases, identified mismatches and logged defects into ClearQuest and tracking them till they are fixed
• Data conversion from flat file to intermediate tables using SQL*Loader and created control files for SQL*Loader