Professional Summary
SKILLS O Rational, critical-thinking Application Programmer with 8 years of experience enhancing operations for organizations through information systems solutions. Proven track record of transforming specific business goals related to growth and efficiency improvements into new system designs. Enthusiastic Reporting Developer eager to contribute to team success through hard work, attention to detail and excellent organizational skills. Clear understanding of Business Intelligence and Web Reporting and training in Data Science. Motivated to learn, grow and excel in Data Analytics. Knowledgeable innovator known for recommending new technologies to enhance existing systems and introduce new systems. Extensive experience in the field of Data analysis, ETL Development, Data Modeling, and Project Management with experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management. Strong understanding of multiple programming languages, systems, as well as data design and project management methodologies. Actively participated in functional, technical, user acceptance testing efforts and resolve identified defects and contribute to the maintenance of reporting best practices and standards. Design/build/deploy reports that address business requirements using WebFOCUS capabilities including reporting Dialogue Manger, App Studio and Info Assist+. Demonstrated experience with WebFOCUS advanced reporting/output capabilities and Ability to develop technical requirements from business requirements for reporting. Ability to customize WebFOCUS Portals with the knowledge of Data Warehouse concepts and tools along with understanding and implementation of HTML, CSS and JavaScript. Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using WebFOCUS. Business modeling: Microsoft Visio, Microsoft Office BI tools: WebFOCUS, Cognos 8, Business Objects, Microsoft SQL Server Reporting Services, Tableau, Report Caster ETL tools: Informatica, Microsoft SQL Server Integrated Services Programming Languages: FOCUS, SQL, HTML, Data analysis ETL development Statistical analysis Data Visualization Reporting efficiency and accuracy Data science Query writing SQL analysis WORK HISTORY O SR. PROGRAMMER ANALYST/ REPORTING ANALYST Jpmorgan Chase & Co. | Garden Grove, CA 11/2016 to CURRENT Involved in maintenance (including production support), enhancement and development work Responsible for analysis, design, coding, component and assembly testing of all Municipal WebFOCUS reports Worked directly under Chief ACS/ATS Municipal court division to develop AdHoc Reports, Reporting Objects and BI Dashboard Applications using WebFOCUS DevStudio 7.6.5, Dialoge Manager Coding, MRE, InfoAssist, and Report Caster - Delivering management reports from analysis to implementation on assorted platforms including large IBM mainframes - Working with business analysts and business users to deliver requirements Develop detailed design, coding, unit and system testing and documentation of new or enhanced IBI- WebFOCUS applications/queries Responsible for troubleshooting and resolving production problems Working with WebFOCUS tools to analyze data in DB2 database and system is securely accessed via Web browser Working on WebFOCUS reports using SQL Pass-thru, Advanced CSS Style Sheet function to format reports in Active HTML, EXL2K, Standard PDF, Compound PDF and Drilldown reports Working on rewriting major programs of SQL Queries into WebFOCUS to retrieve data for modification of management reports Implemented Slowly Changing dimension methodology for accessing full history of accounts and transaction information Involved in performance tuning of reports and unit testing and documenting processes Designed ETL specification documents to load data in target using various transformations according to business requirements Involved in various knowledge transfers from dependent teams understand business activities and application programs and document understandings for internal team referencing Resolving technical issues by managing bug fixes, managing change requests and delivering it on time Coordinated monthly meetings to discuss resolutions for exception reporting Prepared documentation for business analysts and updated client data Reviewed and analyzed systems functions and reporting processes for accuracy Maintained ongoing schedule and documentation for all reporting procedures Supported efficiency and data integrity by monitoring control documentation of reporting procedures Produced quality reports formatted in compliance with data quality standards Utilized in-depth analysis and creative problem solving to troubleshoot reporting issues PROGRAMMER /SENIOR DATA ANALYST 09/2014 to 10/2016 Humana | City, STATE - Conduct independent data analysis, gap analysis, write mid-level SQL queries and interpretation and generating reports as per specifications; Experienced in MS SQL Server suite of products like SSIS and skilled in sorting data, defining subtotals for reports Having application testing experience with working knowledge of automatic testing tools like Mercury Quick test Professional and Load Runner Design and develop Business Objects, Web Focus Reports, Share Point, PEGA, JAVA, J2EE, data analytics projects and re-engineering efforts Involvement in all phases of development process, including development of database systems and reports using MySQL, WebFOCUS and DB2; Seek operational objectives by contributing information and recommendations to strategic plans and reviews; preparing and completing action plans; implementing production, Evaluate tools and coordinating efforts between project teams and IT groups to define, validate and implement software for data management and analysis Automated SSIS packages into File Ingestion tool and maintained mappings and data feeds 3 different environments Development, QA and Production - Helped on various different issues to merge data from various excels using SSIS based on requirements Documented data quality and traceability documents for each source interface. Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions Gathering requirements, and then designing and developing programs in WebFOCUS tools in improving applications and reports Develop new programs and modify existing programs according to specifications and department standards End to end experience in designing and deploying data visualizations using Tableau. Self-learning ability, Leadership skills, determination to learn new technologies and maintain positive relationships at all business levels Perform end-to-end implementation of projects, starting from requirement gathering to design and development of software, and then performing unit testing, code migration to quality assurance, and ultimately to production; Aiding team to help resolve critical technical and system issues in timely and efficient manner that support implementation of wide information system in collaboration with functional users; and Preparing design and conceptual Approach document for projects, which are subsequently shared with entire team Strengthened developmental methodologies by introducing SQL code quality document Authored code fixes and enhancements for inclusion in future code releases and patches Performed regression and system-level testing to verify software quality and function prior to release Debugged and modified SQL Server SSIS software components - Coordinated statistical data analysis, design, and information flow Corrected any data entry error to prevent later issues such as duplication or data degradation 03/2012 to 08/2014 ETO DEVELOPER - Build Oracle database systems of high availability and quality depending on each end user's specialized role Worked with internal architects and, assisting in the development of current and target state data architectures Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines Involved in defining the source to target data mappings, business rules, business and data definitions. Responsible for defining the key identifiers for each mapping/interface Responsible for defining the functional requirement documents for each source to target interface Document, clarify, and communicate requests for change requests with the requester and coordinate with the development and testing team Involved in configuration management in the process of creating and maintaining an up-to-date record of all the components of the development efforts in coding and designing schema's Developed the financing reporting requirements by analyzing the existing business objects reports Interact with computer systems end-users and project business sponsors to determine, document, and obtain sign-off on business requirements Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality Remain knowledgeable in all areas of business operations to identify systems needs and requirements Designed and created ETL code installations, aiding in transitions from one data warehouse to another Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations Wrote and optimized in-application SQL statements Trained in coding for numerous Data Warehousing solutions, including Oracle and Teradata Managed data quality issues during ETL processes, directing qualitative failures to Testing Team for amelioration Collaborated with Tableau Development to determine and detail overall goals and requirements