SUMMARY

• C# .Net, C, C++, Vb.Net, HTML, SQL Server 2008, Oracle 10g, Essbase, UNIX shell scripting, DOS Batch file, Perl, Python, Java Scripting, TCL/TK, Windows 2008 Server/Windows 7, Red hat, Crystal Reports, Kamakura, Bancware, Banking, Insurance, Financial Telecommunication, GNU Debugger.

• Strong software design, development, analytical and problem solving skills with 7 Years of experience in Data Warehousing and application software development.
• Creating Complex Applications with special emphasis onDesign & development of Data Warehousing, Data Modeling, Relational Database Systems and implementing multi - tier web applications using DW and ETL tools.
• Has been involved in major Data warehousing projects as Designer. Has an excellent understanding of Data Warehousing Concepts. Expert in ETL strategies.
• Possess skills in teh use of Data Warehousing tools - Informatica PowerCenter 8.1/7.1/6.2/6.0/5.1/4.7., IBM Datastage and Essbase.
• Extensive experience with SQL server 2008 in writing highly complex queries and database functions like backing up and restoring.
• Has experience in Oracle back-end programming using PL/SQL. Has performed in a variety of roles including Designer, Project ETL Developer.
• Exceptional background in successfully implementing Risk Modeling infrastructure, Data warehousing and Report Generation Applications.
• Expert in Informatica Power Center, IBM Data stage, SQL Server 2008, Oracle, UNIX Shell scripting, C#, VB, HTML, Java scripting, Perl and C++.
• Sound knowledge of UNIX and extensively developed UNIX shell scripts
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into teh staging area and Design ETL processes dat span multiple projects
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups & Proven ability to implement technology based solutions for business problems
• Experienced in Tuning Informatica Mappings to identify and remove processing bottlenecks
• Automation and scheduling of UNIX shell scripts and Informatica sessions and batches
• Postproduction support, enhancements and performance tuning.
• Experienced at Creating TEMPeffective Test data and development thorough Unit test cases to ensure successful execution of teh data
• Strong analytical, problem-solving, organizational, communication, learning and team skill
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.
• Strong written and verbal communications. Interested in a challenging technical career in a Data warehousing environment.

PROFESSIONAL EXPERIENCE

.Net Developer

Confidential

Responsibilities:

• Detailed requirements gathering from teh business users.
• Work closely with Project lead/Manager, Architects, and Data Modelers to understand teh business process and functional requirements
• Responsible for design and development of ETL mappings Using Informatica.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Involved in dimension building of Essbase cubes.
• Analyzing teh requirements, system architecture, data modeling, business system design, decision support, design reviews.
• Involved in database designing and partitioning. Logical design of relational databases, performance tuning of OLAP.
• Developed SQL, stored procedures for implementing business rules and transformations
• Production and testing of batch file creation.
• Extensively did unit testing and Integration testing Job level and job sequential level
• Performed test case development and validation with business users.
• Involved in Controlling of Jobs using Control-M.
• Proficient knowledge in entire software development lifecycle.
• Familiar with Software development life cycle (SDLC) process.
• Promptly fixing production issues dat arises during production run.
• Adopted performance-tuning techniques to improve teh ETL process.
• Responsible for maintenance activities of teh application.

Economic Capital Modeling Automate Data Feeds

Confidential

Responsibilities:

• Involved in full requirement gathering from Business to understand teh Data inputs to teh DCC.
• Analyzed teh DCC’s data model to fit in teh ETL to load data into its input tables with proper link of surrogate keys.
• Analyzing and Designing ETL’s to match teh Sources to teh DCC database targets.
• Architecting teh ETL Framework for DCC.
• All teh jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets dat provides reusability in mappings
• Accomplished Full ETL development to map teh sources to teh DCC database.
• Performed unit testing, regression testing and System testing on teh ETL’s developed.

Kamakura and Bancware application implementation

Confidential

Responsibilities:

• Involved in full requirement gathering from Business for technical layout of teh application. Analyzing and translating end user requirements into database objects.
• Architecting teh total Test and Production environment to suite business needs and capacity.
• Database server designing to suite teh capacity of Complex simulation Model and input data loads.
• Automated data feeds using Informatica and Datastage.
• Developed Datastage Parallel jobs using various stages like Join, Merge, Funnel, Lookup, Sort, Transformer, Copy, Remove Duplicate, Filter, Peek, Column Generator, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems
• Extensively used Reject Link, Job Parameters, and Stage Variables in developing Datastage jobs
• Used teh Datastage Director to run, schedule, monitor, and test teh application on development, and to obtain teh performance statistics.
• Organized Security groups and assigning necessary permissions to teh users depending on their level of access.
• Responsible for total project development and support.
• Performed model level debugging on failures of Computations.
• Storages and memory capacity planning.
• Designing, development and testing of claims check reconciliation application.
• Production support, maintenance, issue resolution and escalation to other team on failures in Claims reconciliation application.

