SUMMARY:

• Eight Plus (8+) years of total IT experience and Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, Testing, creating Report and Documentation. Implementation of Warehousing and Database business systems for Public Welfare, Health, Insurance, Retail, Financial and Tele Communications industries.
• Seven Plus (7+) of strong Data Warehousing experience using Informatica PowerCenter 8.6/8.5/8.1/7.1/7.0/6.2/6.1/5.2/5.1 (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Siebel, Migrating Experience from 7.1.2 to 8.1.1, Informatica PowerMart 7.0/6.2/6.1/5.2/5.1.1/4.7/1.7 Power Connect, Power Exchange, Data Explorer, Data Quality, Datamart, ETL, OLAP, OLTP, Autosys, Control M, Visual Source Safe, Maestro, UNIX Shell Scripting.
• Four Plus (4+) years of Business Intelligence experience using Business Objects XI/6.5/6.0/5.1/5.0, Business Objects SDK, Web Intelligence 2.5/2.6, Cognos Impromptu 8.0/7.0/6.6, Power play, Transformer, Impromptu Web Reports (IWR), PowerPlay Enterprise Server, Micro Strategy. OLAP, Data Report, Crystal reports Enterprise XI.
• Four Plus (4+) years of Dimensional Data Modeling experience using Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using ERWIN 4.5/4.0/3.x and Oracle Designer.
• Seven Plus (7+) years of experience using Oracle 10g/9i/8x/7.x, DB2 8.0/7.0/6.0, Teradata V2R5/V2R4(T-SQL, Multiload, FastLoad, T-PUMP, BTEQ, Import and Export), DB2, Sybase IQ, MS SQL Server 2005/2000/7.0/6.5, MS Access 7.0/97/2000, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 3.x/95/98/2000/XP and Sun Solaris 2.x. 5 years involved as Oracle or SQL Server Developer

TECHNICAL SKILLS:

• Data Warehouse: Informatica PowerCenter 8.6/8.5/8.1/7.1/7.0/6.2/6.1/5.2/5.1/ (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager), Business Objects Data Integrator (BODI), PowerMart 7.0/6.2.1/5.2/5.1/4.7, PowerConnect, OLAP, OLTP.
• BI & Reporting: Crystal Report XI/9.0, Cognos 8.0, Business Objects XI/6.5/6.0/5.1/5.0, Business Objects SDK, Web Intelligence 2.5/2.6, Cognos Impromptu 7.0/6.6/6.x, Power play, Transformer, Impromptu Web Reports (IWR), PowerPlay Enterprise Server, Microstrategy 7i, MS Access Reports
• Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, ERWIN 4.5/4.0/3.5.2/2.x, Oracle Designer 2000
• Databases: Oracle 10g/9i/8i/8.0/7.3, MS SQL Server 2005/2000, IBM DB2, IBM UDB 8.0/7.0/6.0/5.0, DB2/400, Teradata V2R5/V2R4/V2R3 with M-Load, TPUMP & BTEQ, PL/SQL, SQL*Loader, Developer 2000
• Job Scheduling & Other tools: Autosys, BMC Control M, Cron, Maestro,
• Environment: UNIX (Sun Solaris, HP-UX, AIX), Red hat Linux, Windows 2003/2000/XP/98, Sun-Ultra, Sun-Spark, Sun Classic, RS/6000, HP 9000, SCO Unix, Mainframes
• Others: Cobol, Java, XML, JavaScript, XML, HTML, DHTML, Trillium 7.6/6.0, CSS, SQL, D-AMPS, Visual Source Safe, Quest TOAD 7.6, Quest Central for DB2, Syncsort for UNIX/Windows

EDUCATION & CERTIFICATIONS:

• B.S in Computer Science
• Certified in Data Warehousing Concepts.

PROFESSIONAL EXPERIENCE:

Confidential, HARRISBURG, PA MAY'09- Present
Senior Informatica Developer
Confidential is one of the leading Consulting companies, providing clients a broad range of fully integrated services in areas that include public welfare, accounting, assurance and advisory, risk, tax, management, financial, technologyand human capital consulting. This Project was funded by Pennsylvania Department of Public Welfare. The current project with Deloitte has two data warehouses running within the enterprise to support the business needs of individual organizations and Program Offices of Pennsylvania Department of Public Welfare. The current initiative was implemented to integrate multiple programs within the Department of Public Welfare (DPW), including the Office of Developmental Programs, the Office of Long Term Living, the Office of Children, Youth and Families, the Department of Health, the Department of Aging, the Office of Child Development and Early Learning and The Bureau of Autism Services. The new active EDW enables real-time analysis of business and operational opportunities, going beyond traditional retrospective Analysis, automated event/trigger-based intelligent applications and more actionable member interventions using Informatica 8.6.

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Involved in Analyzing the business requirement and created Technical Design Documents.
• Extracted source data from Oracle 10g, SQL Server 2005, DB2, XML and flat files of customer accounts and loaded to a relational data warehouse and flat files. The data was extracted and written to Oracle.
• Imported Source/Target tables from the respective database and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression and Aggregator) inside a mapplet and created new mappings using Designer module of Informatica Power Center to implement the business logic and to load the customer data incrementally.
• Extensively worked to update existing Data Model using Erwin 4.5.
• Extensively worked to create 4 Type 2 Dimension mappings.
• Worked on SQL tools like TOAD to run SQL queries and validate the data.
• Developed PL/SQL aggregation programs and stored procedures that Informatica can use.
• Extensively work on 2nd and 3rd Normal form.
• Used T-SQL, Stored Procedures while working in MS SQL Server 2005/2000.
• Extensively work on the performance tuning of Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Implemented pipeline partitioning (hash key, key range, round robin and pass through) to improve session performance.
• Migrated mappings, sessions, and workflows from Development to Testing and then to Production environments
• Performed unit, integration and system level performance testing. Associated with production support team in various performance related issues.
• Helped to create user guides and trained end users for Informatica.
• Involved in designing, developing and testing the report using Cognos
• Generated Ad-hoc Queries.
• Involved in writing project documentation using Microsoft VISIO for different diagrams.

