Description
Around 4 years of extensive experience in Design, Development and Maintenance in Healthcare, Retail, Financial and other Software companies on Oracle Databases, SQL Server, MySQL and Reports. Good knowledge over the entire Software Development Life Cycle (SDLC) that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment. * Experience with multiple RDBMS including Oracle 12c/11g/10g, Microsoft SQL Server 2008, MySQL and associated SQL Dialects such as PL/SQL, Transact SQL (T-SQL), MySQL. Proficient in creating Tables, Views, Packages, Procedures, Functions, Exception handling Views, Triggers and various other Database Objects. Proficient in Analyzing data sources and creating interface documents and proficient in Dimensional and Relational Database Management Systems. * Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques Query relevant data from databases, such as Oracle, Microsoft SQL server, using complex Structured Query Language (SQL), manipulate large unstructured and structured datasets to build insightful solutions to complex problems, and present the results in visually engaging and intuitive reports and dashboards. Collect, maintain, manage, interpret and analyze data received from internal and external data sources * Hands on experience in interacting with Business User and Business systems analysts to understand the requirements and documenting the Functional Requirement Document and Technical requirement documents. * Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting. * Strong Knowledge in ETL processing of Designing Workflows, applying Transformations in Informatica Power center tool and Data Services tool. Knowledge of statistics and experience using statistical packages for analyzing large datasets (Excel, SPSS, SAS etc) Hands on experience on Resolving helpdesk database tickets and production support Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks), object oriented programming using C++, JAVA, Pro*C Strong Trouble-shooting, Problem solving, Analytical & Design Skills and ability to quickly master new software and adapt to changing needs Excellent communication, interpersonal and versatile team player with problem solving skills. * *