SUMMARY:

• Accomplished, solutions - oriented, and hands-on IT professional, with 25+ years of extensive and hands on experience in all facets of Business Intelligence applications and product development life cycle.
• Extensive experience in managing applications development and implementing Business intelligence solutions.
• Extensive experience in overseeing complex IT projects;
• Design, Development, and Implementation of Software Solutions .
• Business Intelligence Applications, Dashboards, Scorecards.
• Administration and Support of Multiple Business Applications.
• Continuous Process Improvement.
• Extensive Experience in GUI Design involving Front End Applications.
• Design, Implementation, and Management of Web Applications and Web Services.
• Risk Assessment and Mitigation.
• Ccontingency Planning and Execution.
• Proficient in Waterfall and Agile project management methodologies.
• Strong technical and management abilities.
• Skilled at managing all aspects of software development, requirements gathering, architecting solutions, managing development, testing, delivery, and applications enhancements, with proficiency in building and managing high performance teams and actively involved in strategic software projects.
• Adept at building relationship with stakeholders and collaborating with business partners and all levels of professionals to support project requirements and deliverables.
• Expertise in delivering solutions to complex business problems, process improvement solutions on-time within budget.
• Experience in managing both onsite and off shore projects and resources.

TECHNICAL EXPERTISE:

• Cognos Tools 10.2.2v
• Data Warehousing: ETL and Warehouse Schema Design
• Oracle Pl/SQL
• Performance Tuning
• Oracle Database 12c (Exacloud)
• Database Partitioning
• Application DBA
• UNIX Shell Scripts
• Windows & DOS
• SQL and Performance Tuning

PROFESSIONAL EXPERIENCE:

Confidential, Lyndhurst, NJ

Engineer Lead ( Application Manager - Technical )

Responsibilities:

• Responsible for managing applications and Business Intelligence solutions. Managed a small development team supporting approximately 100+ users. Used conflict management skills effectively to resolve issues between Users, Management, and teams. Project Manager responsibilities included sprint planning, conduct daily scrum meetings, change control, communications, process improvements, and release management.
• Lead and implemented a reporting infrastructure platform to provide a reliable, consistent means to securely access clinical data for adhoc/offline analysis to facilitate decision making.
• Managed Cognos based business intelligence projects focused on upgrading existing platform and providing users ability to pull data and view data via scorecards or dashboards.
• Designed, developed, and helped maintained complex ETL processes to consume data from 40 different data sources in 5 different input formats.
• Enabled availability of the data warehouse for 24x7 access to all users and provided innovative solutions to eliminate downtime during ETL data refresh process.
• Document and maintain Architecture roadmap.
• Oversee and manage projects from planning, engineering design to implementation. Including infrastructure projects and software upgrades.
• Handle interview of prospective new hires; provide guidance to new hires and junior colleagues; and generate feedback to the management.
• Build and maintain strong relationships with stakeholders and business partners.
• Capitalized on technical expertise to deliver complex business applications, which included the following:
• Development of Business Intelligence applications (Scorecards and Dashboards)
• Enhancement of patient clinical history data warehouse
• Optimization of ETL process
• Structured more than 1000 data extracts and feeds to internal and external customers

Senior Analyst / Developer

Confidential

Responsibilities:

• Designed and developed the following:
• Wrote complex ETL jobs using IBM datastage to extract data from multiple source system.
• Reporting solutions, dashboards using IBM Cognos.
• Design and development of real time data consumption ETL jobs delivered via IBM MQ-Series using data stage, Oracle and Java.
• Designed and created a dashboard to monitor data warehouse processes using Cognos which helped in monitoring the ETL processes and data quality, thus reducing the manual monitoring and time spent by support staff.
• Formulated and implemented several notifications to raise alarms and alert on call resources for prompt action and remediation. The above mentioned monitoring dashboard increased the support team’s productivity and helped in proactively resolving issues, thus ensuring the delivery of data on time and without error.
• Conducted routine and non-routine systems analysis based on project development life cycle process, while executing documentation, programming, testing, maintenance, and other IT-related tasks.
• Performed interview with business sponsors and compiled information gathered from business community to evaluate requirements.
• Performed unit testing, integration testing, peer reviews, and implementation of new software modules, while communicating new guidelines to the Support Department.
• Worked closely with Multiple Departments and teams to identify and resolve application issues for internal and external users.
• Prepared monitoring reports on application usage and security to the immediate upper management and internal auditors.

Senior Programmer Analyst

Confidential

Responsibilities:

• Developed complex stored procedures and wrote high performing SQL queries.
• Created several Cognos reports to match business requirements.
• Formulated technical design document based on the project business requirements.
• Generated unit test cases and performed extensive and rigorous testing to produce an error-free software.
• Worked with Oracle PL/SQL, SQL, data stage, Perl, Cognos, and UNIX scripting.
• Performed Cognos administration related work.
• Initiated unit and integration testing secure user acceptance.
• Expertly handled the successful development and implementation of new applications enhancement in accordance with sponsor’ s requirements.

Confidential, Parsippany, NJ

Lead Application Developer

Responsibilities:

• Built customer and sponsor centric, queue-based claims billing system which engaged IT staff to grow business.
• Served as SME in Claims, reserving and billing modules in the Homegrown claims Management system.
• Developed and implemented several process enhancements to increase the capability of the systems.
• Ensured compliance with the project deployment methodology to deliver error free software.
• Designed and developed process to ensure that the data in data warehouse was in sync with the source systems every day.
• Improved ETL process from source system by capturing the changes within the source data in audit table specifically created to store changes which eliminated the process to wait for files. The audit table were scanned for populating data warehouses.
• Conceptualized designed and deployed new process and software modules to assist internal users in processing claims that decreased time, resource requirement, and paperwork; thus generating significant cost savings to the company.
• Made major contribution to the successful transformation of poorly performing, high maintenance, and high cost carrier interface application and contributed in significant cost savings to the company.