Environment:Informatica PowerCenter 8.6 (Repository Manger, Designer, OLAP, Server Manager, Workflow Monitor, Workflow Manager), Informatica PowerConnect for DB2, , Cognos 7.4, Crystal Report XI, Oracle 10g, SQL, PL/SQL,DB2 8.0, MS SQL Server 2005, Teradata V2R5/V2R4 , Flat Files, Erwin 4.5, ,Windows XP, UNIX Shell Scripting, Autosys, TOAD, HP-UX, Microsoft VISIO.

Confidential, BUFFALO, NY Sep'08- April '09
Senior Informatica Developer
Confidential is one of the leading health insurance companies, providing innovative health plans, dental and vision benefits, pharmacy benefit management services, life insurance and other short term healthcare plans.Confidential has three data warehouses running within the enterprise to support the business needs of individual organizations. To better integrate and leverage information, Independent recently created the first active enterprise data warehouse (EDW) in the healthcare insurance industry that captures claim information within one day of an event (such as an office visit or hospital discharge), as opposed to the traditional lag of three to six weeks found in most health insurer data warehouses by using Informatica 8.5.

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Involved in Analyzing the business requirement and created Technical Design Documents.
• Worked extensively on Bulk Data Access and Change Data Capture option.
• Extracted source data from SQL Server 2005, Oracle 10g, DB2 flat files of customer accounts and loaded to a relational data warehouse and flat files. The data was extracted and written to Oracle.
• Developed PL/SQL aggregation programs and stored procedures that Informatica can use.
• Extensively worked on 2nd and 3rd Normal form.
• Extensively work on the performance tuning of Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Implemented pipeline partitioning (hash key, key range, round robin and pass through) to improve session performance.
• Migrated mappings, sessions, and workflows from Development to Testing and then to Production environments
• Performed unit, integration and system level performance testing. Associated with production support team in various performance related issues.
• Helped to create user guides and trained end users for Crystal Report.
• Involved in designing and developing the universe to support the reporting requirements by creating the Business Objects data model selecting/joining tables, subdividing into contexts and creating the objects which are grouped into classes and tested them for efficient report generation and correct mappings of the objects.
• Generated Ad-hoc Queries.
• Created Unix Shell scripting to automate the execution of the workflows.
• Involved in designing and developing the Reports using Crystal Report 9.
• Involved in writing project documentation using Microsoft VISIO for different diagrams.

