SUMMARY

• Overall 14 years of IT experience in software design and development in diverse and multi-faceted industries such as Banking, Financial Services, Healthcare, Manufacturing, Engineering Design, Automobile, Supply chain, Telecommunications, large-scale Government funded projects, International trading applications etc.
• Extensive hands on experience in Data Warehouse/BI. Having experience in Creating Repository, Source and Target Databases and developing Strategies for Extraction, Transformation and Loading ETL mechanism using Informatica and SSIS ETL tools.
• Extensive experience in design of star schema for very large data warehouses with Terabytes, oracle object oriented tables hierarchical database tables and partition tables.
• Handled multiple assignments and projects at the same.
• Experience in building complex data warehouse on Oracle DB and data load with Sql loader/SSIS/Informatica.
• Extensive experience in administration and developing ETL packages using SSIS and Informatica.
• Experience in design and creating XML database on Oracle. Implemented XML/XSD schema data
• Extensive experience in installation and configurations of Apache Tomcat, Websphere, Troux portal and SharePoint portal.
• Extensive Experience in Database Programming and Development using SQL Server, Oracle, MSSQL, MS Access and DB2.
• Extensive experience in data modeling and database design using ERWIN, VISIO and TOAD analytics.
• Solid experience in writing UNIX scripts for Informatica load process, SQL load control files, scheduling scripts and Oracle DB monitoring scripts.
• Comprehensive understanding of Oracle design and development tools. Extensive experience in using query optimization techniques and thorough understanding in Data Warehousing, Data mining, Data Modeling both logical and physical concepts. Experience in installation, upgrading, configuration and performance tuning as well as developing database applications in Oracle 11g/10g/9i/8i SQL Server 2000 using SQL, PL/SQL, Packages, Stored Procedures, Triggers Functions, Oracle Object Oriented based tables and Oracle Partition tables and automation.
• Developed various Informatica Mappings, Mapplets and Transformations for the data from various existing systems to the new system using informatica-Designer Power center designer .
• Developed SSIS packages to load data from various data sources like Oracle, DB2 MSSQL etc..
• Design and development of Reportnet, Impromptu Catalogs and Powerplay Transformer Models in various types of data models. Setting up Users, User roles, rules in Access manager to provide security for Cognos Applications
• Design and development Microstrategy reports on web as well as client.
• Design and development Troux8.0 models, BIRT reports on tip portal.
• Responsible for proving End users training, Worked effectively in independent and Part of a team
• Extensive experience in Sun One Directory Server, Microsoft Active Directory, IIS Web Server, Developer 2000, Unix Shell script, PL/SQL, Erwin, Oracle, SQL Server and Teradata under Windows NT/Unix platform. Strong technical exposure with good degree of competence in business systems.

Confidential

TECHNICAL SKILLS

• Languages: Java, SQL, PL/SQL, C,C , CGI with PERL, Unix Shell Script, JavaScript, T-SQL and PL/SQL, ABAP- 4, SAS 8.1, .net, ASP, Visual Basic, Java, J2EE EJB, jsp, jdbc, jms, servlets.. , XML, XSD, DDQ,JINI, COBOL,HTML,DHTML, MDL
• Operating Systems: Windows 98/NT/2000/Vista/windows7/2008, UNIX Sun Solaris , AIX, AS/400, OS/2, HP-UX 10 , DOS, Linux
• Messaging/Web services: MQ Series, SOAP, Restful
• Design Tools: ERWin4.X, Sybase Power Designer 6.1, Oracle Designer2000, Oracle, Designer6.0, Embarcadero ERWIN/Studio, ABC, Visio , Oracle Analytic Workspace Manager AWM , Balsamiq, TOAD Analytics
• ETL Tools: Informatica 9.1/8x/7x, Microsoft DTS, Oracle Warehouse Builder 2.0, Pure Integrate, Oracle Data Integrator ODI , SSIS, DM Express aggr , Sync sort Aggr , Data stageAbnitio
• Reporting Tools: Cognos 10.1.1/8.4, Microstrategy 9
• Data Base: Oracle 8i/9i/10g/11g, Teradata v2R4.1 , Ms-Sql Server 7.0/2008/2012, DB2, Ms-Access and Sybase11
• ERP: Oracle Financials 10.7sc GL, AR, AP, OE, and AOL , SAP
• GUI: Visual Basic 6.0/7, Developer/2000 Forms 4.5/5.0, Reports 3.0/2.5 , Java swing, Adobe Photoshop
• Other Tools: Toad, Reflection for mainframe, MS SharePoint10, Troux9.1, IBM Rational Clear case
• Web Servers: IIS, Apache,Web sphere
• Scheduleing: Control-M, Autosys, skybot
• Application servers: Weblogic, Websphere, MTS, Apache Tomcat

