Profile

• Commendable skills in various information systems like transaction processing systems, decision support systems and database management systems.
• Strong knowledge in SDLC life-cycle phases including application development and maintenance processes.
• Experience in Identity Access Managment, Financial, Insurance and Manufacturing Services business domains.
• Experienced in working with different development methodologies like Waterfall, Prototype model, Iterative, Agile Scrum .
• Experience in development and maintenance of Oracle and PL/SQL programming.
• Expertise in the development, implementation and maintenance of SQL Server 2000/2005/2008/2012 including the MS SQL Server suite of products like SSIS, SSRS and SSAS.
• Highly proficient in all aspects of database implementation including development, normalization, de-normalization and performance tuning.
• Expert in T-SQL and PL/SQL Programming skills.
• Expert in Data Analysis, Data Migration and Integration of disparate systems
• Experience implementing and managing Data warehouse and Data mart applications and reporting tools SAP Business Objects XI and Web Intelligence.
• Experience in various facets of ETL: Requirement Elicitation, Data Modeling, ETL Design, Implementation and Reporting Solutions.
• Experience in managing applications hosted in Unix/Linux platforms with shell programming.
• Experience in database applications in Stored Procedures, Functions, Triggers and developing other DB objects in MS SQL Server, Oracle, My SQL and IBM DB2.
• Experience in performing ETL / DTS operations into OLTP and OLAP databases from heterogeneous databases using SSIS, BCP and SQLCMD utility.
• Hands on experience in performing various SSIS data transformation tasks like Script Task Component, Look-ups, Fuzzy Look-ups, Slowly Changing Dimension, Merge Join, Conditional Splits and Error Handlers.
• Experience in create, deploy and manage reports in SSRS and Business Objects XI 4.1.
• Experience in designing cubes with dimension and fact tables using star or snowflake schema in OLAP warehouse using SSAS.
• Knowledge on Big Data eco-system like HDFS, MapReducev2, Pig, Hive and HBase. Having good knowledge in Object-oriented programming and its concepts.
• Knowledge in configuration management and change request tracking tools from Rational Suites.
• Knowledge in application build and deployment tools like Ant, Build Farm, RepliWeb, etc.
• Experience in developing and managing Web and Windows platform applications of Microsoft technologies like VB.Net, C , ASP.Net, VB 6.0, VBA, Classic ASP and COM components and COTS products.
• Expertise in team handling, direct client interaction and offshore onsite team coordination.
• Experience in Web development using Java, HTML, CSS and Testing tools.

Technical Skills

• Systems worked on : OLTP, OLAP, Data warehouse systems, CRM and COTS
• Databases worked on : Microsoft SQL Server, Oracle, DB2, PostgreSQL and MySQL
• Business Intelligence : SSIS, SSRS, SSAS, SAP Business Objects 4,1,XI, Web
• Intelligence, Informatica, Redwood and Self-Service BI.
• Operating Systems : Microsoft Windows, Unix, Linux platforms, Shell programming
• Programming Languages : T-SQL, PL/SQL, VB.NET, C , ASP.NET, VB and Core Java
• Web Technologies : HTML, XML, CSS, JavaScript, VBScript, AJAX, Web Service
• and jQuery
• Web Servers : Microsoft IIS, Oracle Web Logic, Apache Tomcat
• Office Suites : MS Office, MS Project and MS Visio
• Other IDE/Tools : BIDS, SSDT, Toad for Oracle, WinSQL for DB2, Visual Studio,
• Selenium, Rational Suite Tools, Build Farm, Ant and RepliWeb.

Professional Experience

Confidential

Role : SeniorSoftware Engineer

Environment : Oracle, MS SQL Server, Oracle BI, APEX, Discoverer Reports, XML, JavaScript,

Responsibility:

• Developed high-level and detail-level specification document for the functional requirement
• Defined coding standards, created templates for database objects development
• Developed stored procedures, functions and triggers to meet the functionality
• Performed database administration and migration activities
• Responsible for Sign-Off on the BI Reports after release
• Analyzed and review programs scripts to increase efficiency and adapt new requirements.
• Evaluated user requirements to determine goals and objectives.
• Responsible for requirements gathering and client coordination
• Created ad-hoc reports using oracle discoverer oracle Application express
• Worked on Data Warehouse tools like Oracle Warehouse Builder
• Designed flow charts and diagrams about system architecture
• Monitored data load jobs using JD Edwards tool
• Worked on changes in the existing programs, test cases and requirement analysis
• Created Use Selenium IDE, RC, Grid Programs, Test Cases for the requirement
• Created Java, HTML, Oracle, PostgreSQL, Unix shell scripts
• Designed application reports using SQL Server Reporting Services
• Developed data load packages using DTS to transform the input data from various sources
• Written complex T-SQL that encapsulates and manages business rules
• Performed unit, regression and functional testing of the created reports.
• Wrote Complex SQL Queries for Data validation
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for user.
• Managed customer expectations to ensure strong customer satisfaction by meeting the business needs for IT systems in a timely manner.
• Day to day communication with client related new requirement, support and development

Confidential

Role : Senior Data Analyst

Environment : MS SQL Server, Oracle SQL, PL/SQL 10g, 9i, Oracle Reports 9.0, Crystal Reports, DB2, TOAD, Java XML

Responsibility:

• Performed database administration and migration activities
• Team lead for database related task, managed three member group to address all DB related work
• Worked on Data Migration, Oracle Crystal report, Scheduled jobs Used Java XML for designing the reports
• Developed deployed various new reports for client
• Actively involved in data processing using Oracle PL/SQL and scheduled reports
• Used Java XML, Excel calculations pivot tables charts
• Supported Incident Management
• Change Management
• Defined coding standards, created templates for database objects development
• Developed stored procedures, functions and triggers to meet the functionality

Confidential

Role : Sr. Software Specialist

Environment : MS SQL Server, Oracle 9i 8i , Oracle Forms6i and Reports6i, UNIX, OEM, TOAD Oracle Designer 6.0 and BI Discoverer Reports

Responsibility:

• Designed system modules, created HLDs LLDs based on the SRS.
• Worked with Development team to get the development done along with unit testing and final scope verification UAT
• Managed a team of 3 members in various development activities of this project life cycle.
• Developed many challenging UIs and reports required by the project Business Clients
• Worked on Testing UAT
• Used Documents Version Control tool
• Developed reports using Discoverer Reports tool
• Created Tables, Views, Functions, Procedures, Packages, Triggers Jobs etc., at database level
• Used Oracle Forms trigger events logic to implement business functions
• Managed team on their day-to-day activities and performance evaluation

Confidential

Role : Sr. Programmer/Team Lead

Environment : MS SQL Server Oracle 8i, Oracle Designer 6.0, Forms and Reports, TOAD SQL Loader

Responsibility:

• Module lead for Material Management and Production Planning modules of the product
• Developed and Maintained Piton Financials ERP Standard Accounting, Payments, Collections, Budgets and Assets system.
• Developed complex entry forms and reports for General and Analytical ledger and Journal entry screens. This ERP contains a complete set of financial reports, which has several dimensions and almost all the fields would by dynamically selected by the user
• Developed Modules based on the specification given for UI Reports in Oracle Designer and Reports.
• Involved in analysis of individual modules, assigning and scheduling the modules to the developer, explaining and clarifying the issues unit testing the entire module.
• Managed a team of 3 members in various development activities of the project life cycle
• Developed integrated Dynamic Reports using Oracle Reports using Oracle Designer UIs