Environment:Informatica PowerCenter 8.5 (Repository Manger, Designer, OLAP, Server Manager, Workflow Monitor, Workflow Manager), Informatica PowerConnect for DB2, , Business Objects XI/6.5, Crystal Report 9.0, Oracle 10g, SQL, PL/SQL,DB2 8.0, MS SQL Server 2005, Teradata V2R5/V2R4 , Flat Files, Erwin 4.5, ,Windows XP, UNIX Shell Scripting, Autosys, SQL*Loader, PVCS, TOAD, HP-UX, Trillium 7.6 (Converter, Parser, Geocoder, Matcher), Microsoft VISIO.

Confidential, Miamisburg, OH Jan '08- Aug '08 Senior ETL Developer/ETL LEAD
Confidential is one of the leading global provider of business information solutions to professionals in a variety of areas, including: legal, corporate, government, law enforcement, tax, accounting, academic, and risk and compliance assessment. LexisNexis originally pioneered online information with its Lexis® and Nexis® services. A member of Reed Elsevier, LexisNexis helps customers achieve their goals in more than 100 countries, across six continents. The project was aimed to make a data warehousing system to develop a relational data structure to store processed transactional data in a form that is suitable for reporting activities. The functionality of the project was to load processed transactional data into data mart(s) with data pre-aggregated to a level to optimize reporting capabilities while taking into consideration long term storage requirements. Informatica Power Center 8.5 tool was used to transform data from Data warehouse into an OLAP server to provide Business Intelligence Analysis services.

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Experience with server, query, application and performance tuning.
• Working knowledge on different web services applications Business Objects Application Foundation.
• Demonstrated experience in large Integration of legacy systems
• Involved in upgrading from Power Center 8.1 to 8.5
• Involved in Dimensional Modeling and to design the business process, dimensions and measured facts.
• Good understanding on Data Modeling Architecture.
• Worked extensively on Bulk Data Access and Change Data Capture option.
• Handled data warehouse with more than 2.0 Terabytes of data.
• Imported Source/Target tables from the respective database (Oracle, SQL Server) and created job, workflow, data flow with queries using Designer module of Business Objects Data Integrator to implement the business logic and to load the customer transaction and notification data incrementally using Informatica Power Center 8.5.
• Extensively worked with SSIS, SSRS using SQL Server 2005.
• Worked extensively with XML Transforamtions Worked with Gap Analysis.
• Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.
• Worked on SQL tools like TOAD to run SQL queries and validate the data.
• Developed PL/SQL aggregation programs and stored procedures and packages to solve some issues in which case performance enhanced a lot.
• Extensively work on the performance tuning of Informatica Mappings as well as the tuning of the sessions.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Worked with Informatica Data Explorer, Data Quality and MDM very extensively.
• Good knowledge on Service Oriented Architecture (SOA) concept
• Performed unit, integration and system level performance testing. Associated with production support team in various performance related issues.
• Converted some code from Java to Informatica.
• Worked on Unix Shell Scripting to run the workflow and scheduling the jobs.

Environment: Informatica Power Center 8.5, Power Mart 7.0, AIX 6.1,Power Exchange, Mainframe, Sybase Power Builder 11, Cognos 8.0, Business Objects XI/6.5, Oracle 10g, SQL, PL/SQL,DB2 8.0, MS SQL Server 2005/2000, Teradata V2R5/V2R4 , Flat Files, Erwin 4.5, ,Windows XP, Perl Scripting, Autosys, SQL*Loader, PVCS, TOAD, HP-UX, Trillium 7.6 (Converter, Parser, Geocoder, Matcher), QlikView, Microsoft VISIO.