PROFESSIONAL EXPERIENCE

Cleared Secret Security clearance for federal projects

Confidential

Data warehouse Architect

• Responsible for entire architecture of CAF project. Created DW model for Credit management for corporate average fuel economy.
• Responsible for review and data integration of the Rulemaking, VOLPE,CM and Enforcement databases.
• Responsible to create star scheme type2 dimensions for CM and Rulemaking.
• Responsible for Alternative analysis Vendor evaluations for BI tools, ETL tools, Content management tools, data modeling and front end applications.
• Responsible for installation and configuration of Inormatica9.1, Cognos10, Oracle ODI Oracle relational to Oracle DW .
• Responsible for creating Informatica repository and setting up the users.
• Responsible for creating Informatica mappings using power center designer and pipe lines for multiple workflows for complicated Credit management application. Data flows from MS SQL to Oracle.
• Responsible for creating star schemas for PIC and internal data warehouse. Data flows from Oracle to MS SQL server.
• Used Toad analytics for Database design.
• Responsible for creating unix scripts for Informatica data load on Unix system.
• Responsible for creating ETL scripts, sqlploader scripts and control files to load fact tables .
• Designed and created portioned fact tables and automated the partition creations. The data is close to 5TB.
• Responsible for sdlc documentation and created a SharePoint folders for all the sdlc documentation.
• Used Skybot for scheduling the jobs.
• Create few workflows/Usecases using sharepoint10 and InfoPath forms for credit calculations for internal purpose.

Due to budget issue I was told to handle following additional responsibilities

• Responsible for creating Cognos reports for the Credit Management application for fuel economy.
• Responsible for creating package and models using Framework manager.
• Created Transformer model and Cognos cubes for PIC and internal system.
• Created Cognos training material and also trained the business users.
• Responsible for training different technologies for internal teams members.

Confidential

Senior Systems Analyst

• Responsible to design and development of IP Inpatient data and CSM Clinical drug mart Star schema type 2 datamarts on existing MSIS DWH.
• Responsible for Informatica installation and configuration.
• Responsible to create Informatica mappings for IP and CSM and created respective Unix scripts to execute the ETL process.
• Used Erwin for database design.
• Responsible for creating parameters file informatica load process on Unix.
• Responsible for creating partitioned fact tables and automation The DW size is close 132TB .. Did lot of query optimization and data load optimization etc
• Successfully implemented DM express aggregations for Inpatient and Long-term care data.
• Responsible for complete automation of the data warehouse with Informatica, DM express, sync sort etc..
• Responsible to run the jobs on Autosys.
• Used IBM Rational Clear case for repository integration and auto recovery purpose with versioning.
• Responsible for sdlc documentation for DD,FS,IP and SOPs for OMG guide.

Based on my previous experience, I was told to handle following additional responsibilities

• Responsible for installation and configuration of Cognos10 for MSIS project.
• Successfully implemented the aggregated data back to Mainframe system for claims data.
• Responsible to create Cognos reports and cubes including Cognos administration for MSIS application on Cognos 10.1.1.
• Responsible for design and development of Cognos Transformer models.
• Responsible for Cognos cubes refresh through mdl scripts on UNIX environment.
• Responsible for training different technologies for internal teams members.
• Responsible for internal website created using Sharepoint2010 and infopath 2010.

