Profile Summary Database professional with ten years of IT experience Design and develop the mission-critical, highly available, high volume OLTP databases hosted in SQL Server and Oracle Highly proficient in T-SQL and PL/SQL programming languages for creating optimized stored procedures, functions, triggers, views with complex business logic Expertise in performance tuning and troubleshooting Hands-on experience in designing, building, deploying and supporting data integration with Microsoft BI using SSRS, SSIS, and DTS packages Thorough experience in database normalization and data modeling Experienced working in both Waterfall and Agile – Scrum/ Kanban development methodologies with a solid understanding of software …show more content…
Reduced the response time from over a minute to less than three seconds A few complex batch processes were taking 15 to 20 hours each to complete and impacting the daily schedule. Isolated the components which were running slower and tuned the related database code which reduced the processing time to about five times lesser
Senior Software Developer, Apollo Education Group, Inc. Apr’12 till Mar’17
Responsibilities:
Development of database packages and procedures for various complex business scenarios Working with upstream and downstream applications, write queries and procedures as per their requirements, create test data, and help them understand the business process and the data Part of a cross-trained team with participation in development, review, and testing
Key accomplishments and recognitions: Migrated out of warranty SQL Server 2000/2005 databases into SQL Server 2012 within time frame and budget ensuring compliance and security of company's most critical student data Reduced complexity with multi-system dependency by converting more than 20 DTS packages into SSIS jobs used for aggregating data from heterogeneous systems for analysis and decision-making Re-engineered the program approval process for the University. Simplified the design used by application services and user interface Improved system performance by converting legacy codes into optimized SQL and PL/SQL packages which in turn saved company costs
Experience in Administration for various environments in software development life cycle (SDLC) Windows, Ubuntu, and involved in developing manifests.
Business intelligence (BI) merges architectures, tools, databases, analytical tools, applications, and methodologies. It also is context free like DSS. BI deduces the connections between business entities by evaluating copious volumes of historical data which supports decisions. BI has four major components consisting of a data warehouse, business analytics, business performance management, and a user interface.
Led multiple concurrent customer based projects, including the transition of outdated server migration (Data Centre Transition) to the highly acclaimed WIPRO digital transformation environment that delivers on solution and better customer experience, improving company results and goal through enhancing response time performance and optimizing database (data granularity and retention period).
A time tested and seasoned corporate professional with diverse and varied industry interface. An astute hands- on knowledge domain veteran, besides a time tested solution provider of complex textual, intellectual, and technical subjects and
Successfully migrated OLTP database software development / operations, EDW development / operations and Reporting projects from Waterfall to Scrum within 6-12 months which improved overall product delivery including defect management.
You will discover (or create, if you choose a fictional organization) and explain the main systems in place, discuss the integration, and explain how the data collected by these systems helps the organization make decisions and carry out the strategic plan.
The transition from manual processes to this IT based system is a long drawn and gradual process, which presents numerous challenges in implementing and deploying
As you can see from my resume, my professional history has shown my ability to incorporate knowledge and experience in diverse IT operation environments. That includes the Pharmacy, Manufacturing, and Medical Testing Facility. Within the IT operations environment, you must have strong communication skills, knowing how to multitask, prioritize and have an understanding of the hardware and software used, to perform the daily tasks within the business environment.
Adaptable to a fast-paced environment with the ability to multitask concurrent priorities in an organized manner.
I am filling in as a Software Analyst in "The Planet P, Inc" organization. It is a main worldwide supplier of big business arrangements and programming outsourcing organization. It essentially concentrates on high subjective, inventive and incorporated e-business arrangements, that are convenient conveyed and practical and give specially crafted business answers for worldwide clients.
Carlson Shared Services (CSS) uses a centralized data processing model to meet business operational requirements. The central computing environment includes an IBM mainframe, over 50 networked servers from Hewlett-Packard and Sun Microsystems. In this centralized data processing unit all the servers and the mainframe had their separate disc storage. This dispersed data storage scheme had the advantage of responsiveness; that is, the access time from the server to its data was minimal. However, the data management cost was very high. There had to be backup procedures for the storage on each server, as well as management controls to reconcile data distributed throughout the system. RapidInsight framework enable organizations to integrate real-time, streaming data, to gain real-time actionable insights, integrate and harmonize data from social media sites, public datasets, and industry reports with data from enterprise systems (Fulton, 2015). The RapidInsight framework gives analyst the ability to analyze data in real-time to respond quickly situations in which businesses tend to encounter. A thorough look at the entire business operation, which includes, combining data from external and internal data sets, reduces time to market for implementing real time data to insight. A factory set up is in place to reduce the time and cost involved with
Completed a Gartner maturity assessment, implemented new service desk and IT Ops. control functions, standardized service level management & transition processes, bringing IT operations under more control.
Design, code and deliver user friendly multi-tier business intelligence solutions that utilize data warehouse/data mining technologies to consume data across various database platforms and data stores.
Driven by accelerated productivity gains and ever-increasing performance, “state of the art” data integration platforms, such as Informatica® PowerCenter®, handle the vast majority of today’s scenarios quite effectively. PowerCenter has enjoyed wide acceptance and use by high-volume customers representing companies and government organizations of all sizes. Based on this use, Informatica has identified performance scenarios where processing data in a source or target database—instead of within the data integration server—can lead to significant performance gains. These scenarios are primarily where data is “co-located” within a common database instance, such as when staging and production reside in a single Oracle relational database management system (RDBMS) or where a large investment has been made in database hardware and software that can provide additional processing power. With these scenarios in mind, Informatica Corporation set out to deliver a solution that delivers the best of both worlds without incurring undo configuration and management burden; a solution that best leverages the performance capabilities of its data integration server and/or the processing power of a relational database interchangeably to
Involved in all the phases of Software Development Life Cycle (SDLC) including Requirements Gathering, Analysis, Design, Development, Testing, Production and Post-Production Support