Confidential, PARSIPPANY, NJ June'07-Dec '07
Sr. Informatica Developer/Team Lead
Confidential, a subsidiary of Wyndham Worldwide Corporation, is one of the leading companies providing leisure real estate developers a huge advantage in their marketplace, and vacationers worldwide with unparalleled choice and flexibility in their leisure accommodations. It is one of the worldwide market leader in vacation exchange and vacation rentals. The project was aimed to make a data warehousing system of notifications to RCI member based on member address and distribution channel provided in input XML data feed. The functionality of this project was to get data from various OLTP application sources and selectively extract, transform and load it into the Oracle data warehouse using Informatica PowerCenter 8.5/8.1.1 tool and then transform data from data warehouse into an OLAP server to provide Business Intelligence Analysis services. For reporting, Business Objects XIR2 and Crystal Reports XI were used

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Imported Source/Target tables from the respective database(Mainframe, SQL Server) and created reusable transformations(Joiner, Routers, Lookups, Rank, Filter, Expression, Aggregator and XML) inside a mapplet and created new mappings using Designer module of Informatica Power Center to implement the business logic and to load the customer transaction and notification data incrementally using Informatica 8.1.1 with Red Hat Linux OS.
• Worked extensively on Bulk Data Access and Change Data Capture option.
• Working knowledge on different web services applications Business Objects Application Foundation.
• Involved in working with Mainframe MVS OS, TSO, JCL.
• Involved in working with Repository Manager, Informatica Admin Console.
• Used Trillium to cleanse customer address data.
• Used Shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.
• Worked on SQL tools like TOAD to run SQL queries and validate the data.
• Developed PL/SQL aggregation programs and stored procedures that BO queries can use.
• Used T-SQL while working in MS SQL Server 2005/2000.
• Worked to convert Crystal Reports to SSRS.
• Worked with Mainframe.
• Extensively work on the performance tuning of Informatica Power Center Mappings as well as the tuning of the sessions.
• Worked with Informatica Data Explorer, Data Quality and MDM very extensively.
• Working knowledge on Facets
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Implemented pipeline partitioning (hash key, key range, round robin and pass through) to improve session performance.
• Involved to work with Offshore Developers
• Created Perl scripting to automate the execution of the workflows.
• Worked to build DSS and OLAP report development using Cognos8BI, Impromptu and Reportnet, ReportStudio using Cognos Transformer.
• Involved in designing and developing the universe to support the reporting requirements by using Cognos from the data model selecting/joining tables, subdividing into contexts and creating the objects which are grouped into classes and tested them for efficient report generation and correct mappings of the objects.
• Involved in writing project documentation using Microsoft VISIO for different diagrams.

Environment:Informatica PowerCenter 8.1.1, Informatica PowerConnect for DB2, (Admin Console, Repository Manger, Designer, OLAP, Server Manager, Workflow Monitor, Workflow Manager), Sybase Power Builder 11,Crystal Reports XI, AIX 5.2,Power Exchange, Mainframe MVS OS, TSO, JCL, Cognos 7.0, Business Objects XI/6.5, Oracle 10g, SQL, PL/SQL,DB2 8.0, MS SQL Server 2005, Teradata V2R5/V2R4 , Flat Files, Erwin 4.5, ,Windows XP, UNIX Shell Scripting, Autosys, SQL*Loader, PVCS, TOAD, HP-UX, Trillium 7.6 (Converter, Parser, Geocoder, Matcher), Microsoft VISIO.

Confidential, KANSAS CITY, MO Apr'06-Apr'07
Informatica Lead
Confidential is one of the leading health insurance companies, providing innovative health plans, dental and vision benefits, pharmacy benefit management services, life insurance and other short term healthcare plans. Assurant has three data warehouses running within the enterprise to support the business needs of individual organizations. The new active EDW enables real-time analysis of business, clinical and operational opportunities, going beyond traditional retrospective Analysis, automated event/trigger-based intelligent applications and more actionable member interventions using Informatica 8.1.1/7.1.2.

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Upgraded the PowerCenter from 7.1.1 to 8.1.1.
• Migrated all the mappings and other components from 7.1.1 to 8.1.1.
• Involved in dealing with very large database more than 4 Terra bytes of data.
• Extracted source data from SQL Server 2005, Oracle, XML and flat files of customer accounts and loaded to a relational datawarehouse and flat files. The data was extracted and written to Teradata using MLoads and FLoads.
• Extensively worked with T-PUMP and BTEQ.
• Imported Source/Target tables from the respective database and created reusable transformations(Joiner, Routers, Lookups, Rank, Filter, Expression and Aggregator) inside a mapplet and created new mappings using Designer module of Informatica Power Center to implement the business logic and to load the customer health insurance data incrementally.
• Worked on SQL tools like TOAD to run SQL queries and validate the data.
• Extensively work on the performance tuning of Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Implemented pipeline partitioning (hash key, key range, round robin and pass through) to improve session performance.
• Performed unit, integration and system level performance testing. Associated with production support team in various performance related issues.
• Involved in designing and developing the universe to support the reporting requirements by creating the Cognos 7.4 data model selecting/joining tables, subdividing into contexts and creating the objects which are grouped into classes and tested them for efficient report generation and correct mappings of the objects.
• Involved in writing project documentation using Microsoft VISIO for different diagrams.