Confidential

Architect

• Responsible for defining standards and direction of the project.
• Integrated multiple databases to enterprise level database for transactional systems and DW model for this database.
• Responsible for install and configuration of Informatica 8.1
• Responsible for creating Informatica repository and users for DEAMS project.
• Designed and created star schema type 2 dimensions.
• Responsible to create Unix scripts for ETP process, sqlload control scripts and load process scripts, Informatica load scripts on Unix for pmcmd and parameters.
• Used Erwin for Database design.
• Responsible for install and configure SQL Server2010 databse. Responsible for SQL server DB backups and performance tuning.
• Responsible for complete DEAMS DW and Informatica development and administration.
• Used Autosys for scheduling and Clear case for integration and versioning , Usecase manager for tracking cases, Troux for EA portal and content management.

Additional responsibilities

• Involved in install and configuration of the IBM Cognos10.1.1.
• Created Cognos cubes DOL hardware,software, projects and related costs and maintenance.
• Created reports using Cognos and BIRT for DEAMS project along with Cognos team on Troux environment.
• Responsible for creating Informatica mappings and respective Unix scripts.
• Developed Dashboards, Data Collection, ETL, Reporting BIRT Cognos efforts for the EA repository.
• Development of JAVA servlet, XML, CSS, XSL, HTML, JavaScript, ASP, VBScript, HTML, Tomcat and MS IIS to provide secure thin-client web portals access.

Confidential

Senior Developer

• IMaster Fruit of the loom Russell Corporation styles and products integration application
• Defined and designed brand new datawarehouse with Object oriented tables. The system is a completely dynamic and hierarchal nature.

Responsibilities:

• Responsible to generate xml/xsd scmas with Oracle xqueries to load the data into object oriented tables into XMLDB with dynamic attribute generation.
• Responsible for the design of star schema dimensions and facts. This application defines to handle Fruit and Russell styles, colors and sizes with different segments and categories that are associated with itemnumbers.
• Created Microstrategy reports to meet business requirements. Train staff with new technologies and methodologies. Train business analyst to create reports with hierarchical based system and database tables.
• Created Unix scripts for sql loader and ETL process to handle styles.
• Created separate Informatica repository for Russell corp and user security.
• Create Informatica mapping for for data load from DB2,MS access, SQL databse into Oracle database.
• Responsible to create Cognos cubes for Russel as well as FOL data.
• Development security application for Fruit, Russell and VF using java struts.
• Responsible to create Cognos reports and cubes using Cognos and train users.

Confidential

Senior Developer

Responsibilities:

• Migrating SQL server datawarehouse databases into Oracle Data warehouse for VFT and FOL.
• Extensively used SSIS packages to load Russell data from MS SQL server and DB2 databases into Oracle DW.
• Responsible for 23 Russell Corp. MS SQL SERVER databases for migration.
• Installed and configured Ascential DataStage 7.5 for new Russel models for universities related data.
• Responsible to create star schema and used datastage to laod the data.
• Responsible to design consolidate old systems into new Oracle datawarehouse.
• Responsible for MQ series on DW side to get the messages from EDI systems to Unix AIX system. Responsible to migrate Business Objects reports into Cognos reports.
• Created new cubes for Russell Data.
• Responsible for both SSIS as well as datastage.

Confidential

Senior Developer

Designed new star schema database for perpetual inventory system that allows receiving inventory into the warehouse, tracking it, and shipping it to customers. It also has functions for managing the work in the warehouse, including wave generation processes and performance tracking.

Responsibilities:

• Used SSIS extensively for data load into FTL Oracle DW.
• Responsible for enhancement and transformation, auditing, segmentation and distribution of inventory data.
• Responsible to integrate the Russell and VFB data into existing schema.
• Responsible to drop unused or legacy systems from Fruit DW. Responsible for clean the data on integrated environment and train staff.
• Development of pkms customer interface using java struts.
• Created Cognos cube and reports to meet business user requirements.

