EXPERIENCE SUMMARY:

• Successful best candidate with diverse and extensive experience focusing on the solutions of software development, systems maintenance & support, project leadership and management
• Business Intelligence solutions using ETL - iWay suites, ETL,iway,Integration Technologies, Banking Applications, Government Public Services, Data Analysis, Deployment tools, Middleware and Web Based Applications with excellent interpersonal communication skills.

• Excellent 10.9 years of IT experience in Analysis, Design, Development, Project Management, Release Management, Testing and Implementation of business application systems for Banking IT industry.
• Excellent 8+ years of work experience in ETL/Informatica/IWay/Integration technologies in Confidential Canada (TechMahindra Limited) as Application Support Analyst
• Strong experience in Business Intelligence solutions using iWay-ETL suite - iWay Data Migrator (ETL),iWay Service Manager (integration), iWay Data Quality suite(Data Validation & cleansing),Informatica Power center(ETL)
• Excellent 4+ years of work experience as Senior Software Engineer & Technical Leader for CITI bank financial services, Canada (Wipro Technologies Limited) .
• Presently Working as Project leader and Sr. ETL Specialist in Confidential Canada for Application support/Maintenance projects with excellent exposure to Domain knowledge (BFSI).
• Excellent Expertise in Software Development Life Cycle, ETL, Informatica, iWay, Informatica PowerCenter, Service Now,BPM methodologies,Devops,PowerBI,JSF and web based applications including Agile methodologies and Informatica Power Centre.
• Expertise in Data repository implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support
• Excellent Exposure to enterprise change control and incident management processes with Service Now
• Proficient in the Integration of various data sources with multiple relational databases like Oracle10g/9i, MS SQL Server, DB2,writing stored procedures, Host files
• Excellent interpersonal and communication skills having strong planning and analytical skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Hands-on experience across all stages of SDLC & all phases of ETL development including requirement analysis, data mapping, build, PowerBI,Clearcase,Bitbucket,Genkins,Gitsbsh,Buildforge
• Dealing with Data warehousing concepts and working on Reporting Databases and Informatica PowerCenter and reporting using PowerBI & webfocus tools.
• Excellent experience in Preparing the development plan, Implementation Plan and Implementation Strategy and getting necessary approvals from Client Management
• Got time to time Client Appreciations, s from Confidential and CITI group fund services.
• Excellent participation in Code promotion, build deployment and QA activities at client location.
• A quick learner with the ability to make solutions-oriented, creative and innovative contributions

  in highly demanding situations

TECHNICAL SKILLS:

Primary Skill category: iWAY, Informatica, ETL tools, Informatica PowerCenter,JSF,Unix,SQL-Db2-ETL/Integration tools, Batch & Autosys Schedulers, Service Now, PowerBI,Webfocus tools

Secondary skills: JSF, SQL,DB2 Client, Unix scripts, Mutual funds, Capital Market,CIM, SalesBuilder,CSS,XML,CSV,JavaScript,DB2/SQL,MySql,Stored procedures

Project Acquired skills: Informatica, ETL,iWay,JSF,J2EE,SQL, PowerBI,EGL,JSP,XML/XSD, Integration Tool- Iway Data Migrator,ISM,DB2 client, Webfocus & Web frameworks, DB2/SQL, RBD,WAS,IBM WebSphere Server, Unix,Javscript, Batch & Autosys Schedulers,ServiceNow,EGL,Clearcase,Bitbucket,Genkins,Gitsbsh,Buildforge, SVN, Autosys batch/PRODUCTION-Support batch scripts etc

Management Skills: Service Now, JIRA,Confluence,CAB/RFC support, Build Deployment, Release Management, Change Management, Project Risk Management, Status Reporting, Project Governance, Financial Reporting, Technical & Resource requirements, Build effective relationships with business

Operating Systems: Windows7,Win97 & NT, UNIX

Languages: WEB FOCUS, JSP, Javascript, EGL etc

Databases: SQL Server 2000, Oracle 9i,DB2