Environment:Informatica PowerCenter 8.1/7.1.1, Informatica PowerConnect for DB2, (Repository Manger, Designer, OLAP, Server Manager, Workflow Monitor, Workflow Manager), Power Mart 7.0, AIX 5.2,Power Exchange, Cognos 8.0, Business Objects XI/6.5, Oracle 10g, SQL, PL/SQL,DB2 8.0, MS SQL Server 2005, Teradata V2R5/V2R4 , Flat Files, Erwin 4.5, ,Windows XP, UNIX Shell Scripting, Autosys, SQL*Loader, PVCS, TOAD, HP-UX, Trillium 7.6 (Converter, Parser, Geocoder, Matcher), Microsoft VISIO.

Confidential is one of the leading companies in the nation for the auto insurance with more than 10 million policyholders. State Farm Insurance companies have consistently received high ratings for financial strength and claims paying ability from various independent rating agencies. The Insurance Data warehousing project was developed in an effort to streamline the entire process of Insurance and to keep track of various financials on a daily, weekly, monthly basis. Policy, Premium, Claims and Payments were the modules we were basically dealing. For reporting Business Objects 6.x version is used.

Responsibilities:

• Wrote documentation to describe program development, logic, coding, testing, changes and corrections
• Implemented the Software development life cycle methodology for creating reports.
• Requirement analysis in support of Data Warehousing efforts.
• Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Worked on PowerCenter Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created multiple catalogs and resolved loops by creating table aliases and contexts.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerts.
• Creation of Transformations like Sequence generator, Lookup, joiner and Source qualifier transformations in Informatica Designer.
• Worked with Epic for reporting.
• Developed PL/SQL aggregation programs and stored procedures that BO queries can use.
• Provided production support by monitoring the processes running daily.
• Developed Informatica mappings and also tuned them for better performance
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Performance tuning of Oracle PL/SQL Scripts
• Designed and developed Perl scripts.

Environment: Informatica PowerCenter 6.2, PowerConnect for Peoplesoft, Work Flow Manager, Work Flow Monitor, Cognos 7.4, Business Objects 5.0, Erwin 4.0, Oracle 9i/8i,Teradata V2R5/V2R4 Peoplesoft, AIX 5.2, Perl Scripting, SQL, PL/SQL, PVCS, Visual Basic 6.0 Maestro, Toad, SQL * Loader, MS SQL Server 2000, Sun Solaris 2.6 UNIX, Windows NT 4.0.

Confidential, Sunnyvale, CA Sep'04-Jan'05
ETL Developer
Responsibilities:

• Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center 6.2
• Extracted source data from SQL Server, Oracle, XML and flat files and loaded to a relational Teradata warehouse and flat files.
• Implemented Aggregator, Sorter, Router, Filter, Joiner, Expression, Lookup, Update Strategy, Union and Sequence Generator transformations
• Used Shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters
• Used Debugger to test the mapping and fixed the bugs
• Used the Workflow Manager to create workflows, worklets and tasks
• Implemented Pipeline Partitioning concepts like hash-key, round robin, key-range, pass-through techniques in mapping transformations
• Involved in Performance Tuning of targets, sources, mappings, and sessions
• Created post-session and pre-session shell scripts and mail-notifications
• Used pmcmd and pmrep server in Unix environment
• Used SQL Server's Query Analyzer to optimize query performance by viewing query execution plan
• Documented Informatica mappings, design and validation rules
• Got knowledge on Facet.

