Project Manager

• Jan 2023 - Present

Responsibilities: • Strategic planning of eCommerce projects including tracking and managing project timelines • Define project scope in collaboration with key stakeholders. • Work with stakeholders to estimate and prepare project costs and ongoing budget management. • Manage the end-to-end delivery and day-to-day operational aspects of IT and business projects. • Vendor Management - negotiations, monitoring deliverables, and maintaining strong relationships. • Conduct project meetings, ensuring clear communication and managing expectations. • Ensure compliance with project management methodologies and quality standards. • To monitor and manage the project processes and ensure that any elements which fail in the workflow are remedied. • To anticipate, manage and resolve issues and act as the point of contact for the project. Environment/Skills: Project Management, Marketing and Sales, Adobe Commerce Cloud, Magento 2, Website Optimization, Magento Commerce Development, Website Development, Smartsheet, MS Project, JIRA, COGNOS, Project management Gantt Chart. Show less

Sr ETL Informatica Developer

• Feb 2021 - Oct 2023

Responsibilities: • Experience in Informatica Intelligent Cloud Services (IICS) Application Integration components like Processes, Service Connectors, and Process Object. • Experience in data modelling, schema designing, data loading, data replication, SQL Query writing and optimization on distributed databases preferably on Cloud Technologies • IICS (Informatica Cloud) - Data Integration, Mass Integration, Application Integration & API Integration. • Effectively using IICS Data integration console to create mapping templates to bring data into staging layer from different source systems like Sql Server, Oracle, Teradata, Salesforce, Flat Files, Excel Files • Implemented Data Synchronization, Data Replication, Mass Ingestion, mapping tasks in IICS. • Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse. • Worked on Informatica ICS interface (REST API) to generate OAuth 2.0. authorization and automate the process that sends the push Service Now files into local Drive. • Created automation process for Online reporting and sending information from SAP to client vendor via SFTP with active employee file update on regular basis. • Encrypt and mass integration to move the file to sftp and archive folder after encryption. • Created IICS Connections using various cloud connecters in IICS Administrator • Designed MASS Ingestion task to ingest large datasets - File Ingestion • Developed Cloud Integration parameterized mapping templates (DB, and table object parameterization) for Stage, Dimension (SCD Type I and Type II, CDC and Increment load) and fact table. • Worked on Informatica Data Quality (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ. Show less

Sr. Informatica and Snowflake Developer

• Mar 2019 - Dec 2020

Responsibilities • Designed and built IICS mappings to extract data from SFDC, Oracle, SQL Server and loaded into Oracle/Designed the ETL flows for generating flat file extracts as per the business need. • Worked on converting Informatica PowerCenter ETL code to IICS using PC to Cloud Conversion service. • Involved in enhancements and maintenance activities of the data warehouse. • Implemented Type1, Type2 and Incremental load strategies in IICS. • Handled configuration activities like setup run time environment and create connections, schedules, tasks, mappings, mapplets and components. • Designed Mappings, Integration Templates, Bundles and Task flows. • Used various transformations to extract data from different formatted files and relational source system. • Developed and tested Informatica mappings based on the specification. • Design and develop PL/SQL packages, stored procedure, tables, views, indexes, and functions; implement best practices to maintain optimal performance. • Create Snowpipe for continuous data load. • Bulk loading and unloading data into snowflake table using COPY command. • Create DWH, databases, schema,tables and write SQL queries against Snowflakes Show less

Informatica Developer

• Jan 2018 - Feb 2019

 Migrating Oracle Databases to SQL Server (Oracle to SQL) and loading the converted database objects into SQL Server then migrate it to SQL Server.  Prepared standard DESIGN AND CODE documents, Technical Specification, ETL Specifications and Migration documents then involved with the Business analysts in requirements gathering, analysis, testing and project coordination.  Maintained daily Tech Tracker/Issue logs for the updates and issues related to objects and progress. Used JIRA to track task and manage the project with workflows and sprints.  Solved various performance and complex logic related issues with effective and efficient solution in the ETL process and identified various bottlenecks and critical paths of data transformation in sessions for different Interface.  Design the validation process for conversion and migration for data accuracy and consistency. Created Reusable Mapplet for time saving development for interfaces.  Used different transformations like Connected & Unconnected Lookup, Stored Procedure, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, Aggregator and Sequence generator, Transaction Control Transformations to data conversion before loading to Target.  Performed different type testing proactively to identify data inaccuracies by using Unit, Integration and Smoke testing.  Performed various Performances Tuning activities at Database level (source, target, Look Up), Informatica level (workflows, mapping and session) as well as database level in Oracle, SQL Server, My-SQL using Sql developer.  Used Tidal Automation Adapters for Informatica, to schedule Informatica jobs through the Tidal platform, enabling them to leverage its capabilities to automate, simplify and improve job scheduling and ETL performance. Environment: Informatica PowerCenter 10.2, Oracle 11g/12c, SAP R/3 7.1, SQL Server 2019, SQL developer, T-SQL, AIX/UNIX, Notepad++, JIRA, Flat files, Tidal, Winscp. Show less

Informatica PowerCenter Developer

• Mar 2016 - Sep 2017

Responsibilities:  Created the Object Relational Database Tables with all the necessary Constraints.  Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.  Involved in scheduling Teradata and UNIX objects to run the jobs on daily/weekly basis depending on business requirement.  Implemented utility functions in JavaScript to make asynchronous calls using XMLHttpRequest.  Worked with SQL Server Integration Services (SSIS) to ETL from OLTP tables.  Created stored procedures and functions to support data storage and manipulation. Show less

Senior Performance Engineer

• Sep 2015 - Dec 2015

Responsibilities:  Role of PT Test Harness, Splunk, Quick Build, Team Tracker & Node Monitor.  Used Node Monitor for health checkup and monitoring various servers and simulators for usage, status, etc. to ensure that the running test is not affecting any servers and nodes.  Used Quick Build for creating various new tags and activating it in different environment and domain while doing performance testing and new releases.  Used Serena Software’s Team Track 6.1 from raising issues till summiting reports and releases.  After having logs, I used Splunk to detect, fix, collect, analyze and monitor.  Test Harness, used to start Load, monitor the load and check all extra loads are working and collect results. Show less

Performance Engineer

• Feb 2015 - Aug 2015

Responsibilities:  Using LoadRunner, execute multi-user performance tests, used online monitors, real-time output messages and other features of the LoadRunner Controller.  Analyze, interpret, and summarize meaningful and relevant results in a complete Performance Test Report.  In dept. knowledge of Software Development Life Cycle (SDLC) methodology (Agile, Waterfall).  Monitor, administrate hardware capacity to ensure necessary resources are available for all tests.  Identified Disk Usage, CPU, Memory for Web, APP, TUXEDO, Database servers and how the servers are getting loaded  Gathered the requirements and compiled them into Test Plan.  Prepared Test Cases, VuGen scripts, Load Test, Test Data, execute test, validate results, manage defects and report results. Show less

Assistant Store Manager

• Mar 2014 - Dec 2014

Manager Trainee

• Jan 2013 - Dec 2013

Assistant Sales Manager

• May 2010 - Aug 2012

Sr. Business Development Manager

• Aug 2007 - Apr 2010