SUMMARY

• A skilled, self - motivated who is involved in all aspects of the Systems Development Life Cycle with Oracle E-Business Suite modules .
• Acquired expertise in design and development using SQL, functions, triggers, and Reports, in Windows environment.
• Detail oriented, capable of working under pressure and meeting deadlines, being a team player giving all for the success of the team. Network Analysis, Mobile GIS and Linear Referencing.
• Co-chaired Data Governance committee to help define a data framework, policies, governance for all data attributes/metrics for the Risk and Capital profile tracing back to their golden source in adherence to BCBS239
• Previous financial sector job experience in data warehouse ETL environment with web services, bulk data extract that used structured models and methods in systems and business process requirement development by working directly with customers, project managers, project team members, enterprise architects, business decision makers, service owners and business process owners. Providing GIS consultation across the enterprise group.
• Experienced with the procedures of Banking & Regulatory Compliances - of Healthcare like HIPAA, EDI Transactions like 832, 833, 835, 836 etc, Customer Identification and Medical insurance Regulatory Reporting
• Knowledge of regulations as a Quality Analyst, Planning Project Manager and Project Coordinator with jobs including but not limited to create document milestones, detailed tasks, time estimates, project dependencies, resource requirements and associated budgets.
• Involved with the Medicaid Information Technology Architecture MITA team to implement maturity level under MITA Framework 3.0 State Self-Assessment SS-A for Medicaid and CHIP Services CMCS .

TECHNICAL SKILLS

Methodologies: SDLC, RUP, UML, CMM, SIX SIGMA, JAD, Agile.

Database: SQL Developer, Teradata, Informatica.

Operating Systems: MS Windows 2003/NT/98/XP, IBM AIX 6.1, AS 400, UNIX, MSDOS.

Programming/Reporting/Change Management Tools/Documentation Tools: Requisite Pro, SAP Business Objects, Crystal Reports XI, Rational Clear Quest, Documentum 2.0, Tableau.

Software/ Testing Tools/Business Modeling Tools: MS Project, GitHub, Selenium.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Business Systems Analyst

Responsibilities:

• Gather requirement for engineering workflow, creating business rules, test script/plan and implementation steps.
• Resolved complex business technology issues by developing, recommending, and implementing innovative solutions to maximize operational efficiency and effectiveness of Site Work Management System, a maintenance support system at the Nuclear power plant.
• Analyze and evaluate system problems, make recommendations, and implement solutions by analyzing and evaluating user/system requirements, and develop tables, queries and report formats to monitor program performance.
• Created new security reports and maintained other security reports within MMIS system
• Prepare documentation of testing activities including test results and discrepancy reports, use statistical and analytical techniques to support quantitative research findings, and proactively find trends in the information and deliver initiatives for business improvements
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases and worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, DB links and privileges.
• Knowledge sharing and expertise for GIS, ESRI, Access, and Oracle.
• Validated the test data in DB2 database on Mainframes using SQL queries.
• Worked heavily on SQL Server database to extract data and build Business reports.
• Claim validation and Pend/Denied Claims Analysis for the Health plans Medicaid programs.
• Created SQL Stored Procedures, Functions, Packages, Triggers, User-defined object types, Records.
• Created scripts to build new tables, views, queries for new enhancement in the application created new workflows for different engineering department of APS and perform system testing of modifications made to the system and coordinate implementation of changes with Technical Support and programming staff.
• Create comprehensive written documentation for project development, and conduct research and evaluation studies with respect to various programs and policies and produce systematic reports on a monthly or quarterly basis to monitor/track program performance, scope change request(SCR) and fraud/cost recovery.
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries.
• Gathered reports requirement and collaborated with the business users using wireframe mockups and developed reporting system for different business accounts, dimensions, management and internal strategy research group by connecting to Tableau Oracle database connector to create customized interface for Tableau workbooks to provide native intranet style navigation.
• Participated in functional design sessions, creates and executes SQL test scripts, and aids in the solution of data issues
• Liaison between business and technical staff to articulate needs, issues and concerns for claims activities (fee schedule, vendor contract, medical/ enrollment/code review) by maintaining policies.
• Gathered and documented business requirements for existing and future healthcare financial management systems that included the areas of budgeting, forecasting, cost accounting, and reimbursement methodologies.
• Organizing and presenting GIS foundations to meet-up groups and novice users.
• Validated the test data in DB2 database on Mainframes using SQL queries.
• Involved integrating Market Prominence and the Medicare Claims Processing System Part D with the data warehouse to support the reporting requirements for its Clinical Systems Portfolio where the duties were design, analyze and translate user needs, observations, and functional requirements into legacy and future products that helped the application model to automate and maintain the ETL process.
• Developed Postgres SQL/SQL scripts and wrote stored procedures to validate the flow of data from Legacy source to target application database and to perform data validation of ETL processes, schema and DDL check, and data flow from data warehouse to application databases, data marts, return marts, referential data, and repositories.
• Conducted weekly meetings for deciding policies and procedures to be followed while constructing new site.

Environment: SQL Developer, Connection Central, Windows 7/32-bit.

Confidential, Tempe, Arizona

System Integrator, Business Systems Analyst

Responsibilities:

