4 year of Total IT experience in Cognizant. Working knowledge in SQL Server 2008, Sybase. Experience in Creating Tables, Stored Procedures, Triggers, Indexes, Views, User defined function and Tables, Schemas for large database systems. Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases. Experience with Informatica (ETL Tool) for Data Extraction, Transformation and Loading using Informatica 9.5.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager. Reporting experience with tools like Business Objects Crystal Reports XI and XI R2, SQL Server Reporting Services 2008. Wide experience in reengineering concepts and tools along with End-to-End understanding of Business Concepts. Experience in Scheduling tools like CA Scheduler for automating and scheduling jobs run. Strong communication skills and demonstrated ability to work effectively with business users. Experience with AGILE Methodologies.
Cognizant Technology SolutionsJuly 2011 to July 2015Programmer Analyst Kolkata, India
Applied best practices of software development while staying abreast of advances in the practice.
JP Morgan Chase International Private BankJuly 2014 to July 2015Geneva, Switzerland
Project Name: JPMC Paris SCV Technology: SYBASE ASE V12.5, Informatica Power Center 9.5.1, (Designer, Repository Manager, Workflow Manager), Unix, Perl tree, Filezilla, Putty Creation of five feeds on CDG platform to be sent containing all information required by the French regulators (ACP/FGD) to be able to reimburse the clients in case of Bankruptcy.
The customer related information are extracted from database AS400 and loaded into the target database apollo using ETL tool.
Roles and Responsibilities: Gathered business requirements from Business Analyst.
Created stored procedures, functions, datamodels, views as per users requirements.
Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
Created and Configured Workflows and Sessions to extract data from various sources, transformed data, and loading into data warehouse using Informatica Workflow Manager.
Wrote Perl Tree script for Informatica Pre-Session, Post-Session Scripts and also to run the workflows.
Used WinSCP to connect server and transferred Perl file from local machine to home directory.
Used PUTTY to run the Informatica Jobs using the shell scripts on the UNIX box.
Scheduled session and workflow using CA job scheduler for automatic execution at the specific timings in both production and UAT environments.
Developed QnR Report (Query Schedule Reports).
These reports are comma separated reports scheduled to run daily, weekly, monthly for executives, Business analyst and send this report via JPM Outlook email address.
JP Morgan Chase International Private BankJuly 2013 to July 2014Geneva, Switzerland
Project Name: JPMC BO Migration.
Technology: SYBASE ASE V12.5, SAP Crystal Reports 2011, Crystal Reports XI Release 2.
JPMorgan Chase & CoMarch 2012 to July 2013
is one of the oldest and largest financial services firm in the world.
JP Morgan has global presence in Investment Banking, Asset Management, Private Banking, Private Wealth Management, and Treasury & Securities Services.
The objective was to migrate BO Reports from Crystal Reports XI Release 2 to SAP Crystal Reports 2011.
Roles and Responsibilities: Played pivotal role in delivering the Business objects Migration project.
Modifying existing reports and to develop new reports by analyzing databases, data sources, and structures for the benefit of internal users.
Major responsibilities include getting requirements from the user, writing stored procedures for reports.
Created parameterized Crystal reports using tables, queries and verify joins between them and customized existing reports for presentations using Sub-reports.
Migrated predefined Report from Crystal Reports XI Release 2 to SAP Crystal Reports 2011.
Exported Reports into PDF, Excel, word & RTF from Enterprise and resolved formatting issues.
Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
Developed QnR Report (Query Schedule Reports).
These reports are actually scheduled to run on a particular date and time and then sent to various users/groups via mails.
Prepared test cases in ALM.
Project #2: Client: Manulife Canada Technology: SQL Server 2008, ASP.NET3.5, SSRS Project: NAV2 Modernization The current Nav2 Project has an existing claims management system built on PowerBuilder and Sybase.
This project deals with the conversion of the existing system into a web based system using MVC and WCF.
In addition, advanced reporting facilities would be provided to facilitate effective and user friendly reporting and subscriptions using SSRS.
Roles and Responsibilities: Participated in Requirement gathering and analysis to check feasibility of data and created physical and logical data models for walkthroughs.
Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
Performed Debugging on the Stored Procedures for the requirement to handle the errors.
Created SQL Server Reports using SSRS 2008 based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services.
Developed reports using SSRS and published as PDF, Excel, and CSV formats.
Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using SSRS Reports.
Experience in creating Parameterized Reports.
Education and Training
SGGSIE&T2011Master of Technology: Electronics & TelecommunicationsMaharashtra, IndiaElectronics & Telecommunications
MGM College of Engineering2009Bachelor of Engg: Electronics & TelecommunicationsMaharashtra, IndiaElectronics & Telecommunications
ASP.NET3.5, apollo, AS400, Asset Management, Banking, Business Analyst, Business Intelligence, Business objects, C, C++, CA, Configuration Management, conversion, SAP Crystal, Crystal Reports, Client, clients, data warehouse, Databases, database, Debugging, email, ETL, financial, frame, French, Informatica, Investment Banking, C#, Excel, Outlook, Windows 7, word, Migration, MVC, Enterprise, Operating System, PDF, Perl, PowerBuilder, presentations, Quality, reporting, Requirement, Securities, Scripts, Script, shell scripts, software development, MS SQL Server, SQL, SQL Server, statistical analysis, SYBASE, tables, Treasury, UNIX, Unix Shell scripting, Wealth Management, Workflow