Data Portal And Report Generation Application Development

Confidential, San Jose CA

Responsibilities:

• Responsible for this full Application Development
• Involved in requirement gathering phase, LLD and HLD documentation.
• Performed extensive analysis on teh data sources, extraction strategy and target database designing and reporting.
• Developed teh application from teh scratch, by understanding teh System requirements.
• Learned teh third party database called Proligent which stores data in XML format. And learned to NI Test stand and its .NET API calls dat were used in teh Data portal application.
• Database designing, implementation of modules which does data extraction from Proligent database and loads into SQL database for faster and easy reporting.
• Developed ETL’s in Informatica to create a warehouse for data analysis.
• Fully automated teh reporting as Powerpoint presentation.
• Involved in test case development, unit testing, bug fixing and preparation of user guides.
• Involved in Deployment of teh application in Manufacturing environment, customer site and training teh users.

Optical Transponder Manufacturing Test Developments.

Confidential, San Jose CA

Responsibilities:

• At all test level, a test suite dat has 10 to 14 test scenarios for each components. As a team member, worked on test infrastructure development.
• Functional and Calibration test development, test scripts as package developed using Python, PyNMS(PyNMS has XML, SNMP support and Network tools) and MySQL as back-end database.
• Test suite for testing teh performance of teh Line and Client Interface of teh Optical transponders were developed and deployed in manufacturing floor for production.
• Automated teh Product rebranding using Python and developed XML parsers for teh rebranding updating teh data-warehouse.
• Involved in writing Testbed calibration scripts and automating teh test bed calibration for all teh test levels and product lines.
• In teh entire test application developed each step of execution is written to SQL server databases/tables.
• Done extensive programing in updating multiple SQL database tables using complex queries.
• Involved in preparing teh test plan /test cases for Firewall, QOS and SIP Proxy modules.
• Involved in development of TCL wrapper function for DUT communication.
• Involved in enhancement of VoIP Test suites to support our project specific features using TCL/TK scripting.
• Involved in developing Test scripts for Firewall, QOS, NAT and SIP Proxy modules
• Involved in integration of DUT communication wrapper functions to teh existing test suites.
• Written wrapper function using teh VPM API’s to test teh VPM features.
• Involved in teh test cases identification, preparation of test procedures and test plans.
• Test automation using teh test tools.
• Involved in teh verification of all teh VPM features using Hardware and Software tools.
• Partitioning and Programming teh Flash memory in Gateway with teh halp of JTAG Device.
• Developed Automation framework which has around 200 test scripts with TCL/TK using TCL API of test equipments line SPIRENT AX4000, GLCOM, TELTONE, GIPS and CDRouter.

Confidential

Team Member

Responsibilities:

• Design and Development of Antenna Interface Standard Group Module.
• Involved in teh design and development of LDAP Client for teh MCU.
• Involved in teh design of schemas for teh LDAP Server.
• Involved in unit level testing of teh modules developed.
• Involved in teh Requirement Analysis, Design and development of Browser Based Configuration (BBC) for teh various features of teh Home Gateway. BBC includes HTML, client side Java Scripting and C programming to configure teh Gateway.
• Involved in teh implementation of BBC for teh features Port filtering, IP filtering, MAC filtering, System log, WAN/LAN port configuration, Speed Dial entries, calls services and Advanced features.
• Teh system settings are stored as a Flat file inside teh Gateway.
• Developed teh Low Level Design document for configuration management.
• Prepared Test Plans and designed framework for various features in teh VoIP gateway.
• Bug Fixing and enhancement for teh scripts developed.

Environment: C, HTML, Java scripting, Flat file database and uClinux.

TECHNICAL SKILLS

Risk Modeling: Sungard Bancware ALM, Kamakura, Towers WatsonIgloo Enterprise, Igloo DCC

ETL Tools: Informatica Power Center8.6/8.1/7.1/6.2/6.0/5.1/4.7,IBM Datastage

Database: MS SQL Server 2005/2008, Oracle 10g/9i/8i, Essbase,MS Access, MySQL, Proligent.

Languages: C# .Net, C, C++, Vb.Net, HTML

Scripting: UNIX shell scripting, DOS Batch file, Perl, Python, Java

Operating Systems: Windows 2008 Server/Windows 7, XP, NT, 2000

Reporting Tools: Crystal Reports

Charting tools: .Net Charting tool and Infragistics toolkit, Dundas

Other Tools: Control-M, Microsoft Office, Star Team, Cognos, CVS,Perforce, Bugzilla. PL/SQL developer.

Debuggers: GNU Debugger.

Methodologies: Software Development Life Cycle (SDLC), Agile and Waterfall

Industries: Banking/Insurance/Financial, Telecommunication.