SUMMARY

• 8 years of overall experience in the Information Technology Industry
• 6 years of experience in data warehousing including use of various ETL tools Informatica, Abinitio.
• 4 years of data modeling experience
• Extensive knowledge with dimensional data modeling, star schema/snowflakes schema, fact and dimension tables and process mapping using the top - down and bottom-up approach.
• Extensive work with PL/SQL, performance tuning of Oracle SQL plan, Oracle partitioning, various indexes and join types
• Experience in working with COBOL files, EDI, XML, and Flat Files
• Proficient working with Unix/Linux environments and writing UNIX shell scripts.
• Strong skills in data analysis, data requirement analysis and data mapping for ETL processes
• Ability to prioritize and execute tasks in a high pressure environment
• Experience in mentoring and providing knowledge transfer to team members, support teams and customers.
• Reliable, proactive, responsible, hard working and good team player

TECHNICAL SKILLS

• ETL Tools: Informatica Power Center 9.0.1/8.x/7.x/6.x, SSIS packages
• Databases: MS SQL Server 2005/2008, Oracle 8i/9i /10g, MS Access
• Client Side Skills: SQL, PL/SQL, UNIX shell scripting, Java, HTML, XML, C, C
• Web Servers: IIS v5.0/6.0, Apache Tomcat
• OS: Windows 2000/NT, UNIX, Red Hat Linux
• Version Control: WinCVS 1.3
• Tools: Erwin 4.1, Toad, Rational Rose, MS Visio, Tidal, Autosys, Drupal CMS, Sitebuilder.com CMS .

PROFESSIONAL EXPERIENCE

Informatica Developer

Environment: Informatica PowerCenter 8.6/ 9.0.1, Oracle 10g and 11g, PL/SQL, SQL Server, TOAD, Unix, Linux Box, Microsoft SQL Server 2008 Integration Services Management Studio, Business Intelligence Development Studio

Description :

Capital District Physicians Health Plan CDPHP is a not-for-profit individual practice association IPA model health insurance organization HMO . CDPHP is guided by its valued physician base and has evolved into an award winning health benefits provider offering a variety of commercial and government-sponsored planes to the diverse communities it serves.

Responsibilities :

• Implemented various projects/interfaces to production, like Shared Health Product, ORS, Datametrix, MV3, MV25, E Comm. Provider and Accumulator Claims warehouse built, CAE 4.61, CAE 5.01 Upgrade.
• Worked on various defects and production defects/issues as production support assistance for Warehouse, ARE and DI processes.
• Worked with the Enterprise, Application and ETL Architects, Data Modeler and Data Analysts to create efficient, flexible solutions in various Projects using ETL tools like Informatica, SSIS.
• Resolved the daily claims balancing report issue, by updating the existing stored procedure.
• Created, updated and code reviewed the UNIX scripts for the interface feeds worked on.
• Helped archive the preexisting interface files and hence resolve space issues on the Dev and Qual UNIX box.
• Gained extensive knowledge of the Microsoft provided tool by successfully completing the Training session for Microsoft SQL Server 2008 Integration Services, and implemented it in strategic projects.
• Extensively worked on the warehouse and sandbox testing during the Informatica upgrade to 9.0.1.
• Performed and abided by various responsibilities given such as validating the production results, perform code reviews, performance tune existing codes and others.

Tuned the mappings to perform better using different logics and checking the Cache to provide maximum efficiency and performance.

• Provided support for analytical inquiries for the Business and Enterprise Quality Management teams, and actively participated in support for END to END testing through the entire development processes.

Confidential

PL/SQL-Informatica Developer

Environment : Informatica Powercenter 9.0.1, Oracle 10g, Pl/SQL, TOAD, WINCVS, Unix, Linux Box, Tidal Scheduling tool

Description :

Tufts Health Plan THP is a not-for-profit health maintenance organization committed to providing a comprehensive array of services to meet the needs of communities. Enterprise Data warehouse is ETL Architect / design group, which is responsible for catering to the needs of all ETL requirements. The Pharmacy Informatica Rewrite Project primarily involved enhancements and creation of already existing PL/SQL code logic into Informatica.

Responsibilities:

• Involved in identifying dimensions and facts to create enterprise data warehouse and model.
• Worked in a team for supporting and introducing Informatica into SDLC project development environment at Tufts.
• Converted the already existing PL/SQL extracts and procedures to Informatica.
• Built new logic and designs in mapping to help work the existing PL/SQL logic and rebuilt the entire process model in Informatica.
• Developed complex procedures, functions, packages, triggers, snapshots.
• Created medium to complex PL/SQL stored procedures for integration with Informatica using Oracle 10g.
• Used procedures and triggers to catch and handle exceptions at database level.
• Extracted and loaded data from flat files and Oracle sources to Oracle database using Informatica mappings.
• Created mappings using various transformations like update strategy, lookup, stored procedure, router, filter, JAVA, SQL, sequence generator, joiner, aggregate, and expression transformations in extracting data in compliance with the business logic developed.
• Developed complex mappings also involving SCD Type-I, Type-II and Type III mappings in Informatica to load the data from various sources
• Data extraction mappings were developed in Informatica between source systems to ODS to Dimension data source.
• Worked in extensively testing and performance tuning of the mapping and logic. Created and worked on the unit test cases using Toad.
• Worked extensively in warehouse testing, sandbox testing, folder layouts and development process analysis during the Informatica 9.0.1 installation.
• Performance tuning of Oracle queries using partitioning, various indexes and join types.
• Tuned the mappings to perform better using different logics and checking the Cache to provide maximum efficiency and performance.
• Helped and guided other team members at THP through the entire development process.

