SUMMARY:

• 11+ years of professional work experience in analysis and design of software solutions using data warehousing and client - server technologies
• 6+ years of experience in ETL technologies using Informatica PowerCenter 7.x, 8.x, Power Exchange, Constellar (Data Mirror)
• 2+ years of experience in managing professional developers and work-plans in large scale IT implementation projects
• Deep knowledge and expert level proficiency in
• Complex data conversion techniques for flat files, XML/XSDs, VSAM, DB2 to load in a data warehouses
• Oracle,DB2, and Sybase stored procedures, functions, triggers and packages
• Performance tuning of ETL Scripts and queries for Data Warehouse and OLTP databases
• Business Intelligence tools like Brio/Hyperion Portal, Hyperion/Brio Designer and Brio Explorer
• Developing utilities on the fly to automate tasks using Shell Scripts on Unix systems
• Distributed applications development, object oriented programming, client server applications using Microsoft technologies
• Extensive experience in integration & building of IT systems for Confidential Organizations
• Learning new technologies to bring in a solution to a business requirement

TECHNICAL SKILLS:

Microsoft Technologies: VB 6.0, VB.NET,COM/DCOM, ASP, ADO.NET,C#

Component/Interface Technologies: Open Client C (DB Library)

Business Intelligence Tools: Brio Query 6.2/8.0, Brio Insight 8.X, Brio Portal 7.0, Brio Designer 8.x, Brio Explorer, SQRIBE SQR 2.5

Languages: C, Java, HTML, JavaScript, APT 5.22 for Sybase, Flash 5.0, Dream Weaver

Databases: Sybase ASE 11.5/11.9.2 , 12.0,12.5, MS-SQL 7.0/2000, Oracle 8i

Data Warehousing/ETL: OLAP using MS-SQL 2000, Constellar 3.6/3.7, Informatica 6.1, 7.1, 8.1,8.5.1, 8.6.1 Powerexchange, 8.1, 8.5, 8.6

Operating Systems: Solaris 2.5/2.8, Linux, HP-UX 10.2, MS-DOS, WINDOWS 2000/NT/9x/XP

Source code Controls: PVCS, CVS, VSS

PROFESSIONAL EXPERIENCE:

Confidential (New york )

Sr. ETL Developer/Lead Developer

Responsibilities:

• Code Informatica mappings to capture XML data feeds using WSDL from the rating agencies and use them for asset calculations. Write informatica code to extract data from various text files and aggregate data for asset valuations.
• Code core reusable functions in Informatica like maplets, worklets, and functions. Develop design documents and write ETL code for to capture the type 2 slowly-changing-dimensions and aggregate data in fact-tables as per the granularity of the Facts
• Write UNIX scripts to process flat files for data profiling. Analyze data using the Talend open source data profiler for redundancy, dependency analysis.
• Validate, filter and standardize the data feeds (text, XML) from upstream systems, third party vendors for investment valuations.
• Participate in data analysis for the classification of new set of data, contribute to analysis for specific investment calculations and interact with business to implement the business rules using various combinations of technologies like C code, Unix shell scripts, Informatica ETL architecture
• Capture data and business exceptions during a daily computation process, and present it to business and operations teams for analysis
• Learn new technologies to provide technical solutions and customize the solution using combination of technologies to implement business requirements
• Work independently as well as manage work stream of 4 team members during the various phases of the project
• Prepare environment and server setup and follow-up with the application DBA’s and database DBA’s
• Perform End-to-end testing of the product to perform intra team string tests and inter team handshake between the code components
• Coordinate the code issues to the respective teams across various geographies and rerun the code components
• Create workflows in autosys to combine processes running in different technologies run seamlessly as one single process flow

Environment: DB2 8, 9, SQL,, lnformatica 8.6.1 power center, Workflow manager, workflow monitor, designer, repository manager, Autosys, Talend Data Profiler, C programming, Unix shell scripts

Confidential (New York)

Lead Developer/Team Lead

Responsibilities:

• Architect and code ETL and database components. Architect and design VSAM, mainframe components in Power exchange / informatica
• Code core reusable functions in Informatica like maplets, worklets, and functions. Develop design documents and write ETL code for type 2 slowly-changing-dimensions and fact-tables
• Create PowerExchange data maps to extract data from the Cobol, Mainframe files and DB2 sources. Extract data from various legacy source types such as KSDS, Sequential files and GDG files. Convert complex data structures and normalize data for array datatypes in Cobol sources
• Design ETL jobs tracking processes to maintain audit trail of daily scheduled jobs
• Contribute actively in finalizing business requirement and report design optimization
• Research and implement 3rd party software (e.g. Bugzilla, CVS) for code testing and bug management
• Participate in DB management as Oracle DBA e.g. configure database for 3rd party users in a distributed environment, deploy data models and manage access levels. Deploy data objects and tables using ERWIN generated data model
• Maintain and track deliverables from a project plan perspective, and regularly coordinate with business and project managers to meet the deadlines
• Manage a team of 3 developers on multiple work streams, implementation of ETL components, and production support
• Manage Informatica server and repository through admin console and deploy code across different environments
• Architect Purge and archival strategy for the large transactional tables. Design/architect staging schema to present the data to business for approval
• Organize team meetings and coaching sessions to introduce new versions of Informatica to the project team. Regularly interacted with Informatica to resolve technical issues. Some technical suggestions lead to product enhancement for Informatica

Environment: Oracle 9i, PL/SQL, ORACLE 10g, SQL Server 2000, Sybase12.0, Informatica 8.1.1,8.5.1 & 8.6.1 power center, Workflow manager, workflow monitor, designer, repository manager, Powerexchange 8.1, 8.5, 8.6

Confidential (Boston)

Senior ETL/Database Developer

Responsibilities:

• Designing the over all ETL/Database Architecture
• Research the data on the various source systems
• Contributed in design of a Datawarehouse tables using ERWIN
• Writing the ETL interfaces in Informatica to gather data from nearly 20 different source systems that receive data in flat files, oracle, excel, SQL databases
• Performance-tuning and fine-tuning of the ETL Processes and queries
• Writing the ETL Design Spec for each of the 20 different system and participate in mapping the source and target systems
• Unit testing the data for the ETL Processes designed
• Designing the reusable transformations, mapplets and workflows to make the design generic across the system
• Design the ETL jobs tracking processes to maintain the audit trail of the daily scheduled jobs
• Design and code the interface to display data to the business users before the actual data load in new system, using the VB interface.
• Interface and liaison with the data architects, business users and project manager to meet the project deadlines

Environment: Oracle 9i, PL/SQL, ORACLE 10g, SQL Server 2000, Sybase12.0, Informatica 7.1 power center, Workflow manager, workflow monitor, designer, repository manager, V.B 6.0

Confidential (Boston)

Senior Developer

Responsibilities:

• Co-coordinating with Business Analysts, gathering user requirement, designing technical and functional specifications and Management reporting module of the application
• Create & Maintain logical and physical enterprise data warehouse schemas using ER-Win
• Identify the underlying tables and business rules by forward and reverse engineering using ERWIN
• Provide data extracts in XML, CSV, flat-files and PDF’s based on the requirement and to generate the data feeds for the reconciliation in the other existing systems
• Developed several complex reports (various features used include multiple groupings, drilldowns, parameter fields, formulas and conditional formatting) using brio reports and brio portal
• Analyzed the source system and identified the candidate sources
• Populated data in the downstream systems, writing mappings, workflows and mapplets to extract data from the upstream systems, understand the business logic from Converge-E and implement in the for the reporting module
• Interface and liaison with the business analysts and the end-users
• Interface and liaison with the project manager to meet up the project deadlines

Environment: Hyperion Brio SQR 8.2, XML, Oracle 9i PL/SQL, Windows 2000 Informatica 6.1

Confidential

Sr. ETL Developer

Responsibilities:

• Involved in project as an assistant team lead
• Responsible for Software requirement specifications, Quality Plan, Project management plan, Role definition document, Software Configuration management, document based on the vision and scope of the project
• Designed database tables and object to store decision supporting data received from the branches in 53 EMEA countries
• Create data mappings in the data dictionary, write data mirror interfaces for header, trailer and details for each flat files received
• Developed Stored Procedures using PL/SQL for Oracle 8i database.
• Conduct project status meets with the clients, categorizing the requirements from the clients and assigning them to the team members, liaison between the client and the team
• Implement data integrity checks for incoming feeds received from systems in 53 countries, using the Constellar interfaces and Oracle stored procedures
• Conducted sessions on Unix & Shell scripting to ensure the knowledge sharing in the group
• Communicate to the PM on the status of the project deliverables, issues, risks and/or changes

Environment: Constellar/Data Mirror 3.6/3.7, Oracle 9i, UNIX, VB.NET, Visio

Confidential

Sr. Developer

Responsibilities:

• Involved in the project as assisting technical lead for the conversion of code components from code base to Sybase and conversion of DB library calls to the CT library equivalents
• Responsible for re-engineering of code components of CodeBase to the Sybase equivalents. Understand the underlying business logic of the system and design the database schema using Sybase
• Responsible for code re-engineering of the existing C programs and wrapper classes using the DB Library to the equivalent Client Library calls
• Responsible to liaison with the client for out lining the coding guidelines and procedures
• Responsible for developing the migration guidelines for SQR scripts and Shell scripts
• Responsible in troubleshooting the code of the team members and support them in meeting their commitments
• Monitor the quality of deliverables of the team members
• Resolve plan problems and conflicts, escalate when necessary
• Ensure acceptable processes, methodologies and tools are defined and used
• Responsible for reporting to the project leader for issues, risks and / or changes