• Customize standard Unmapped Subsidiary Accounts reports as per the user requirements for General Ledger Consolidation purposes.
• Worked on solving the behavioral difference issues between 10g and 11g forms debugging the errors. Also developed Custom screens using Forms10g based on Stored Procedures to implement complex business functionality, Tab canvases etc.
• Oracle E-Business Suite modules for Implementation, Upgrade and Production Support.
• Used ArcGIS software to present map-based information.
• Gathered reports requirement and collaborated with the business users using wireframe mockups and developed reporting system for different business accounts, dimensions, management and internal strategy research group by connecting to Tableau Oracle database connector to create customized interface for Tableau workbooks to provide native intranet style navigation.
• Created functional and technical requirements using MS Visio and related software to identify problems, solution(s) and identify test criteria and presented to Business Users by utilizing business process modeling tools for data modeling and mapping.
• Perform audit of End-to-End data architecture/analysis for entire global operations by designing table structures and created primary keys, unique keys, and referential integrity constraints by utilizing business process modeling tools for data modeling and mapping.
• Modification or enhancement related to MMIS (Medicaid Management Information System) security.
• Analysis of source to target transparency and aggregation process, data governance, reconciliation and adjustment process where validation included development of SQL scripts, SQL Server and SAS for GL breakdown to help the reconciliation process.
• Conducted all aspects of assigned GIS projects, generally involving spatial analysis as well as the design, maintenance, and production of geographic data, maps, and applications through an ESRI ArcGIS environment.
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Re-engineer the acquired Broker Dealer Equities Systems and provide business and technical analysis for the migration, conversion and reconciliation of all Broker Dealer Front Office, Mid Office and Back Office system for Source third party application data into OFSAA that is currently consumed by US Fed Regulatory reports application.
• Worked as a part of the Internal Process Support (IPS) team within the Enterprise Information Security (EIS) Cyber Security Defense & Monitoring (CSD&M) team for building exciting new features for the Collibra products to design multi-faceted transformational strategies and deliver cutting edge solutions.
• SCRUM master for business and technical areas to create detailed project plan, Business Requirements Document (BRD), Functional Requirements Document, Technical Requirements Document with Source to Target mapping of all data elements for 3rd normal form, star schema and reporting in SQL Server data stores.
• Member of project team for BCBS Plan implementing new sales software designed to update IT handling of new products.
• Maintained and modified existing GIS databases.
• Develop scenario tests to perform SIT, UAT for ETL operations and implemented credit derivative, Global FX, Wall Street Systems feeds for Finance, Risk and operations systems from a legacy OST environment to create Functional Specifications and Technical Specifications for implementation of new Operational, Finance and Risk reporting gap analysis.
• Create EC2 instance, S3 buckets and gateway parameters for both Windows/ Linux environment as required to upload the Reg report from Lombard platform implemented in production to the Federal Reserve repositories and utilized to update filing processes for Regulatory Reports .

Environment: UNIX, OFSAA, SQL Developer,, Tableau 10.3, GitHub/Selenium.

Confidential

Business Systems Analyst - Data Analyst

Responsibilities:

• Gathered user and business requirements using structured SDLC approach and designed/developed Project document templates, RFP through open-ended discussions, brainstorming sessions and role-playing for state of Texas Education Agency (TEA).
• Created FRD, TRD to develop an Office Supply System using SQL, Forms and Reports to track distribution and invoice stationery and supplies shipped to School across Texas where an interface was developed to link this system by using OLE objects to facilitate the uploading/downloading of spreadsheets/data files between forms/reports and the network drives on users PCs.
• Worked on proper configuration management, change controls and best practices/ guidelines for designing application on Payee Information Portal (PIP) .
• Created necessary documents for a Supplier Data Warehouse to analyze vendor activity and used SQL*Loader to load database tables and developed user interface using Oracle Forms and Reports and created UNIX scripts to execute background processes.
• Gathered data extracts in Tableau by connecting to the view using Tableau Oracle connector and configured data extraction by schedule, every business day at 6 am to enhance performance. Also built dashboards with floating objects and capitalizing the various dashboard actions features like URL, images and web integrations.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams for dimensional modeling with standard analysis techniques such as data flow modeling, workflow analysis, functional decomposition analysis, use cases and user stories to add them with the work package and functional requirements by utilizing industry recommended practices.
• Organized JAD session and created the work package to provide analytical support for program owners by analyzing, extracting key insights from data and presenting the findings to developers, UXP team and testers to proceed further.
• Worked on Selenium to ensure high quality and more frequent releases utilizing various IDE features such as Assert command/Verify command to execute same or different test scripts on multiple platforms and browsers concurrently to achieve distributed test execution which allowed the Dev Ops team, Testing team and IT operations team for testing under different environments and saving execution time remarkably.
• Used Desktop Version of Power BI web query to create dashboard from a web search and analyzes specific domain data set, returning valuable insights using Machine Learning which was helpful to create complex relationships between tables, add columns and rows, import from one table to the other, join, filter and much more.
• Ensured that all Lines of Business specifications including but not limited to milestones, detailed tasks, time estimates, project dependencies, resource requirements and associated budgets etc. were consistent in form and function to the actual needs for different states (Texas, California, Wyoming etc.)

Environment: Informatica, SQL Developer, Tableau 8.1, GitHub/Selenium, Gitlab, JIRA.