Summary:

• Total 12 Years of IT experience encompassing a wide range of skill-sets, roles and industry verticals.
• Over 5 years of experience in Data Warehousing and using IBM InfosphereDatastage 8.x.
• Over 2 years of experience in Data Modeling using CA Erwin 7.x, data architecture, business and data analysis.
• Over 10 years of experience in Insurance, Finance, Banking Domain MDM
• Experience in leading and managing teams. Handled multiple roles Consultant, Client side Delivery Manager, Technical Lead, Designer, Systems Analyst, Developer.
• Involved in Requirement Gathering, Project planning, Project estimation, Project tracking, and Risk Stakeholder management.
• In-depth knowledge of Systems Development Life Cycle SDLC In Agile as well as water fall model.
• Expertise in various data load strategies and scenarios like historical data, surrogate keys and summary tables.
• Experience in designing, optimizing and fine-tuning ETL environments taking into consideration aspects like efficiency, performance, restart ability and ease of maintenance.
• Good understanding of various databases such as Teradata, DB2 and Oracle.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Executed software projects for Telecom Billing , Insurance, Finance and Banking industry.
• Significant experience in providing 24 x 7 support, and resolving business user issues.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Technical Skills:

• Data Warehousing Tools: IBM InfoSphereDataStage 8.0, 8.1 8.5
• Development Tools: CA Erwin Data Modeler 7.3, TOAD
• Functional Modules: Telecom Billing , Insurance, Banking, Warehousing, Finance, MDM and Data Modeling
• Data Models: Dimensional Star, Snowflake , Relational, Normalized and De-normalized
• RDBMS: Oracle 10g, 9i, Teradata, DB2, MS Access 2000
• Languages: SQL, C, C , UNIX Shell Script, COBOL, JCL, VB, HTML, DHTML
• O/S: Windows XP, Windows NT Server, UNIX, DOS
• Other Tools: DB2 Platinum, MS Visio, RPM Rational Portfolio Manager , Rational Clear Quest, TOAD, SQL Developer

Professional Experience:

Confidential

Sr. Consultant / Solution Architect

• Asset Management Data Distribution
• Responsible for leading a project team in delivering solution to our customer.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Provide technical and business guidance to the team.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in Datastage and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.

Environment: UNIX, IBM Infosphere Data Stage 8.1 8.5 DataStage Quality stage Designer, Director and Administrator , Sequential Source Files, XML Source Files, Oracle SQL, PL-SQL, OBIEE

Confidential

Team Size : 15

Technical Lead/ETL Designer

Roles Responsibilities:

• Involved in the meetings with SME's Subject Matter Expert to understand the business requirements.
• Involved in Impact Assessment of the CR's.
• Lead a team of offshore developers from onshore.
• Involved in Project estimation, tracking risk management.
• Communicating with the offshore team on a weekly basis and updating the management about the status of the projects.
• Designing of the entire solution of a requirement raised by customers.
• Preparation of Low-level Designs.
• Responsible for coding of some programs and their confidence testing.
• Involvement in Unit Testing and System Testing.
• Responsible for reviewing the developed programs.
• Involved in CM Activities, Onsite Coordination and interaction with customer and Business user community from onsite.
• Supporting the Business users during the user acceptance testing.
• Responsible for creation of the Implementation plan and the implementation of the project in production.
• Mentoring junior team members and providing training on technical environments and business processes.
• Organized knowledge transfer sessions to encourage teamwork and create more subject matter experts.

Environment: UNIX, IBM Infosphere Data Stage 8.1 8.5 ,Teradata sql, Oracle PL-SQL, JCL, COBOL, Teradata, MS Excel, MS VISIO, OBIEE

Confidential

ETL and Database Lead/Architect

Roles Responsibilities