Sourcing Fruit of the Loom Sourcing products data

Led system development infrastructure utilization, application upgrades and train staff. The system Stores information captured by the Internet Sourcing and Production System e-SPS , a New Generation Computing NGC product, into the Fruit of the Loom FTL 's data warehouse .

Responsibilities:

• Responsible for Review designs and delivery focused on discovery, standardization, metadata, schema design, logic, semantics, data ETL and cleansing.
• Designed DW start schema for VF datamarts
• Created Informatica mappings and work flows to load data from DB2 to Oracle and Access DB to Oracle DB and flat files from customer data to Oracle DW.
• Created the Unix scripts for execute the Informatica workflows and created sl scripts on Unix to load the data to fact tables.
• Provide formal and informal training and mentorship to Russel, VF and FTL technical team in development.
• Responsible to Implement Cognos reports project for both reports and cubes for the data warehouse access, data analysis, and basic reporting in the Sourcing Department.

Confidential

Senior Developer

Responsibilities:

• Responsible to migrate VFB operational data as well as retail data into Fruit of the Loom. Migrated and redesigned some database modules to get rid off old models. Provide project support, write documentation including requirements.
• Responsible to install and configuration of Inofrmatica7
• Reusability of current data for additional analyses.
• Responsible for migrating data load process from Abintitio to Informatica.
• Created mappings using Informatica and load process. Created cutom data load Unix scripys for Informatica
• Reviews object and data models and the metadata repository to structure the data for better management and quicker access.
• Responsible to conduct data cleansing to rid system off old, unused, or duplicate data. Provided guidance and training to less experienced analysts/programmers/ data architects.
• Responsible to create new star schemas for Finance, Legal and retail data and loaded into DW using Informatica.
• Responsible for creating Cognos reports and cubes. Responsible for the Cognos applications administration.

Confidential

Administrator/Sr. DW Analyst

Description: Working on Supply Chain Management projects IIMN, NAN SCVC and each application has reports, cubes, visulizer maps and KPIs Metrics Manager and aimed at building the Datawarehouse for GM.The data is feeding into Teradata from different sources including legacy flat files.

Responsibilities:

• Responsible for creating and managing of home ground ETL scripts.
• Installed and configured Informatica5
• Responsible to create reusable maplets and load doads.
• Migrated home ground etl process to Informatica
• Used ERWIN for data base design
• Created star schema for IIMN and NAN systems.
• Created 1 st star schema datamart for this company.
• Responsible for writing UNIX shell scripts for troubleshooting, backup process and scheduling.
• Responsible for build process for cubes on unix and windows written shell scripts in unix and windows batch files and macros

Confidential

Programmer /Analyst

Description: This was Client/Server Web based product designed to provide the Services Of ABN AMRO to different customers all over the world. This is having following modules: Entrada, Tradewizard, Registration and Trade community. It is aimed at users who are involved with the financing and risk-mitigation of import/export transactions and trade related matters. Programs are written in Servlets, JavaScript Client Side and Java applets.

Migration:

This product is completely migrated to ASP, Visual Basic, ADO objects and MTS with some ATL components. I was responsible for all migrations from Java to the ASP, Visual Basic environment under MS SQL server. This version is only applicable to Canada Bank only.

Responsibilities:

Implemented Entrada, Trade wizard, Registration and Trade community, Risk rating Tool, back office modules country, Currency, user authorization matrix, Lookups country and city and callback Requests , Handled sessions for each connection, calculated connection time Statistics and Calculated page statistics

Environment: Java JDK1.1.6 , Servlets, JavaScript Client Side , Dynamic HTML and Java applets, Windows NT v4.0 , WebSphere, Oracle v8.05 , Seagate Crystal Reports, ASP, Visual Basic, MTS, IIS.