SUMMARY

• Experienced Data Integration/Project Management Analyst focused on Architecting & Developing Data/Analytic Solutions, Solution implementation, Vendor management and providing ongoing support of the applications. Managed all aspects of software project delivery from medium to large statewide implementations. Possess strong Technical, Analytical and Database foundation.
• Have an exceptional record of delivering high performance technology solutions incorporating wide array of technologies and on various domains to meet challenging business demands. Expert in all facets of information systems methodology from conceptual design through documentation, implementation, user training, quality review, and enhancements.
• Strategic Thinker with the ability to identify opportunities for process improvement and to facilitate change, identify solutions, opportunities and drive results.

TECHNICAL SKILLS

Programming Languages: C, Pro*C, C++, Visual Basic, CICS, HTML, JAVA, Struts, JSP, WebSphere, Pl/SQL and COBOL, SQL, PL/SQL, SQL*Plus, Web service Integrations, SOAP,REST,JSON

Databases: Oracle Exadata, Oracle9i, Aster database, SQL, PL/SQL, SQL*Plus, IBM DB2 8.0, MS SQL Server, SSIS, MS Access

Methodologies: Waterfall Methodology, OOAD, UML, Rational Unified Process (RUP),AGILE Methodology & SCRUM Framework

Tools: MS Visio, MS Project, Rational Rose, Rational Suite of Tools, Erwin, Rational Test Suite, SQL*Plus, SQL Loader, Jira, Remedy, Share Point, Stored Procedures, Shell scripting, GCC make utilities, VSAM, JCL, Expeditor, File Aid, Group wise, Outlook, MS Project, Tableau, SAS Enterprise Guide, SAS Business Intelligence Tools, SAS Macros, SAS Visual Analytics, SAS Web Report Studio, Base SAS, SAS 9.3, SAS 9.4, Power Bi, Tableau

PROFESSIONAL EXPERIENCE

Confidential

ATM Team Lead

Responsibilities:

• Understand all organization’s products, services, procedures and guidelines and communicate same to all team members and ensure that all processes are executed appropriately and in a timely manner.
• Developed the Technical Design & Business Requirements and other artifacts for all the Strategic Projects like EMV Enablement, ATM Upgrade Projects & Regular Enhancements to the application.
• Operated as the subject matter expert and provide functional direction in the all areas for Development, Enhancements & Issue resolution
• As a Scrum Master responsible for leading the Agile Development & Test teams, Sprint Planning, Conduct Retrospectives.
• Assist in the work load management and prioritization of day to day duties to team members and provide direction and guidance on issues.
• Ensure daily workload and commitments have been completed timely and accurately within established guidelines
• Actively participate in the resolution of day to day issues that arise, including production incidents, address third parties, internal teams and our internal systems as needed
• Worked with ATM team members and management, review and evaluate current processes and procedures to ensure appropriate alignment to the respective groups for ownership.
• Optimized the contribution of the team through coaching and mentoring
• Developed BI Dashboards to monitor the Production Activity and thought leadership for building various alerts to monitor the ATM performance. Substantially increased the ATM performance rates irrespective of challenges.
• Assist fraud team by providing real time transaction data and mitigate fraud activity at the ATMs.
• Defined standards and reusable approaches within the Production Support & Release Management operations
• Responsible for leadership sign - off for Release Management of all the ATM Deployments in Production, SIT & UAT
• Ensure the compliance and regulatory needs are met. Accountable for meeting Reg E, Reg D compliance and establishing procedures to address the customer complaints.
• Developed strong relationships with peers and our internal partners.

Confidential

Lead Data Integration Analyst /Project Manager

Responsibilities:

• Managed all the Data integration efforts by evaluating the data, analyzing the data, develop the business rules, develop clustering logic, design and architect the data solutions and co-ordinate the development of the application.
• Interact with various business owners to understand the requirements and develop business requirements and reporting needs.
• Act as a Technical Advisor/ Subject Matter Expert ( SME) for most of the GDAC Analytical Solutions.
• Provide strategies related to data cleansing, data quality and data consolidation. Handled huge databases and proficient in writing efficient queries. Managed the entire database for all portfolios including data extraction, conversion, cleaning and merging.
• Designed Developed the clustering logic for integration Department of Health and Human Services (NC DHHS) data for Child Welfare Assist (CWS) program.
• Successfully managed multiple work streams simultaneously and work in fast paced environment handling multiple releases. Provide estimates for work efforts on new tasks assigned and for on-going forecasting to the Project Director.
• Strong in Data Analysis, Data Profiling, Data Migration, Data Mining, Data Integration and Metadata Management Services
• Reliably executed and developed various internal data reports utilized by leadership to perform reporting to legislators, investigative reports for end-users and provide metrics, dashboard reports for system statistics and usage and forecast trends. Designed 80% of the Reporting Solutions/ Business Intelligence Reports for the Application
• Expertise with Data modelling concepts, such as Data Vault, OLAP cubes, Star Schemas, etc.
• Developed audit reports resulting in cost savings to the organization, cross training new teams, mentoring the team members, and recommended process improvements across the projects.
• Prepared various statistical and analytical reports using SAS/Macros SAS/Base, SAS/SQL, SAS EG, SAS Visual Analytics and MS Excel. Extensive use of PROC SQL to perform queries and join tables.
• Knowledge of AI type concepts, machine learning concepts, data mining and clustering algorithms.
• Solely responsible for integration of the data using Web services. Good Knowledge on XML and WSDLS, SOAP UI, REST & JSON and web service integration. Integrated the NC DMV, NC Wildlife and NC Warrants information from the court system using web-services.
• Develop and document the requirements for web-service integration, source to target XML- mappings, XSD, XML- Schemas and identify the various request and response types based on the business cases.
• Developed requirements for CJLEADS Mobile app. Designed the prototypes using HTML5.
• Worked on Agile Methodology and developed user stories, sprint planning, daily stand ups and retro meetings.
• Mentored team Members on Subject Matter Knowledge and data strategies and bring them to speed. Transfer knowledge & Mentor Business Operations team with new functionality after every Release and also any new enhancements to the existing application.
• Suggested various process improvements and streamlined deliverables for resolution of Customer Service Tickets and fixing the data at the source systems.
• Sign off on Peer Reviews, UAT & Requirements with Internal & External Teams.

Consultant

Lead Business Analyst

Responsibilities:

• Saved the project from crisis to successful implementation. Constant Change and conflict in requirements led to scope creep. Established change management process to control and clearly define requirements resulting in successful implementation of the project. Responsible for establishing the Change Management Process across the organization.
• Facilitated stakeholder elicitation workshops to develop High Level business requirements. Developed crucial functional requirement specifications, creating detailed use cases and process flow diagrams to support functional specifications.
• Worked closely with design architects and operations teams to obtain requirement sign-off.
• Created various artefacts like Use case Templates, Business rules, Supplementary Requirements, Performance Requirements Documents and various other technical documents.
• Recommended and Implemented Rational Tools for managing requirements into a centralized database and effectively implemented Requisite pro repository and developed Requirement Templates as per the business needs. Overall this approach reduced the time and efforts on both the analysts and the development side and helped management review and approve requirements on time.
• Implemented new processes and streamline deliverables for different projects across the organization.
• Automated the Test Management using Rational Test Manager and Defect Management using Clear Quest.
• Administered, Configured, Implementation and Maintenance of Rational Tools like Requisite Pro, Clear Quest, and Test Manager for the whole project. Administered the Rational Server and License Servers and also manage and allocate licenses for different teams. Designed the Reqpro Traceability Model, Clear Quest Schemas and Organization of testing artefacts in Test Manager.

Confidential

Business Systems Analyst

Responsibilities:

• Prepared a Request for proposal (RFP), business requirements, functional requirements and high level design requirements of the web application.
• Interacted with various users like Health departments, Hospitals, Local registrars, county clerks, funeral directors, coroners and Confidential internal users to collect the information about their business process.
• Developed various surveys for different stakeholders to the project and facilitated JAD sessions.
• Facilitated meetings and conducted interviews with stakeholders to the project.
• Develop Business Process Requirements with UML, RUP and Use Case Analysis.
• Assisted in developing standards and procedures and made recommendations to enhance the existing software systems and baseline the project documentation and adherence to HIPAA security standards, EDI Standards and HL7 Formats.
• Developed Test plans and Test cases and recommended automated testing tools.
• Responsible for Evaluation of the Vendor Demonstrations.
• Analysed of the existing Mainframe systems and database and evaluation of alternatives. Perform GAP analysis on many of their systems.