Environment: Brio SQR 8.2, Brio Insight, Brio Explorer, Brio Designer, C, C++, Sybase 12.5, Solaris 2.8, Visio, Codebase

Confidential

Senior Developer/Module Lead

Responsibilities:

• Improve the security module of the whole applicatio n by hiding information across data transmission
• Develop the migration guidelines and a wrapper to encrypt passwords in SQR
• Migrate C, Shell scripts, SQR and Sybase data objects to the new system
• Write Makefiles for C/C++ codes and software deployment as per UDEEG Standards
• Convert the Non-ANSII, 32 bit code in C/C++ to ANSII compliant code, and compile the same on the 64 bit systems
• Develop the utilities tools to automate redundant activities like searching of keywords, file transfer between servers and code repository

EnvironnentBrio SQR 8.2, C, C++, Solaris 2.8 SYBASE 11.0.3/12.5

Confidential

Senior Developer

Responsibilities:

• Extensively involved in System Study & Business Requirements Analysis.
• Translated business requirements into data mart design.
• Designed the STAR schemas (Facts and Dimensions).
• Responsible in Designing and development of Logical & Physical Data models using Erwin
• Involved in data Extraction and Transformation from Oracle, SQL Server, flat files and Loading to Oracle using Informatica.
• Writing COM/DCOM reusable code components for the VB UI
• Create VB UI and implement the business logic
• Worked on Informatica tool - Source Analyzer, Warehouse designer, Mapping Designer & Mapplet, and Transformations.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Conducted Knowledge hour sessions for the team members on, Unix, Sybase & Data Warehousing and select the resources with different skill-sets

Environment: VB 6.0, Oracle 8i, Windows NT, Sun Solaris 5.8, Informatica 7.2

Confidential

ETL/Database Developer

Responsibilities:

• Understanding underlying business logic of the system the functional experts in RBI
• Create data dictionaries, Constellar interfaces to insert data feed from the different banks at the closing of the day
• Create workflows and arrange the data loads for the different modules in sequence
• Create re-usable Constellar interfaces
• Participate in database design for the system to support the correct data deeds
• Performance testing and stress testing of the software

Environment: VB.6.0, Windows 2000, Oracle 8i, COBOL, AS 400, Constellar 3.6

Confidential

Programmer/Analyst

Responsibilities:

• Study the re-engineering efforts and prepare the software development and rollout plan. Ensure the rollout in phases to ensure the smooth phase-out of the existing system and switch over to the new system
• Writing stored procedures and re-designing database schema
• Creation/tuning of indexes and queries for better access on the data
• Moving Data from across systems using BCP and shell scripts
• Developing the activex controls using COM, DCOM
• Redesigning/developing the front-end in GUI using VB 6.0
• Writing shell scripts and utilities to handle code changes across the programs
• Testing the Front-end and backend
• Planning the installation for thin clients desktops in the warehouse at Thane/Dhapoda

Environment: VB 6.0, SYBASE 11.9.2, Brio SQR 8.2

Confidential

Programmer/Analyst

Responsibilities:

• Designed star schema fact and dimension tables using ERWIN to store decision supporting booking data
• Designed ETL modules using DTS in order to load data from flat file feeds and OLTP systems into the star schemas
• Designed and developed all client Business Reports and key performance indicator dashboards using Brio
• Designed and deployed the Web interface using the Microsoft pivot table component and ASP
• Developed Stored Procedures using T-SQL for MS-SQL and Sybase database.
• Involved in gathering User requirements, Requirements Analysis, Developed Class and Sequence diagrams, User Interaction screens, Prototypes, Object and System Diagrams using UML.

Environment: MS-SQL 2000, Sybase, Asp, OLAP on MS-SQL 2000, DTS

Confidential

Programmer/Analyst

Responsibilities:

• User requirements analyses and designing the process flows diagrams
• Develop and design databases and the database objects
• Develop and design user interface
• Writing shell scripts and utilities to integrate data with other online systems for the data reconciliation using BCP & ISQL.
• Developing the activex controls using COM, DCOM
• Suggesting changes in the inter-linked systems to handle the new system
• Testing the UI and the dataflow between the new system and other systems using manual testing tools

Environment: VB 6.0, Brio Report Builder, SYBASE 11.9.2, Brio SQR 6.2