| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLE PHONE NUMBER AVAILABLE New Jersey, USA - Street Address
EDUCATIONBirla Institute of Technology & Science University,Pilani Dec Street Address
Software Engineering (M.Tech)Total IT Experience : 13 YearsSUMMARYEXPERTISE: Worked as Business System Analyst in Banking & Finance Domain,Leading Onshore & Offshore team of 15. Connecting with different Stakeholders & C-Level Executives to get the various requirements related to Executive Data Strategy Engagement.Driving different kinds of Meetings,Initiatives. Working on IBM Datastage,Jira,MS SQL,Oracle,IBM DB2,Confluence,MS Azure,Databricks,Azure Data Factory,IBM Sterling Connect & Azure DevopsFormerly worked as a Technical Product Owner in Transport & Logistics Domain,Leading Onshore & Offshore team of 10. Connecting with different Stakeholders & C-Level Executives to get the various requirements related to Executive Dashboards creation,Support & Maintenance.Driving different kinds of Meetings,Initiatives. Working on Tableau,Oracle,Talend DI,Salesforce CRM,IBM DB2,Service Now,Jira,Anaplan,Azure DevopsFormerly Worked in Consumer Goods Domain, Leading the Onshore & Offshore team of 25.Connecting with Client Managers & Stakeholders, driving different Meetings,Initiatives. Worked on MSBI tools SQL Server,SSIS,SSAS,SSRS,Power BI,Azure Data Factory, GCP,Anaplan,Azure DevopsFormerly Worked in Pharma domain on Datawarehouse Management using Amazon Redshift. Have experience working on Veeva related products like Nitro Admin Console, Veeva Network for Master Data Management. Also have been working on as Jira Admin. Have relevant experience in Tableau.Formerly Worked in Manufacturing & Hi-Tech and Gaming domains and was involved in development activities using MSBI SSRS (SQL Server Reporting Services), Crystal Reports & IBM Cognos BI. Worked as part of data model design team with MS SQL Database and has proficient knowledge in the same. Worked on ETL part on SQL jobs like periodic maintenance, debugging of jobs. Documenting the packages. Rerunning the jobs failed. tracing the activity etc. using MSBI SSIS(SQL Server Integration Services).SKILLS:Business Intelligence: Microsoft SQL Server Reporting Services(SSRS),Tableau, IBM Cognos BI,Power BIData Integration: IBM Datastage,Microsoft SQL Server Integration Services(SSIS),Talend DI,Azure Data FactoryAnalytical : Microsoft SQL Server Analysis Service(SSAS),AnaplanCloud: Microsoft Azure,AWS,GCPFrameworks/Platforms: Azure Databricks,Azure DevopsDatabases: Amazon Redshift, MS SQL Server, Oracle,IBM DB2Testing Framework: ALM Application Lifecycle Management,OTM- Oracle Test ManagerTools: JIRA, Putty, Jenkins, uDeploy,Confluence,Service NowVersion Control: GIT Hub,WinSCP,Sharepoint OnlineGood Knowledge in Smartsheet,Microsoft Forms,Google LookerFile transfer: WinScp,Filezilla,IBM Sterling Connect,OpenText BiztalkDomains:Healthcare & Pharma: Johnson & Johnson,G1 TherapeuticsManufacturing & Hi-Tech: Electronic ArtsConsumer: Ross Dress for Less,LorealBanking & Finance: Wells Fargo,First Horizon National BankTransport & Logistics: Bollore,Forward AirCertifications:IBM Certified Designer Cognos 10 BI reportsIBM Certified Cognos 10 BI Metadata Models Developer102_Introduction to Model Building V2-Official ANAPLANNER_Certificate_8157Tableau Online & DesktopJira AdminPROFESSIONAL EXPERIENCEWipro Ltd. New Jersey, USA. Business System Analyst(Feb/2024 Current)PROJECTS:Banking & Finance - First Horizon National BankRESPONSIBILITIES:Communicate with First Horizon Data Integration teams, project stake holders, IT management team and understand the detailed functional and non-functional requirements for DevOps projects.Estimate the effort involved in fulfilling the requirements after consulting the project manager. Responsible for Business information systems focusing on database architecture, data modeling, data analysis, software design, programming, and application integration.Prepare the functional specification document, high level design document and low-level design document for software components and services.Worked on Auto Lending lifecycle section where Analysis was done by going through the existing lifecycle which FHN has,Documenting the same and providing improvement feedbacks.The Auto Lending lifecycle steps included Loan Origination,Loan Servicing,Loan restructuring, Automating to mitigate Auto Loan collections & Removing silos with End to End Lifecycle Automation.Design and implement new software component and services to ensure system wide efficiency, reliability, and compatibility to maximize system performance.Designed ETL solution to move data from on premise to Cloud.Translated business needs into detailed technical specifications and user stories.Conducted feasibility studies and impact analyses for proposed solutions.Led and managed DevOps projects, ensuring timely delivery of high-quality solutions.Developed and maintained project plans, timelines, and status reports.Coordinated with development, operations, and QA teams to ensure seamless integration and deployment of software applications.Write effective and efficient Structured Query Language (SQL) statements to retrieve data from Oracle, DB2 and SQL Server databases Perform code reviews, recommend improvements, and establish standard development framework.Drive initiatives to build and improve process, quality initiatives and support critical requests during US Business hours Migrate and validate the ETL code and DDL changes to higher environments such as QA and Production using Azure Data Factory.Work closely with development teams and product owners to coordinate project activities, address impediments & meet project deliverables.Assist with internal and external communication, improving transparency and radiating information. Liaise with offshore team to guide them on the design and development.Provide Daily/Weekly status report to the client and Wipro Management. Prepare reports on various metrics and statistics that help track the project status.Source files were transferred through IBM Sterling Connect.Used GitHub to collaborate on code & create version control.Addressing all technical, functional and production deployment issues and effectively communicating with business team for issue resolution and cross functional and technical knowledge on the existing applications, application/system analysis and solution design capabilities.Trained in Data Governance tool using Databricks & Storage with Azure datalake Gen2ETL experience in Azure Data FactoryTECH STACK / ENVIRONMENTJira,IBM Datastage,Power BI,MS Azure,Azure Devops,Databricks,Confluence,IBM Sterling ConnectWipro Ltd. New Jersey, USA. Technical Product Owner (May/2023 Feb/2024)PROJECTS:TRANSPORT & LOGISTICS - Forward Air Inc.RESPONSIBILITIES:Leading technical solutions working with Customer stakeholders, vendors, offshore IT team and use tools like Oracle for the database management, Tableau as the Visualization Tool to create & Manage Executive Dashboards.Extensively using Tableau tool to create customized Executive Dashboards and reports for Data Analytics purpose which would aid the Management & Stakeholders to get an overview on the Sales Forecast data and make executive decision for the business.Tracking the schedule, effort, and costing for the projects. Ensuring the schedule is intact as per the business expectations and send necessary communications in case of any potential issues or delays to the stakeholders.Identified and implemented process improvements to enhance the efficiency and effectiveness of the software development lifecycle (SDLC).Promoted and facilitated the adoption of DevOps best practices, tools, and methodologies.Monitored and analyzed key performance metrics to identify areas for continuous improvement.Provided technical guidance and support to development teams on DevOps tools and practices, including CI/CD pipelines, automation, and infrastructure as code (IaC).Collaborated with IT and security teams to ensure compliance with security standards and best practices.Troubleshoot and resolve technical issues related to DevOps implementations.Communicating Project status information to the BI IT Stake holders. Preparing status reports capturing the key accomplishments, status of in progress activities, RAG status, issues, risks, and mitigation plans, and share with stakeholders.Developed Tableau reports & Dashboards along with some SSRS reports.Worked on building testing & deploying ETL packages & pipelines using Azure Data factory & Talend DI.Act as first support leader for the program on overall quality of the deliverablesEnd to end delivery ownership of the program using Agile methodologyManage detailed plan for the program in consultation with the customerAutomated Imports & Exports using Anaplan connect API.Defined Modules,Lists,Subsets,Actions,Process based on Business requirements.Followed Application Lifecycle management to manage Development,Testing & deployment of the models.Analyzed Anaplan inbound SQL queries & applied fixes during UAT & Production Support.Analyze and suggest continuous improvement measures and best practices followed in Wipro COE (Centre of Excellence) for the program.Coordinate with multiple cross functional teams for the steady state delivery of the programManage the development and production teams in prioritizing the tasks on the Agile release trains for seamless deliveryInterfacing with customer and delivery teams to resolve technical issues in the project(s)To understand the business requirements and guide teams for conversion to proper solutionsTo evaluate projects from a technical stance, guaranteeing that the development methods are correct and practicalUsed GitHub to collaborate on code & create version control.Coordinating at Onsite and work with Client to pursue new Change RequestsManage Onsite and Coordinate delivery with the Offshore TeamParticipating in the Look Ahead meetings on the future state of the program with StakeholdersTECH STACK / ENVIRONMENTProduct Owner, Tableau,Oracle,Talend DI,Azure Data Factory,Databricks,Salesforce CRM,IBM DB2,Service Now,Jira,AnaplanWipro Ltd. New Jersey, USA. Project Lead (Nov/2022 May/2023)PROJECTS:Consumer Goods Loreal USA Inc.RESPONSIBILITIES:Leading technical solutions working with Customer stakeholders, vendors, offshore IT team and use tools like Microsoft SQL Server for the database management, SQL Server Integration Services for Extracting, Transforming & Loading the data into staging area & SSRS & Power BI as Visualization tools.Working closely on multiple BI project applications such as EIW, Boost & Power BI and product owners of Digital IT, Business Intelligence, Integration, B2B, Cloud services and SAP to manage the application development, support, maintenance, and enhancements. Extensively using SQL Server Reporting Services tool to create customized Executive Dashboards and reports for Data Analytics purpose which would aid the Management & Stakeholders to get an overview on the Sales Forecast data and make executive decision for business.Managed the development and deployment of a cloud-native application on GCP, resulting in a 30% increase in user engagement and a 20% increase in revenue.Implemented a CI/CD pipeline using Jenkins and Cloud Build, reducing software release times by 50% and minimizing production issues by 30%.Developed and maintained GCP security policies, ensuring compliance with industry standards and regulationsServed as a liaison between business stakeholders, development teams, and other IT departments.Conducted regular meetings and presentations to update stakeholders on project status, risks, and issues.Prepared and deliver clear and concise documentation, including business cases, technical specifications, and user guides.Driving Anaplan model reviews that supported Loreal in Finance,Sales Performance & Supply chain planning.Modelling sophisticated problems & developing expertise in various functions by using data to support strategic & operational decision- making resulting in improved Anaplan model performance.Providing concise & informative suggestions to improve Anaplan model performance resulting in Customer satisfaction.Consulting on architectural standard methodologies for connected planning solutions, resulting in optimized customer product experience.Developed ETL Processes for support of the Loreal Product management portfolio with SSIS,SQL stored procedures & C# Scripting.Involved in creating SSIS jobs to automate the report generation,cube refresh packages.Experienced in Building Cubes & dimensions with different Architectures & Data Sources for Business Intelligence & writing MDX Scripting.Experienced in creating complex SSIS packages using proper control flow & data flow elements with error handling.Designed & developed SSIS packaged to move data from various sources into destination flat files & databases.Troubleshoot previous SSIS packages to solve issues.Performance tuning existing scripts & processes.Using expertise knowledge and experience in SQL Server Analytics Service extensively to create Business objects such as cubes to provide real time data for the reports execution & Cube Processing.Extensively using Power BI tool for specific regions to create high level dashboards which gives overall view of support provided by the team for services likeIncident management, Service Request, Problem Management, Minor Enhancements, Major Incident Management,Change Management etc.Used GitHub to collaborate on code & create version control.Establishing and stabilizing ITIL processes through service management tools like Service Now, Track-wise to monitor and track the issues reported or services requested as part of Incident, Service Request, Change and Problem Management.Tracking the schedule, effort, and costing for the projects. Ensuring the schedule is intact as per the business expectations and send necessary communications in case of any potential issues or delays to the stakeholders.Communicating Project status information to the BI IT Stake holders. Preparing status reports capturing the key accomplishments, status of in progress activities, RAG status, issues, risks, and mitigation plans, and share with stakeholders.TECH STACK / ENVIRONMENTProject Management(PMO),MSBI Stack( SQL Server,SSIS,SSRS,SSAS),Power BI,Service Now,Azure Data Factory,GCP,AnaplanWipro Technologies Ltd. Bengaluru, IN. Technical Lead (Aug/2021 Oct/2022)PROJECTS:Pharma & Life Sciences G1 Therapeutics Inc.RESPONSIBILITIES:Day to Day activities included:Managing the Datawarehouse requests Updates to an existing object,creation of views,tables etc as per business requirement using Amazon Redshift.Data from various datasources were being managed.Development of ETL Packages by creating Jobs which contains the task sequences and tasks which further contains the main query used to perform the ETL activity in Veeva Nitro toolICS sales Data reporting ICS 867,ICS 852 daily files processing.Files received through OpenText Bizmanager.Monitoring of schedules Jobs & Orchestration in Veeva NitroMaster data management using Veeva Network As a daily task.Match & merge of HCPs & HCOs based on different attributes such as address,zip code etc.Veeva CRM Used to cross check the events,call data & VAE details.Also territory wise details of a Medical Representative.Development of Reports in Tableau using different type of properties like Chart controls, filters, Interactive sorting, SQL parameters and complex expressions to calculate, group, filter, parameterize, and format the contents of a reports in Tableau.Worked as a Jira Admin & built various documentation & channels in Confluence.TECH STACK / ENVIRONMENTDatawarehouse Management using SAP HANA,Amazon Redshift & Veeva Nitro Admin Console, Master data management using Veeva Network,Jira Admin,Tableau,OpenText BizmanagerWipro Technologies Ltd. Bengaluru, IN. Technical Lead (April/2021 July 2021)PROJECTS:TRANSPORT & LOGISTICS Bollore Transport & Logistics Inc.RESPONSIBILITIES:The EDI project is about Application and Maintenance of Web Methods process & interlinked SQL SPs in initial phaseSQL Server 2019 was used as the Database tool.Since it was a Devops Project, used Azure Devops as the bug/tasks tracking tool.Worked as a SQL TECHNICAL LEAD and provided support in bug resolutionTECH STACK / ENVIRONMENTMS SQL Server 2019,Azure Devops, SMILE ticketing tool, Service NowWipro Technologies Ltd. Bengaluru, IN. Technical Lead (Aug/2018 Mar/2021)PROJECTS:BANKING & FINANCE Wells Fargo Bank Inc.RESPONSIBILITIES:The CDO Transformation project was about recreating/redesigning the financial reports developed in legacy system - Crystal Reports tool & MS Excel Macros with the help of MSBI - SQL Server Reporting Services Tool.There were 100 reports approx to be developed as part of Phase 1.SQL Server 2017 was used as the Database/Datamart tool.Worked on Auto Lending lifecycle section where Analysis was done by going through the existing lifecycle which FHN has,Documenting the same and providing improvement feedbacks.The Auto Lending lifecycle steps included Loan Origination,Loan Servicing,Loan restructuring, Automating to mitigate Auto Loan collections & Removing silos with End to End Lifecycle Automation.Since it was an Agile Project, used JIRA as the bug/tasks tracking tool.Worked as a MSBI TECHNICAL LEAD Converted/redesigned the reports using SSRS tool.Phase 1 development complete from reporting perspective.Worked on UI(Java) to configure the reports & test the UI screen Merging of the reports & applying business changes post business reviewWorked on Report merging process, writing SQL stored proceduresStored the reports in PDF format, performed the unit testing & fixed the bugs foundSuccessfully migrated the reports to SIT,UAT Pre Prod & Prod EnvironmentsDeveloped 20 reports related to Phase 2TECH STACK / ENVIRONMENTMS SSRS(SQL Server Reporting Services) 2017,SQL Server 2017,Crystal reports, Jira, Application & Lifecycle Management(ALM),Jenkins, GitHub, UdeployWipro Technologies Ltd. Bengaluru, IN. Technical Lead (May/2017 Jul/2018)PROJECTS:Consumer: Wholesale Ross Dress for Less Inc.RESPONSIBILITIES:Worked as Offshore Technical leadDaily project status from offshore to onshoreUnderstanding the requirement and getting the reports developed.Communication with client & the onshore team members. Also, with the WIPRO Practice team if neededDeveloping the various important documents in the project.Code Reviews,design review, document review, testing etc.Made sure to maintain the quality of deliverablesProvided KT to newcomers to the team, support team, onshore team and Testing team from SSRS end.Maintained the source code and other documents on the Sharepoint site.Report Migration to other environments 2012 to 2015 serverReports testing post migration and supportSSIS Job monitoring and supportPostmortem of project end phasePostproduction supportTECH STACK / ENVIRONMENTMS SSRS(SQL Server Reporting Services) 2017, MS SSIS(SQL Server Integration Services) 2017,Oracle 11g,Sharepoint 2016Wipro Technologies Ltd. Bengaluru, IN. Senior Project Engineer (July/2014 Apr/2017)PROJECTS:Gaming & Semiconductor Electronic Arts Inc. (EA Games)RESPONSIBILITIES:Created reports based on the ticketing database related to the Gitsd Unicenter tool which was used for creation of tickets .Now Service Now tool is in place.Creating Stored procedures in SQL.Creating customized reports in SSRS tool.Resolution of access issues tickets.Migration of Reports(>300 in number) from one reporting server to another.(2008 to 2012)Created Datasources & subscriptions for the same.Worked on SSIS jobs like periodic maintenance, debugging of jobs. Documenting the packages. Rerunning the jobs failed. tracing the activity etc.Develop Executive DashBoardsProvide Technical Support for Web applications developed on .Net framework 4.0.Bug Tracking, WSR creation, Team building activities.ETL Jobs Monitoring and fixingWorked as a Problem manager, Major Incident manager & AMS ticket AuditorTECH STACK / ENVIRONMENTMS SSRS(SQL Server Reporting Services) 2008, MS SSIS(SQL Server Integration Services) 2008,MS SQL Server 2008 R2,GITSD Unicenter, Service Now,.Net Framework 4.0Wipro Technologies Ltd. Bengaluru, IN. Senior Project Engineer (July /2011 June/2014)PROJECTS:Healthcare & Life Science Johnson & Johnson Inc. (J&J)RESPONSIBILITIES:During the DW Server Upgrade, the compiler was upgraded from a 32 bit to a 64 bit. During the compilation of the programs using the upgraded compiler, the team encountered warnings & the bug fix process was initiated. It was required to modify the array length of the impacted fields compared to the data in sourcing document & lengths in database.APO Data assessment. 5 franchisees were involved.Creating profiling for Back-to-basics systems & report creations.Created reports for ASP systems for POC purposeTECH STACK / ENVIRONMENTIBM Cognos BI 8, IBM Cognos BI 10,MS SQL Server 2008 R2,Putty,Unix Shell Scripting, Informatica Power Center |
