• Analyse issue or requirements ensuring sufficient level of accuracy and detail are provided in order to create a solution design, complete development, test cases and release.• Where applicable create system documentation and/or wiki pages to ensure appropriate knowledge sharing and retention• Provide time and effort estimates to assist with change prioritisation and tracking• Analyse user stores and create clear, well defined TFS tasks, issues and bugs• Research, analyse and evaluate development activity and strategies to ensure effective implementation and best practice• Analyse existing processes and codebase and provide recommendations for improvements/efficiencies• Uses database management system software and tools to investigate problems and collect performance statistics and create reports• Develops specialist knowledge of database concepts, object and data modelling techniques and design principles• Review and manage service provider in relation to operational activities for database set-up and administration• Attend meetings, workshops and daily stand ups• Actively participate with design discussions with team members in order to achieve the best outcome based on the requirements/issues, time and cost constraints• Adherence to regulatory compliance requirements such as Anti money laundering and privacy laws

Supported and fine tuned the Data Warehouse and Tableau Environments as well as maintain the SQL Servers and SQL Reporting at CPA.• Worked with CPA business stakeholders such as the Client Services, Fundraising, HR and Payroll, Training and Finance teams to understand the business requirements.• Documented the business processes, mappings and analysis of all systems at CPA• Designed and implemented a star schema Data Warehouse in SQL Server 2016 based on the existing data warehouse• Involved in designing, developing and testing of the ETL strategy to populate the data to the data warehouse from various source systems such as Salesforce, Finance and HR system using SSIS.• Created KPI dashboards using Tableau for Executive Managers, Senior Business Managers and Managers such as Staff Activity, Client Numbers, Client sessions, Response times, NDIS and Non NDIS plans.• Engaged in Tableau Administrative activities like user management, server upgrades and backups, publishing and scheduling Tableau data sources, and workbooks. • Trained end users across the departments on how to use created Tableau workbooks and interact with Tableau Server.• Consulted with Tableau developers weekly on best practices and problem solving• Inventorized and worked with stakeholders to look at the Management Reports within CPA to determine current and future needs and any rationalization required• Developed different type of SQL reports including: Client Services Report, Marketing Reports, KPI Reports and Ad Hoc reports by using SSRS and SQL Server 2016.• Developed Store procedures, Functions, Views, T-SQL scripting for complex business logic and Tableau Data Sources. • Scheduled and monitored all maintenance activities of SQL Server 2005/2008/2016 to meet business requirements activities including database consistency check, data backup & restore strategy, index defragmentation.

The project was to work between the business and IT to implement and integrate new systems, in and out of a new central reservation system that Thrifty has just implemented.• Engaged with business stakeholders such as the Sales, Marketing, Human Resources, Revenue Management and Finance teams and the BI team to understand the business requirements.• Gathered and documented requirements from business stakeholders by facilitating requirement elicitation workshops, undertaking business process mapping and analysis.• Translated business requirements into technical/functional specifications related to the proposed solution.• Strong experience developing, deploying and supporting Tableau dashboards for teams such as Sales, Human Resources, Revenue Management, Finance and Franchisees.• Engaged in Tableau Administrative activities like user management, server upgrades, publishing and scheduling Tableau data sources, and workbooks. • Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).• Developed different type of reports including: Franchisee Operational Reports, Sales Reports, Incentives Reports, Blue-chip Report, Deposit Reconciliation report, KPI Reports and Ad Hoc reports by using SSRS and SQL Server 2008/2012 and Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.• Developed Store procedures, User defined functions, T-SQL scripting for complex business logic. Optimized the performance of Stored procedures by creating various clustered, non-clustered indexes, temporary tables and fine tuning queries. • Used Team Foundation Server (TFS) for version management for all projects.• Applied Agile Methodology for all BI Development and Reporting.

