SUMMARY

• Over 14 years of experience in Database Development with through knowledge of various RDBMS concepts, Business Intelligence and Data warehousing.
• Experience in Data Modeling (E - R and Dimensional), Normalization, Configuration, Performance Tuning, Optimization and Maintenance activities.
• Excellent knowledge in developing Stored Procedures, Views, Joins, Triggers, Cursors, Indexes and Indexed Views, Temporary Tables & Variables.
• Lead the team in design, develop, test and implementation of DW/ETL systems.
• Design and build ETL processes using Informatica ETL tools like Powercenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experience involves working in both Agile and Waterfall software development methodologies.
• Gathering and analyzing technical business requirements. Creating documentation like program specifications, design documents and unit test plans.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Providing Estimates for the new requirements and analyzing their counter effects in the existing system.
• Code deployment to Dev, QA and Production environment and provide operation support.
• Onshore-offshore co-ordination and Team management.
• Extensive experience and in-depth working knowledge in Oracle writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Proficient in Performance Tuning, Query Optimization, Tuning various Database objects in order to quick data retrieval in reports.

TECHNICAL SKILLS

Operating Systems: Windows NT, Windows XP, Windows 2000 Professional, Windows 2003, Unix

Databases: Oracle 9i/10g/11g, MS Access.

Data Modeling: Power Designer, Microsoft Visio 2003/2007

Front Ends: Visual Basic 6.0

Languages: PL/SQL, SQL

Tools: Crystal Report 8.5/9/XI/2008,Business Objects Enterprise XI/XI R3, Optio 7.8,Infomatica 8/9.1, Seagate Info 7.5, HP Quality Center, PM Smart, TOAD, PLSQL Developer, SQL Developer, Service now, Rally, Teradata SQL Assistant

Source Control: Visual SourceSafe, PVCS, TFS, Perforce, Clearcase, Accurev

PROFESSIONAL EXPERIENCE

Confidential, Bothell, WA

Data Analyst/Track Lead

Environment: Oracle 11g, Big Data/ Hadoop, Hue, Informatica 9.1, Teradata, Denodo, Microsoft Share Point, Quality Control (QC), Accurev, Control-M and Rally

Responsibilities:

• Member of Data & architecture team for integrateddata warehouse management which takes care of availability, usability, integrity, and security ofenterprise wide data.
• Collaborating on day to day activities of development and QA activities with the respective team.
• Helping business on data integration, data visualization and complex views to design reporting data layer.
• Participate program level meeting to update project status,identify risks and issues in delivery and provide mitigation plans and resolutions.
• Design and build the Source to Target Mapping creation.
• Involved in Transformation Logic design.
• Working with Data Modelers for creation of CDM, LDM and PDM.
• Involved in reconciliation of data between Source and Target.
• Involved in review of design documents.
• Involved in Data Capturing, Data Provisioning and Data Analysis.
• Works with SMEs to understand the source system
• Estimate the effort for extraction and transformation.
• Project re-scoping and re-estimation
• Prepare deployment document and provide support to deployment team.
• Monitor the production system.
• Provide warranty support.

Confidential, Old Tappan, NJ

DW/BI Technical Lead

Environment: Informatica 9.1, Oracle 11g, AIX UNIX 5.2, ASP.net, Business Objects XI R3, Service Now, Microsoft Office Project 2007, SVN, Quality Control (QC), PM Smart, JIRA

Responsibilities:

• Design and build ETL processes using Informatica ETL tools like Powercenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Responsible for Informatica Admin activities like Create new user and assign privileges, Workflow/session Migration in repository, Installation and configuration of PowerCenter 9.1 hot fixes, patches.
• Using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter, Rank, Sequence and Union.
• Experience integration with Salesforce. Using the Salesforce as input in Informatica.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Responsible for Oracle SQL performance tuning by indexing, partitioning, statistics and correcting data design issues.
• Responsible for creating and modifying the Oracle PL/SQL programs like stored procedures, functions, triggers and packages according to the business requirements.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Handling the daily sprint calls with team and using JIRA tool and Google drive sheets for tracking the assigned tasks.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 9.1 for data loading.
• Building Reports according to user Requirement.
• Implemented slowly changing dimension methodology for accessing the full history of Orders.
• Write Shell script running workflows in Unix environment.
• Optimizing performance tuning at source, target, mapping and session level
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Release and Deployment Management
• Peer Review, Unit testing, code review and trouble shooting
• Database performance optimization.
• Knowledge Transfer to QA, Defect Fixing and Defect Tracking
• Assign tickets to team members and track the SLA and Backlog of tickets
• Database and Functional level testing.
• Gathered and analyzed technical business requirements. Created documentation like program specifications, Technical design documents and unit test plans.
• Worked on tools like VSS (a version management tool), Putty (a telnet tool), Toad (a database administration tool), Autosys (a scheduling tool) and Servicenow (a request management tool).
• Integrated with multiple ERP and Mainframe systems like PEUOPS, SAP and Socrates.