Environment: Informatica Power Center 6.2, Oracle 8.2, MS SQL Server 2000, Teradata V2R4, XML, SQL*Plus, PL/SQL, Toad 8.1, SQL Server Query Analyzer, Windows 2000

Confidential, HOUSTON, TEXAS July'03-Aug'04
Informatica Developer

• Wrote documentation to describe program development, logic, coding, testing, changes and corrections to build Monthly Data mart and Bank Card Services Data Warehouse.
• Extracted source data from SQL Server, Oracle, XML and flat files of customer responses and loaded to a relational Teradata warehouse and flat files. The data was extracted and written to Teradata using MLoads and FLoads.
• Implemented Slowly Changing Dimension methodology including Type 1, Type 2 changes to keep track of historical data.
• Implemented Aggregator, Sorter, Router, Filter, Joiner, Expression, Lookup, Update Strategy, Union and Sequence Generator transformations.
• Used Debugger to test the mapping and fixed the bugs.
• Used the Workflow Manager to create workflows, Worklets and tasks.
• Involved in Performance Tuning of targets, sources, mappings, and sessions.
• Created post-session and pre-session shell scripts and mail-notifications.
• Used pmcmd and pmrep commands in UNIX environment.
• Developed PL/SQL aggregation programs and stored procedures that BO queries can use. Developed, created and updated of queries, DTS packages, views and stored procedures (TSQL, Transact-SQL, Transact SQL) in SQL Server 2000/2005.
• Worked with Dynamic SQL Statements,
• Worked closely with DBA in performance tuning of queries using ANALYZE Tables and SQL Trace.
• Developed Test Cases for Unit, Integration and System testing and provided solutions for Test Reports.

Environment: Informatica PowerCenter 6.2, Teradata V2R4, Oracle 8i, Business Objects 5, MS SQL Server 2000, XML, SQL*Plus, PL/SQL, Toad 8.1, Unix K-shell scripts, Perl scripts, SQL Server Query Analyzer, MS Visio 2002, HP-UX 10x, Windows 2000, QA Testing.

Confidential, ATLANTA Jan'02-May'03
Informatica/BO Developer

• Analyzed business requirements and translated them into technical specifications for developing ETL procedures that confirm to the Enterprise standards while maintaining consistency across all applications and systems.
• Extracted source data from SQL Server, Oracle, XML and flat files of customer responses and loaded to a relational Teradata warehouse and flat files. The data was extracted and written to Teradata using MLoads and FLoads.
• Involved in full project life cycle implementation (requirement gathering to production)
• Prepared the following business/technical writing of requirements, design templates, development standards document and detailed design documents.
• Involved in extensive testing of universes and reports during version migration of Business Objects
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc
• Extensively used Designer to design various universes for different business groups.
• Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Involved in report bursting using Broadcast agent server
• Implemented row and object level security in Business Objects supervisor module.
• Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.
• Responsible for managing the Business Objects repository.

Environment: Business Objects 5i, Broadcast agent server, Business Objects, WebI, Mainframe, Info View, Visual Basic 6.0, DB2 v6, Oracle 8i, Windows NT.

Confidential, DHAKA, BANGLADESH June'01-Dec'01
Oracle PL/SQL Developer
Responsibilities:

• Instrumental in designing the database with the help of Entity Relationship diagrams and models.
• Participated in design and development of all the tables, views in Oracle.
• Connected to Remote databases using DB Links and pulled required data.
• Wrote complex SQLs to develop various database queries to monitor data flow.
• Wrote PL/SQL stored procedures/functions to build business rules and calculating interest amount taking into account amount withstanding in loans etc and also created critical reports.
• Developed database triggers in order to enforce complicated business logic and integrity constraints and to enhance data security at database level.
• Instrumental in requesting required indexes, sequences, constraints and snapshots.
• Implemented Oracle performance tuning to load the data using SQL*Loader.
• Conducted unit testing and participated in system integration testing.
• Exception handling and Cursor management in PL/SQL.
• Prepared a complex set of business reports using Forms Builder and Report Builder.