Summary of Experience Eight plus years of professional experience in Software Design, Data Analysis, Data Modeling, Data Warehouse / Mart design, development, Application Support. Lead developer with experience in SDLC processes, standards and managing multiple projects Adept in gathering requirements, profiling data, checking information system needs, evaluating end-user requirement and working through the entire project cycle. Expertise in Relational, Dimensional modeling and creating ER Diagrams, Logical, Physical data models Proficient in writing Complex SQL, PL/SQL, Packages, Triggers, Analytical SQL, functions, Mat Views Sound knowledge in tuning SQL Queries and using Table Partitions, Table Clusters, DB Link, SQL Loader Well aware of the data warehouse concepts using Kimball and Inmon Methodologies. Good understanding of 3 tier architecture: Database, Middle tier, Application Server, Portal and Application Strong skills in the development of ETL Mappings and Workflows using Informatica PowerCenter. Proficient in report writing using tools such as Crystal Reports and Oracle Reports Builder Experience in writing complex Batch and VB Scripts, UNIX shell scripts, Awk and Nawk Scripts. Ability to handle data migrations, heavy volumes of data and installation of application patches. Expertise in managing upgrades, designing business process solutions and deploying scripts in production. Experience in the Installation and configuration of oracle databases on Sun Solaris, Linux, and Windows. Well versed in writing Test plan and Test scripts to test the backend and Front end functionalities Very strong communication, interpersonal skills and extensive International client experience.
Education MS-Management Information Systems Post Graduate Diploma in Computer Applications Bachelors of Commerce Professional Diploma in Network Centered Computing
Oracle 9i/10g/11g, Sybase, SQL Server 2000
SQL, PL/SQL, SQL Loader ,VB Script, VC++, VJ++, HTML, DHTML, XML,
C and C++, Java
Informatica Power Center/Power Mart 6.2/7.1.2/8.6.1, Data Stage
Sybase Power Designer 12, ER Studio, MS Visio 2003, ERWIN 4.0
Crystal Reports XI R2, Infoview, CMC, Oracle Report Builder 9i/10g, Analytics and OBIEE, Microstrategy 7.2.1, Business Objects 5.1
Operating Systems :
Windows NT Architecture, Windows XP, Solaris 8
PLSQL Developer 8.0.4, TOAD 11, SQL Developer 3.0.04, MS Office 2010, Developer 2000, Change Control Application, BMC Service Desk Express, Remedy, Mercury Quality Center, Symantec PC Anywhere
Version Control Tools:
CVS, VSS, Livelink Document management, SharePoint, Documentum 6.6
ORACLE AERS 4.5.1 and 4.6.2 Application/Server/Portal,
Siebel CTMS, Lawson, SABA, Databasics, AWARD, ART
Confidential,Raleigh, NC Mar 10 - Current Work closely with users in the Americas, Europe and Asia to transform data into information. Respond to Help Desk requests via Remedy and troubleshoot, resolve System\\ETL\\reporting issues. Subject matter expert for SABA (Training tool) and designed data models for various subject areas. Use Lawson, CTMS, ART, AWARD, SABA applications to troubleshoot reporting data issues. Participate in the planning of sprints and provide estimates for task completion times. Manage assigned projects, work through the entire SDLC and drive the projects to completion. Conduct business requirement meeting with users of source systems for operational/warehouse reporting. Perform data profiling, research and analysis for Financial, Clinical, HR, Training and other subject areas. Design, develop Type 1 and 2 dimensions, facts, Star Schemas based on user requirements Create and Optimize PLSQL packages for ETL, Reporting to automate and enhance functionalities. Create and manage 500+ backend PLSQL procedures linked to crystal reports (using ref cursors) Develop complex crystal reports and test the report output data in the relevant application for accuracy. Involved in query re-write, creating indexes, SQL tuning and query optimization using Explain Plan. Ensure high level of application availability and provide technical support to developers. Develop VB Scripts and use Informatica, OEM for scheduling jobs at required frequency. Troubleshoot issues with the nightly data load in the Informatica ETL jobs or OEM jobs. Document Requirements, Analysis and Design information related to SDLC for sprint assignments. Create Unit Test Cases, Test Plans based on requirements and perform Unit, Stress and System tests. Work on Analytics, OBIEE dashboards, Prompts, Filter, Queries, Catalog Management and Manage Users.
Work as part of Enterprise Reporting to Install, maintain, and support enterprise applications like Crystal Enterprise, Business Objects, Infoview, Analytics, OBIEE and Informatica PowerCenter tools.
Environment: Oracle 10g/11g,TOAD,OEM, Power Center 7.2/8.6, Crystal Reports 11 R2, Instance manager, Central Management Console, Analytics, OBIEE, Siebel CTMS, ER Studio, Visio 2003, Documentum, VSS.
Confidential,Morrisville, NC Mar 08 Mar 10 Lead systems developer in the support of ORACLE AERS Application. Performed Data Migration for various business units with the appropriate workflow, processes and users. Handled communication with users, vendors, clients and trained new system developers in AERS support. Developed custom backend PLSQL Packages for enabling various functionalities in the AERS application. Created complex custom reports using Reports Builder and resolved issues with existing reports. Analyzed backend database objects, functional dependencies to troubleshoot complicated AERS issues. Handled Schema Creation, Report Server Issues, Portal Administration/Issues, User Roles, Data Export/Import, SQL Loader, Installation and Operational Qualification checklists, Meeting Minutes Installed AERS iPatches, handled batch loading scripts and password changes in the database/portal/ application servers and refreshed backup (Disaster Recovery) servers. Created Service Requests with Oracle for Application, Server, Portal and Report related issues. Responsible for creating and maintaining the System Architecture diagram in Visio. Prepared requirements document, flow charts, system specification document, test plans, user manuals. Used BMC Service Desk Express, Quality Center to manage technical issues for Application Support. Responsible for dictionary upgrades, adding products in TMS, creating change controls, IOQs. Created Unit Test Cases, Test Plans and performed Unit and System test as well as validation testing.
Worked on Oracle Adverse Event Reporting System (Oracle AERS) - This is a comprehensive solution for product safety monitoring and compliance product integrated with Oracle Clinical and Thesaurus Management System.
Environment: Oracle 9i/ 10g, AERS 4.5.1 / 4.6, Remote Desktop, Visio 2003, BMC SDE Express, Change Control Application, Mercury Quality Center, Oracle Reports Builder 9i/10g
Confidential,NC Jul 07 Jan 08
Worked as a Lead Developer in Trading Knowledge Center project for Webstats. Webstats is a large data warehouse used for directional analytics. Responsible for System Design and development of DB components based on user requirements. Created and documented System design specification and Technical Design specifications. (SDS/TSD) Used Power Designer for logical, physical data model and database design using database standards. Developed Context, Data Flow Cycle and Sequence diagrams using Visio for SDS / TSD. Created Tables, Synonyms, Grants, Directory and used Dynamic SQL, Ref Cursors, DBLINKS. Worked extensively with PL/SQL packages, procedures, and functions using TOAD. Documented details relevant to different phases - Design, Development and Implementation. Analyzed query performance using Explain plan and worked in an environment containing Partitions. Developed UNIX shell scripts to automate processes and for production deployment of the scripts. Worked closely with the QA Team to resolve defects and performed unit testing for data consistency.
Environment: Oracle 9i, Power Center 6.2, Sun Solaris, Power Designer 12, Visio 2003, SharePoint, VSS.
Confidential,Cary, NC Mar 06 Jul 07
Junior DBA /Systems Analyst
Worked as a Junior DBA to provide on call database support as well as a system analyst for many projects. Worked in a high pressure production environment and on call 24/7. Actively participate in System Implementations, Schema changes, Upgrades and Data Migrations. Involved in gathering requirements, database design, logical data model for Stats Project Created and maintained databases, schemas, tables, indexes, sequences, views and record types. Enforced and maintained database constraints to ensure integrity of the database. Gathered domain knowledge, analyzed data and wrote complex SQL using correlated sub-queries Wrote stored procedures, database triggers, packages, functions, referential cursors, DB LINKS. Involved in query optimization and used SQL Trace, Explain Plan, TKPROF, Hints to tune queries. Generated various reports for different departments using SQL, Unix Shell Scripts, Nawk Scripts Automated processes using cronjobs, monitored database activity, utilization and reported progress Handled Java Programs, JDBC to communicate with the database. Reduce data inconsistency and post-integration issues by providing a robust data validation layer.
Environment: Oracle9i, SQL Loader, ERWIN 4.0, Sun Solaris 8, UNIX, Aqua Data Studio, CVS
Client: Involved in design, development of the Data Mart and used ERWIN for Physical, Logical Data Modeling. Provide analytical expertise, support during Analysis, Design and setting up environment. Used ETL to load data from multiple input sources like flat files, DB2, SQL Server to target DB2 database. Developed complex aggregate, normalizer, XML, join, look up, update strategy transformations Used mapping parameters for incremental loading. Handled Round Robin, Key Range Partitioning and data parallelism to fine tune execution times. Worked with UNIX commands and wrote UNIX Shell Scripts to automate processes. Performed unit test and extensively worked with the QA team to get the desired results.
Confidential,Columbus, OH Aug 05 Jan 06
Worked on the Cook Project - This involved extracting data from different data providers to load in the warehouse.
Environment: Oracle 9i, SQL Server 2000, DB2, ERWIN 4.0, UNIX, Power Center 6.2, Business Objects 5.1
Confidential,Scottsdale, AZ Jan 05 Apr 05
Confidential,This is a program that uses various attributes, events, classification and file loads. Loyalty card also links actual prescription dispensing activity to patient benefits and interactions. Involved in the design, analysis, programming and testing of the ETL. Extensively worked with PLSQL packages, procedures, functions, ref cursors and triggers. Developed and tested ETL applications for the warehouse using Informatica, Oracle and SQL Developed complex joins in source qualifier transformation using transformation rules Documented the Informatica mappings in excel for the entire project Administrated Workflow Manager to run session, tasks, worklets and workflows. Involved in designing universes, developing reports using BusinessObjects 5.1
Environment: Oracle 9i, SQL SERVER 2000, UNIX, Informatica Power Center 6.2, Business Objects 5.1
Client Confidential,Mineola, NY Aug 04 Dec 04
Worked on the Revenue and Statistics Phase II project This is an expansion of phase I and leverages the dimensional model, focusing on providing analysis reporting capabilities on the billing and usage information. Translated business requirements into data mart design / development Generated sample SQL, PL/SQL scripts to business users for approval. Used Informatica to pull data from Oracle, cleanse, transform and load data to SQL SERVER 2000 Used Workflow Manager to setup workflows, worklets and tasks to schedule loads at required frequency Defined and created reports in MicroStrategy 7.2.1 and validated reports
Environment: Oracle 8i, SQL SERVER 2000, MS Visio, UNIX, PowerCenter 6.2, MicroStrategy 7.2.1.
Management Information Systems Intern Jan 04 - Jul 04
- Created databases in MySql to manage prospect contact and mailing lists and developed SQL Queries in MySQL for data extraction, manipulation, reporting and migrated data from MS Excel to MySQL.
- Established communication information flow systems and helped in marketing research.
- Involved in marketing system study, requirement analysis and coordinated graduate recruitment programs.
- Handled the entire correspondence