Confidential

DW/BI Technical Lead

Environment: Java, Oracle 10g, UNIX, Toad 9.0, SQL Developer, Microsoft Office Project 2007, Clearcase, WBS/Complexity Point Estimation, Quality Control (QC), PM Smart

Responsibilities:

• Requirement gathering, designing and coding and optimizing the query.
• Review gap analysis for new business requirements.
• Support operational and service requests.
• Design and Maintaining database.
• Developing and Designing Oracle PL/SQL programs like stored procedures, functions, triggers and packages according to the business requirements..
• Developing and Designing MS Excel Power Pivot and Pivot reports on databases and cubes.
• Working on different product lunch as well as new enhancements.
• Performance Tuning
• Customer Interaction, Requirement Gathering, Project Planning, Estimating, Resource Management, Execution, Monitoring.
• Monitoring various jobs running between SLK and ERP database.
• Cron Job automation in the Unix
• Creation the Part and Order in the ERP (Oracle Apps) for QA and Unit testing.
• Offshore and onsite Team handling and client interaction

Confidential

Database Technical Lead

Environment: Oracle 10g (PL/SQL), Crystal Report 2008 Business Object Crystal Enterprise 2008, Actuate, Windows, Perforce.

Responsibilities:

• Creation of Report Specification Documents.
• Creation of the design approach for migration from actuate to crystal reports.
• Create Stored Procedures, Functions and Packages in Oracle.
• Creation of Reports using Crystal Report 2008.
• Unit testing of the reports and creation of Unit Test Case for each report.
• Team Management.
• Mentor fresher’s.

Confidential, New York

Database Technical Lead

Environment: Oracle 9i (PL/SQL), Crystal Report XI, Optio 7.8, Business Object Crystal Enterprise, Business View Manager, Windows 2003, TFS.

Responsibilities:

• Responsible for understand the auto renew and XSOP billing requirements.
• Coordinate with offshore team members during the project.
• Analysis the existing impact on database, application and reports.
• Preparation of Technical Specifications, Solution Design Document, Test Plan, Test Cases Defect documents.
• Creation/Maintenance, deployment and scheduling of reports using Crystal Reports XI and Crystal Enterprise XI.
• Development, support, and maintenance of Optio 7.8 (Document Customization Language).
• Writing database Packages, SP Creation & SQL Tuning. (Using PL/SQL Developer)

Confidential

Senior Software Engineer

Environment: Oracle 9i (PL/SQL), Crystal Report XI, Optio 7.8, efax, Business Object Crystal Enterprise, Business View Manager, Windows 2003, VSS 6.0.

Responsibilities:

• Writing database Packages, Stored Procedure Creation and SQL Tuning.
• Creation/Maintenance, deployment and scheduling of reports using Crystal
• Reports XI and Crystal Enterprise XI.
• Development, support, and maintenance of OPTIO 7.8
• (Document Customization Language).
• Tuning various Database objects in order to quick data retrieval in reports.
• Creation/Maintenance of UNIX scripts running at onsite.
• Ensure quality processes within the team and delivered work products to customer. (Using PM Smart).
• Monitor schedule with team members and ensure work flow.
• Assisting the team members for any technical difficulty.
• Interaction with client for requirement gathering and updating the
• Use Cases subsequently (Using Mercury Quality Center).
• Conducting regular project meetings with team members and with the client.
• Monitor timely deliveries.
• Unit testing and Configuration management

Confidential

Analyst Programmer

Environment: Oracle 9i (PL/SQL), Crystal Report 8.5/ XI, VB 6.0, Crystal Enterprise, Seagate Info 7.5, Toad, PVCS

Responsibilities:

• Writing Database Packages, Procedures, Functions, Database Triggers, SQL Tuning.
• Development of Crystal Reports for Agency and New Business Departments.
• The SMS VB program then picks up this data and dispatches the SMS to the concerned Customers / Agents.
• Unit Testing and configuration management.
• Executed the UAT Support.
• Training team members.