• We were using Agile Methodology. Participated in Sprint Planning, Scrum meeting and grooming session.
• Created script to check data replication between different databases. This script is checking replication for more than 400 tables.
• Help QA team to create test plan and review test cases.
• Translate business requirements into source-to-target mappings and transformation logic.
• Tuned existing code for long running ETL loads in the Data mart.
• Wrote shell script to execute various ETL routines.
• Created high level technical design document for Display Advertisement application in Microsoft Visio.
• Support production launch and resolved issues received during production launch.
• Involved in understanding of source to target data mapping, design and developments for processes required to extract, transform, and load data into the data warehouse.
• Good understanding of data warehouse concepts such as star schema, snowflakes schema, slowly changing dimensions etc.
• Used various stages like Transformer, Aggregator, Look up stage, Filter stage, Change data capture stage, Oracle enterprise stage, dataset etc.
• Used the Data Stage Designer to develop processes for extracting, transforming, integrating and loading data into data warehouse.
• Designed jobs for performing the Validation, Audit and Error rejection.
• Designed Sequence Jobs using Control jobs to stream line process flow for implementing Restart Logic.
• Used Environment Variables, Stage Variables and Parameter sets for developing Parameter Driven Jobs and debugging them.
• Worked on writing UNIX shell scripts to trigger the master sequence jobs.
• Wrote PL/SQL procedure to purge the application data.
• Enhanced the Job Performance by using proper Partitioning methods and analyzing the resources utilized using Job Monitor. Designed and developed various Parallel jobs.
• Worked on multiple source systems to extract.
• Worked with ESP Job scheduler for scheduling the Designed jobs
• Provided On call support to the Production Application System.
• Developed, maintained and modified existing and new Packages, standalone stored procedures and functions.
• Created shell script to check health of database after DB build deployment. We have multiple databases and this script run smoke test on different databases after the build deployment.
• Did extensive performance tuning using Explain Plan, V Views, Bulk binding, Exchange Partition.
• Performed various test efforts like data validation, integrity testing and unit testing using SQL test scripts.
• Production Support and bug fixing giving immediate and permanent solutions.
• Prepared release scripts and interacted with users and support teams.
• Worked as team lead, team member and offshore coordinator and also executed projects

Development Environment: Windows 2000/XP, Oracle 10g/11g SQL Loader, SQL Plus, PL/SQL , Test Manager, Toad, SQL Navigator, FTP, SFTP, Putty, Perl, Linux, Microsoft Visio, Bugzilla bug tracking system

Confidential

Senior Oracle ETL Developer .

Confidential process wherein required formatted Data was pulled from live DB server through dot net front end and oracle stored procedure and customized by using materialized views and formatted tables according to the requirement of top reporting authorities of Confidential securities. The stored procedures were run some through dot net and some by oracle scheduler job the responsibility was huge as the data was used for decision making

MIS application includes:

• Designing of tables creation and Maintenance of summary tables and stored procedures
• Creation and Maintenance of oracle scheduler jobs
• Reporting of table data through SAS dash board
• Sending of some report on ad-hoc basis depending on basis of urgency

Role:

• Redesign more than 450 Autosys jobs for SIM application to run based on Product type so that we can load data as soon as it is available. In old design it was based on business day.
• Tuned existing code for long running ETL loads.
• Automated many ETL loads using Autosys jobs.
• Improve existing CDID and SALES applications and reduce load time of monthly process by 28 Hours.

Development Environment: Windows 2000/XP, Oracle 9i/10g SQL Loader, SQL Plus, PL/SQL , SQL Navigator, Autosys, NDM Secure , Data Stage 8.0.1,Putty, Microsoft Visio.

Confidential

Senior Oracle Developer /DBA

Description:

• Confidential was a robust application used for the depository participants DP which were trading in securities mainly in Confidential
• The application was used for uploading of data given by stock exchanges and used for updating
• Customer portfolio and day to day transactions recording as well as branches consolidation in Head office also used for various report generation like Confidential reports

Dpsecure application included:

• Importing of flat files after validations from exchanges and exporting flat files for validations at the ends of exchanges
• Re-importing of out files given by exchanges to Dpsecure
• Generation of consolidated reports required for managers for decision making and analysis of business

Role Responsibilities:

• Coding, Testing debugging
• Installation of software interacting with the bank managers, Bug fixing coding and implementation of change requests
• Building indexes, Coding PL/SQL, Partitioning of table DBA activities like Database installation, DR backup server creation, oracle dump restoring archival server creating by using control files, User creation and granting access to users

Environment/ s/w used: Oracle PL-SQL, Asp.

Confidential

Oracle, Fox-pro Developer/Data Modeler

Description: Total Banking solution starting from saving bank opening to generation of balance sheet and profit and loss report

Banking application includes:

• Account opening , daily transaction entries
• Generation of day book reports
• Monthly, Quarterly, Half yearly interest calculations
• Report generation such as balance sheet, P L, RBI reports
• Such as Asset liabilities report, CD ratio reports etc.

Roles and Responsibilities:

• Involved in Design, Development, Testing, Integration and Post-Implementation Support of the Application, identifying the business logic and implementing them.
• Created Detailed Level Design Documents such as
• Test Plan Creation: To create issue wise detailed test plans which involves Test cases of an issue.
• Technical Specs Creation: To create the technical specs of the each Issue in detail thus enabling Client to understand the modifications.
• Coding: Coding of the issues by referring to technical specs created.
• Reviews: Conduct the self-review and peer-to-peer reviews at different stages of life cycle of conversion.
• Unit Testing: Conduct the unit testing of the modified programs.
• Generation of Adhoc Reports requested by the Client on urgent basis.
• Client Interaction: To attend the weekly status call.

Environments used: Oracle PL-SQL, Form 6i and Report 6i, Visual fox pro