SUMMARY:

• A top - performing and award winning Programmer Analyst with International experience and strong RDBMS skills.
• Four years of SDLC experience on large multi-year projects providing expert business analysis, requirements gathering, design, and development of code in Big Data environments.
• Proven expertise in Data Migration and Integration from various sources using Informatica ETL tools. Acknowledged by Confidential for consistent performance, excellent execution, and a high degree of customer satisfaction on the Confidential Data Warehouse project which was selected as Project of the Year in the Confidential Group.
• Highly developed team leadership and problem resolution skills always delivering within project timelines and budget.

AREAS OF EXPERTISE:

• Software Development
• BRD, FRD, FSD
• Project Leadership
• RDBMS
• Agile
• Sybase
• Database Architecture
• Performance Tuning
• Business Requirements
• Data Migration and Integration
• Unit Testing
• Analytics
• SQL
• Data Warehouse
• Informatica ETL tools
• SDLC
• SSRS
• Big Data

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5.1

Business Intelligence: SAP Crystal Reports 2011, Crystal Reports XI Release 2, SQL Reporting Services 2008, Business Intelligence Development Studio

Databases: Sybase ASE, MS SQL Server 2005/ 2008, MongoDB (JSON)

Testing Tools: Quality Centre ALM, JIRA

Operating System: Windows 7, UNIX

SSH Tools: Filezilla, Putty, WinScp

Languages: C, C++, SQL, Sybase, SQL, T-Sql, Perl

Scripting tool: UNIX Shell Script

Scheduling Tools: CA Scheduler

Configuration Tools: Serena, Tortoise SVN

PROFESSIONAL EXPERIENCE:

Confidential

Programmer Analyst

Responsibilities:

• Applied best practices of SDLC to each assigned projects to ensure that the project ran smoothly, to improve code quality, and to meet assigned deadlines.
• Involved in all phases project delivery including documentation, design, unit testing and defect fixing.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to master new technologies.
• Utilized SDLC best practices like refactoring to improve the non-functional attributes of the software, agile pair programming techniques to reduce defects, and comprehensive testing for code verification.
• Adeptly performed unit testing on all developed code.
• Prepared test cases using excellent command of Application Lifecycle Management tools.
• Strong performance resulted in being assigned a more major role as the project progressed.
• Completed all tasks on time by working closely with the clients, getting their feedback, and coordinating efforts with peers on the team.

Confidential

Responsibilities:

• Proven expertise in Extraction, Transformation, and Loading (ETL) using Informatica Power Center 9.5.1.
• Expert in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Experience in Data Migration & Integrating Data from various sources.
• Engaged in all phases of a multi-year Confidential Data Warehousing project including analysis, requirements gathering, design and development of code to control transactions of Confidential banks in the EMEA region.
• Acknowledged by Confidential for consistent performance, excellent execution, and a high degree of customer satisfaction on the Confidential project which was selected as Project of the Year in the Confidential Group.
• Key member of the Confidential team utilizing DBMS experience to designing ETL mappings to extract data using Informatica Power Center tools, configuring Workflows and Sessions, and loading data into the data warehouse.
• Functioned as the lead ETL developer and took the responsibility of maintaining all the relevant sources of data and ensuring that it is being stored properly.
• Optimized and tuned the data for better performance and efficiency by analyzing which tables provided an optimum solution and then performed database tuning to increase efficiency of mappings.
• Expertly addressed the requirement to fetch the daily data from various sources like relational and flat file sources from the AS400 and using the Informatica tool to transfer the data to OLTP system like SQL Server.
• Wrote Perl Tree script to automate Informatica Pre-Session, Post-Session tasks and running of the ETL workflows and used CA job scheduler for scheduling these tasks in production and UAT environments.

Confidential

Responsibilities:

• Strong RDBMS concepts and experience in creating tables, views, procedures, functions, triggers, maintaining and tuning Views, Stored Procedures, User Defined Functions and System Functions using SQL Server, T-SQL
• Excellent skills in retrieving/manipulating data by writing simple/ complex SQL Queries and optimizing SQL.
• Reporting experience with tools like Business Objects Crystal Reports XI and XI R2, SQL Server Reporting Services 2008.
• Expertly conducted requirements gathering and feasibility study of data to create physical and logical data models, designing tables and stored procedures from abstract data.
• Built comprehensive QnR (Report Query Schedule Reports) to run daily, weekly, monthly for Executives and Business Analysts.
• Adeptly migrated predefined Report from Crystal Reports XI Release 2 to SAP Crystal Reports 2011 building parameterized Crystal reports using tables, queries, and verified joins between them.
• Assumed leadership role in delivering a Business objects Migration project for Confidential acting as the POC for report migration tasks for this project and accelerated project delivery before any other group by single handedly delivered 60% of the team’s work.

Confidential

Responsibilities:

• Extensive experience in the documentation of business requirements and system functional specifications including BRD, FRD, and FSD.
• Selected by management to address critical project issues as the deadline approached and the project was delivered ahead of schedule and within budget guidelines and contained the expected data as per the Client requirements outlined in the FSD.
• Facilitated the delivery of a claims management project for Confidential Canada by improving the BRD and FSD for the developers and then developing the SSRS report despite being new to the project.
• Achieved a high level of customer satisfaction with the documentation work delivering 50 newly constructed SSRS reports to Confidential Canada before the deadline which gained appreciation from the client.