Confidential

Informatica Developer/ Consultant

Environment: Informatica Powercenter 8.6, Oracle 10g and 11g, PL/SQL, SQL Server, TOAD, Unix Keon Environment, Control M Scheduling tool.

Description: Source InfoTech is a global IT company which has a goal to provide quality and cost effective software solutions. Its design and development methodologies and processes are unmatched in the industry which has resulted in customer satisfaction over the years and repeat business from various clients. Our strengths include financial software, custom component development, framework development to serve as ground work for various projects, object oriented methodologies which results in a high degree of code reuse, etc. Our customers are leading companies in Finance, Health and Retail industry.

Responsibilities :

• Involved in Analysis, Requirements Gathering and documenting Functional Technical specifications for various In-House projects.
• Data Quality Analysis to determine cleansing requirements and focused on data mapping between ODS, staging tables and data warehouses/data marts.
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica power center.
• Extensively used Informatica to load data from fixed width and delimited Flat files.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor, also imported and created Source Definitions using Source Analyzer and Target Definitions using Warehouse Designer.
• Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate, Java and Expression transformations in extracting data in compliance with the business logic developed.
• Worked with heterogeneous sources from channels like Oracle, SQL Server and flat files
• Created reusable transformations and mapplets in the designer using transformation developer and mapplets designer tools.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs. Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session to check the progress of data load.
• Involved in performance tuning the ETL processes. Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Documented data conversion, integration, load and verification specifications.

Confidential

Database Developer

Environment: Sitebuilder.com/CMS Content Management System, HTML, JDBC, SDLC, UML, MS PowerPoint, MS Access, MS Visio, SQL server 2005.

Description: The Higher Education Opportunity Program HEOP is a New York State funded program designed to provide broad and varied educational instruction to capable students who, due to limited academic and financial resources, might otherwise not have the opportunity to attend NYU-Poly. HEOP's goal is to retain and graduate students who are traditionally under-represented in the fields of engineering, technology, and science. NYU has established itself as the first global network university, with a comprehensive liberal arts campus in Abu Dhabi the first to be operated abroad by a major U.S. research university and other sites for study and research at different locations in world.

Responsibilities:

• Analyzed the system, architecture and business flow in order to define the requirement.
• Involved in the requirement definition and analysis in support of data warehousing efforts.
• Redesigned and monitored website for NYU opportunity programs to its current state using Content Management System CMS Service, Sitebuilder.com.
• Developed database schemas, generated required reports as needed to support user and system needs of the academic, administrative, and research functions of the college on MS Access 2007 and SQL.
• Coordinated in setting up the development, test, production and contingency environment
• Designed, developed, managed database star schema, with various hierarchical and lookup tables
• Involved in the performance tuning and extensive User acceptance testing of the Web Portal including the individual objects on the developed pages.
• Developed training materials, desk levels and development process documentation for deployment of the Portal and reports.
• Received user approval after successful deployment of the Web Portal.

Confidential

Informatica Developer

Environment: Informatica Power Center 8.1.2, Oracle 9i/10g, Autosys, Erwin 4.5, MS PowerPoint, MS Visio, TOAD 9.0, PL/SQL, UNIX, SQL server 2005

Description: Source InfoTech is a global IT company which has a goal to provide quality and cost effective software solutions. Its design and development methodologies and processes are unmatched in the industry which has resulted in customer satisfaction over the years and repeat business from various clients. Our strengths include financial software, custom component development, framework development to serve as ground work for various projects, object oriented methodologies which results in a high degree of code reuse, etc. Our customers are leading companies in Finance, Health and Retail industry.

Responsibilities :

Full Project Life Cycle Experience

• Requirement analysis, gathering business scope and technical requirements
• Instrumental in logical and physical data modeling
• Associated in design of Informatica Architecture for development, integration and system test environments
• Associated with design and development of around 50 mappings
• In depth querying and business rule application through SQL and PL/SQL
• Optimized the performance of the Informatica mappings
• Developed Unix shell scripts to automate certain features of the software
• Involved in creating queries, formatting results and sharing them within the enterprise
• Responsible for supporting production, test and development environments
• Coordinating with business users during User Acceptance Testing and System Testing
• Responsible for code migration and promotion to different environments like development, integration and production

Confidential

Software Developer/Trainee

Environment: HTML, Javascript, JDBC, Servlet, JSP, NetBeans 6.0, SDLC, UML, Oracle 9i/10g, Erwin, MS PowerPoint, MS Visio, PL/SQL, UNIX, SQL server 2005

Description: Universal Informatics offers opportunity to Engineering students to do Industrial Training with projects in areas various latest technologies. Third year/Final year students of B.E/B.Tech are eligible for this program. The projects will be on various platforms.

Responsibilities :

• Actively involved in gathering requirements from Business Users, and converting them into system requirement specifications and creating detailed use-cases and design documents
• Designed and developed a module called Online Share Portfolio Management for MoneyControl.com
• Designed the web portal to manage customer's portfolio of Stocks and Mutual funds which is currently being used by the company.
• Designed, developed, and managed the workflow processes to reflect business requirements with several adapters, exceptions and rules
• Was involved in data modeling. Designed dataflow using UML.
• Coordinated in setting up the development, test, production and contingency environment
• Designed, developed, managed database star schema, with various hierarchical and lookup tables
• Developed and maintained complex stored procedures
• Involved in setting up of application server clustered environment
• Underwent training in Standard Software Process in implementing CMM level 5 in an enterprise organization
• References Available Upon Request