Tools: & Utilities: Business Intelligence tools,ETL tools, Informatica PowerCenter, PowerBI, Iway DataMigrator DM7702,DM7705,ISM 6.0, Informatica, ETL /Integration tools, JSF, Web monitor and Batch & Autosys Schedulers, Service Now,webconsole,EGL,SQL,db2,winscp,winmerge,superputty,Unix,TOAD

PROFESSIONAL EXPERIENCE:

Project Leader, Sr. ETL Analyst

Confidential, Scarborough, ON

Responsibilities:

• Leading & Co-ordination with different (23) application teams in order to resolve all incidents and solution of related application activities and responsibilities.
• Extracting and summarizing data from a variety of data source types using ETL/Informatica Power Center and Identifying the pain areas in current system and capture the new requirements for future system.
• Creating and optimizing of contents for the application using a variety of Business Intelligence solutions using ETL-iWay suite - iWay Data Migrator (ETL),iWay Service Manager(integration), iWay Data Quality suite(Data Validation & cleansing),Informatica Power Center(ETL), ETL, Integration, IWay, Informatica flows/procedures, database, PowerBI and other software.
• Data repository implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Integration of various data sources with multiple relational databases like Oracle10g/9i, MS SQL Server, DB2,writing stored procedures, Host files and Flat Files into the staging area.
• Collecting the Requirements, prepare Requirement specification documents for future/enhanced system; prepare technical specification documents for future system/system.
• Actively working with Data warehousing concepts and working on Sales builder Reporting Databases including Microsoft PowerBI and IBI webfocus tools
• Assisting multiple teams and providing solution for performance tuning of batch Jobs and exposure to Unix scripting and Scheduler tools
• Deploying ETL workflows to pre-production and production environments and Conduct application checkout tests after deployments and patch cycles.
• Set up and manage batch job schedule for ETL workflows and Troubleshooting of application batch jobs in Autosys batch Scheduler.
• Diagnosing ETL issues including connections to data sources, adapters, service account authentication and other connectivity issues.
• Assisting multiple teams and providing solution for performance tuning of batch Jobs and exposure to Unix scripting and Scheduler tools, Autosys jobs, Devops platform, PowerBI,Clearcase,Bitbucket,Genkins,Gitsbsh,Buildforge etc
• Working as Service Now Queue Manager for Respond to and resolve incidents as part of second level application support .Also, ticket assignment and analysis for service now incidents
• Perform server and client based product installation, configuration and maintenance activities of in house developed or third party applications.
• Maintain technical implementation and run book documentation for applications.
• Assist in creating quality reports on disk capacity, service requests and incidents .Also raising incidents and work with external software vendors to resolve third party product issues
• Working with Customer for Design, business, Estimation and development implementation of project during different releases of project.
• Preparing the development plan, Implementation Plan and Implementation Strategy and getting necessary approvals from Client Management.
• Identifying the issues/risks, do the risk assessment and identify the mitigation plans, Identify and communicate technical problems, processes and solutions.
• Interacting with Confidential and Tech Mahindra, India team and providing the necessary support to develop the application, in testing the application.
• Preparing the reports, manuals and other documentation on the status, operation and maintenance of Application.
• Providing Support for configuration management of the code through various stages to Production.

Environment: ETLtools,Informatica,InforaticaPowerCenter,EDW,DataWareHouse,BatchSchedullingTools & Sytems,iWay,DataMigrator(v7702,v7705),ISM,ServiceNow, PowerBI,putty,Unix,Winmerge,winscp, Clearcase,Bitbucket,Genkins,Gitsbsh,Buildforge, filezilla,DataVisualization,middleware host,SOAPUI,Db2 Squirrel, Mainframe DB, Db Visualizer.etc.

Project Technical/Release Manager

Confidential, Scarborough, ON

Responsibilities:

• Leading & project management capacity including all aspects of project management processes, disciplines and execution essential..
• Enterprise Project Management: End-to-end accountability for successful project delivery, including technology and business readiness deliverables and change management activities.
• Release Management: Release Planning, Coordination, Maintaining the deployment schedules, Monitor build health, conduct build readiness reviews with development team leads including sound hands on tools like Clearcase,Bitbucket,Genkins,Gitsbsh,Buildforge.
• Automation processes using JIRA and Confluence for different project specific Sprints,User stories, procedures and Autosys Scheduling activities.
• Define and maintain a set of core rules for all processes, such as security, change management, support, Maintain release procedures etc.
• Chair / attend meetings with App Teams and Test teams for environment dependency and allocation finalization and Test environment allocation in coordination with BNS CC for Standalone releases
• Project Risk Management: Proactively identifying, mitigating, and managing project risks. Identify, track, and report key release metrics, Collect reporting data from the databases and provide it to stakeholders
• Working as Service Now Queue Manager for Respond to and resolve incidents as part of second level application support .Also, ticket assignment and analysis for service now incidents
• Review the production checklist with proper understanding of production environment and understanding Release Management process, SDLC and ITIL standards
• Status Reporting: Collect and communicate release notes, Reporting project status, including accurate financial information, using defined tools like PowerBI and processes.
• Build effective relationships with development leaders and business stakeholders. Also Provide teams with s and support on software release processes
• Project Governance: Establish and maintain process governance in Confluence & JIRA for application development and maintenance teams under management umbrella for different project documentation and management. Collecting information for steering committee reviews (business case approvals, project reviews, changing requests, project closing sign offs, etc.), and ensuring reviews are held as per governance model.
• Change management activities like Lead & manage implementation plan reviews, Attend TAB/CAB meetings, Manage/coordinate change implementation (including communication),Close successful change or review unsuccessful change (PIR).
• Obtain technical requirements and resource requirements for change ticket(s), Confirm resource availability & secure resources and Chase Approvals (Change Requester’s Manager, ECM) for change
• Financial Reporting: Ensuring project costs (including internal labour) are accurately reported and tracked against project budget.
• Manage risks and resolve issues that affect release scope, schedule and quality to Ensure adherence to quality/process, establish guidelines as necessary
• Ensuring projects are delivered on time, on budget, within defined scope, and with agreed-upon specifications to enable the of defined benefits.
• Communicating project vision and objectives, and partner with stakeholders to achieve these objectives.
• Creating war room and manage the stake hold as well reporting for critical issues/escalations.
• Ensuring project processes are applied consistently, including project charter, project plans, issue and risk management, financial management, resourcing, and procurement management.
• Leading project teams in achieving project success; facilitating problem solving efforts to reduce defects, improve customer satisfaction, manage end user impact, reduce cost and increase project efficiency.
• Supporting feasibility studies, business cases, analysis and documentation of data and processes and providing estimates of work effort and duration for medium sized projects.
• Contributing to the success of the Enterprise Project Management Office, for example, by leading continuous improvement initiatives and providing leadership and guidance to Associate Project Managers on the team.

Sr.Programmer Analyst/ETL Analyst/Team Leader

Confidential, Scarborough, ON

Responsibilities:

• Acted as a Single point of contact for 16 different channel teams to resolve all the queries & resolution of related CIM activities and responsibilities up to warranty phase of project.
• Extracting and summarizing data from a variety of data source types using ETL/Informatica Power Center and Identifying the pain areas in current system and capture the new requirements for future system.
• Creating and optimizing of contents for the application using a variety of ETL,Integration,IWay, Informatica flows/procedures,Informatica PowerCenter,PowerBI,database and other software.
• Collecting the Requirements, prepare Requirement specification documents for future/enhanced system; prepare technical specification documents for future system/system.
• Actively working with Data warehousing concepts and working on Sales builder Reporting Databases and tools like PowerBI and IBI webfocus tools.
• Data repository implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Assisting multiple teams and providing solution for performance tuning of batch Jobs and exposure to Unix scripting and Scheduler tools
• Working with Customer for Design, business, Estimation and development implementation of project during different releases of project.
• Integration of various data sources with multiple relational databases like Oracle10g/9i, MS SQL Server, DB2,writing stored procedures, Host files and Flat Files into the staging area
• Troubleshooting and RCA for ETL issues including connections to data sources, adapters, service account authentication and other connectivity issues.
• Working as Service Now Queue Manager for Respond to and resolve incidents as part of second level application support .Also, ticket assignment and analysis for service now incidents
• Perform server and client based product installation, configuration and maintenance activities of in house developed or third party applications.
• Maintain technical implementation and run book documentation for applications.
• Provided simplified and user friendly solution by implementation BULK LOAD Utility for major CIM process.
• Involved in development of different Design, stored procedure & scripts for database.
• Involved mainly in execution of different Autosys Jobs & batches for all CIM activities for different phases of testing cycles.
• Involved in different phases of SDLC cycle like Code promotion, code Review, Build deployment, Clearcase activities, checklist preparation and execution, Unit Testing, SIT, Regression, Integration Testing and Leading the process of unit testing, system testing, integration testing
• Documenting and updating the mapping documents/business documents as well as GDD for complete development cycle and application.