Client was an Investment and Risk management solutions firm (headquarters in New York City, USA) where our team supported their Trade Risk management team in providing pension plan solutions.• Lead a 5-member team to build an ETL process using Pentaho Data Integration (PDI) to incorporate the Dodd frank law changes to the current Over the Counter margin stock (OTC Margin) process. This process resulted in saving a high cost to the client by doing it using excel. • Migrated all legacy ETL jobs, reports and data from Pentaho Data Integration/Oracle to SSIS, SSRS and SQL Server 2008 to make the data handling and report generation process robust. This resulted in making the process more efficient and user friendly for the end user. • Analysed, designed, developed, installed, configured and deployed OTC Margin process with Business Intelligence in SQL Server Reporting Services 2008/2012 (SSRS), and SQL Server Integration Services (SSIS).• Developed SQL queries, stored procedures, triggers, and functions in Oracle/SQL Server PL/SQL • Lead a 3-member team to clean up, fine tune, and data mapping 1 million records using ETL technology. • Built Excel VBA macros as a UI to execute stored procedures and load cleaned 1 million records in batches. • Developed, maintained and distributed ad hoc reports, to respond to immediate client request. • Coordinated and monitored the project progress to ensure the timely flow and complete delivery of the project and provided the project estimates for development team efforts to the client• Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, Data Flow and Process diagrams using MS Visio tools. • Supported a buy-side client and responsibilities include developing and delivering software solutions in line with required specifications within a given time frame.

Reservation Gateway also known as Rezgateway is the worldwide leader in software for the travel industry. Rezgateway’s concept is to provide a one vendor solution to Airlines, Tour Operators, Travel Inventory Distributors, Receptors, event Planners and Destination Management companies. By using Rezgateway's range of services, customers can easily create, manage, integrate and distribute travel inventory using Internet technologies.• Provided Maintenance for Airline and Hotel reservation system (Rezbase_v6). • Fixed issues for hotel inventory and reservation system (Bonotel). • Generated a data parsing process from a Data Transaction Record file to the database. • Used CVS for version management for all projects. • Actively involved in Agile Methodology such as SCRUM on a daily basis

The ETI Financed Limited venturing in to the business of acceptance of fixed deposits. Being a member of EAP Group of companies with a solid history spanning 35 years in the financial sector. The company extended its service in the business of Leasing & Hire Purchase, Real Estate, Housing & Trade Finance and Personal loan.• Developed and maintained the standalone Fixed Deposit system using java swing. • Designed and developed Flash/Flex RIA applications with data binding, remoting and created Flex and Action Script custom components and CSS-styled stock components.• Responsible for the development of the modules by utilizing Java and Report generation and implementing the database connectivity using JDBC/JNDI with EnterpriseDB and Oracle database.• Created annual, monthly and daily fixed deposit Reports using Jasper iReport 3.7.6/3.4.1.• Interacted and communicated among the application development team to define the scope and effort estimates, establish actionable tasks and projects, set priorities, and plan regular releases.

The Board of Education serves as the primary advocate for a quality education for all children and youth in the state. The board seeks to promote excellence in the education of all students and is responsible for policies that promote educational quality throughout the state. In this capacity, the board defines the fundamental mission of the state’s educational system and develops the system’s long-range goals. In order to meet these goals, the board enacts appropriate regulations, supports local implementation efforts, and regularly measures the performance of the system.• Involved in the phases of Software Development Life Cycle (SDLC) including Requirements Collection, Analysis of the Customer Specifications, Development and Customization of the Application.• Implemented Model View Control (MVC) architecture using Struts Framework to develop Action classes, Action Servlets classes, Form Beans, Request/Response JSP pages. • Developed client side and server side validations using Javascripts and Struts Validation Framework and Created JSP Custom Tag Libraries for the presentation layer/front-end.• Developed and Implemented AJAX to create interactive web applications or Rich Internet Applications (RIA) for improved the web page load speed.• Implemented Design Patterns like Data Access Objects (DAO) and Singleton Pattern.• Involved in Designing and Developing over 45 reports in PDF, Excel, CSV and Html Reports, Charts and Diagrams using JFree Reporting tool and Oracle Report Builder.• Responsible for writing JDBC programming to persist the data and developed SQL queries, stored procedures, triggers, packages, and functions in Oracle PL/SQL• Log activity for request / response / error recording was performed with Log4j. • Used CVS for version management for all projects.

Documents are a part of any industry, and the management of documents is a challenge faced by all industries. Document creation, retrievals, approvals, tracking and version controls are the primary challenges faced. The need of the hour of every organization irrespective of industry is to find a way to share documents, files and other content within the organization and with remote workers and business partners in a secured and organized manner. • Involved in Development and Customization of the Document Workflow Application.• Developed Struts Action classes, Action Servlets classes, Form Beans, Request/Response JSP pages and used JavaScript for client side validation, Struts validations for server side, design patterns like DAO.• Responsible for writing JDBC programming to persist the data in Oracle database.• Created JSPs, Servlets, XML and JSP Custom Tag Libraries for the presentation layer/front-end.• Created stored procedures, functions in Oracle PL/SQL, and transact-SQL