Environment: ETL tools,Informatica PowerCenter, IWAY Data Migrator,ISM,IIT,JSF,WebConsole,PowerBI,unix scripts.RAD8.5 with WAS8.5,DB2 client, ServiceNow, Clearcase,Bitbucket,Genkins,Gitsbsh,Buildforge Middleware host, mainframe db,Winscp,Superputty, winmerge,SQL visualizer,, HP-QC,SQL Squirel,TOAD.build forge, Clearcase etc.

Sr. Software Engineer /Data Analyst

Confidential, Scarborough, ON

Responsibilities:

• Data analysis and process execution using ETL, Informatica, EDW, Informatica PowerCenter and different ETL tools.
• Involved in execution of different Autosys Jobs & batches for mric reports like DDA,Savings,Scotia card and Standing order.
• Creating and optimizing of contents for the application using a variety of Business Intelligence solutions using ETL-iWay suite - iWay Data Migrator (ETL),iWay Service Manager(integration), iWay Data Quality suite(Data Validation & cleansing),Informatica Power Center(ETL), ETL, Integration, IWay, Informatica flows/procedures, database and other softwares.
• Data repository implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Integration of various data sources with multiple relational databases like Oracle10g/9i, MS SQL Server, DB2,writing stored procedures, Host files and Flat Files into the staging area.
• Involved in execution of several checklists for DEV and IST environments and co-ordination across various teams like TEM and admin team.
• Involved in different phases of SDLC cycle like Code promotion, code review, Build deployment, Clearcase activities,Unit Testing, SIT and Integration Testing.
• Documenting and updating the mapping documents/business documents as well as GDD for complete development cycle and application

Environment: Iway Data Migrator,BPM and Business Intelligence tools, ETL, Informatica PowerCenter, PowerBI,, Informatica, ETL tools,ISM, JSF,XML,Autosys batch, Clearcase,Bitbucket,Genkins,Gitsbsh,Buildforge Middleware host,Db2 Client,HP QC, winscp,putty, winmerge,SQL visualizer, SOAP UI etc.

Senior Software Engineer

Confidential, Mississauga, ON

Responsibilities:

• Understanding Business Requirements Design, Development and Unit Testing, peer testing
• Task allocation and co-odinating with different offshore teams for different releases including Retrofit tasks
• Executing/coding different PL/SQL commands (Oracle9/10)for database/server for data
• Development of JSF based (J2EE, JSP) mappings & workflows using PL/SQL Activities, Code migration and smoke test in other environments. (SIT & UAT),Data analysis and code execution using ETL tools and Informatica, Abnitio, Informatica PowerCenter,EDW etc
• Involved in different phases of SDLC cycle like Code promotion, code review, Build deployment, Clearcase/SVN activities,Unit Testing, SIT and Integration Testing etc, with creation of Design documents for projects and its various releases Involved in development.
• Actively involved for technical resolution and guidance during Production support phase of project
• Involved in execution of different Autosys Jobs & batches for unitrax screens and build activities through IBM tools
• Analysis and understanding IBM proprietary tools. Analysis and solution over technical issues.

Environment: ETL, ETL tools,Informatica J2EE,BPM methologies,EGL,JSP,JSF,JAVASCRIPT,RBD, EGL,SQL/Oracle9/10, Clearcase,Bitbucket,Genkins,Gitsbsh,Buildforge, DB2,AS400,Eclipse, SVN,Rational Business Architect, Edit Plus Editor, Mercury Quality Center, Test Director, SQL visualizer.