| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email : EMAIL AVAILABLE Mobile:PHONE NUMBER AVAILABLELinked: https://LINKEDIN LINK AVAILABLEExperience SummaryAn accomplished, results-oriented DW/BI onsite Tech Lead and offshore project manager with 16+ years of experience in Software Development and maintenance cum production support projects in various domain like insurance, life science, manufacturing, automobile and Banking domain.Currently working as, a Technical Lead Consultant in Financial domain with Charles Schwab Financial Services, Dallas (TX).Experience in gathering Business Requirements, Developing Business Intelligence Program strategies, designing & implementing Business Intelligence information & analytical solutions.Excellent understanding of data sources like Flat File, Oracle DB, Oracle EDW, MS-SQL Server, MS Access.Core areas of experience are in DW Development and support using ETL tools such as Informatica Power Center 9x/10x and OBIEE 12c.Good experience in developing Informatica Mappings/Mapplets and Workflows with Worklets & Tasks using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure and Lookup) for ETL of data from Multiple Sources to Data Warehouse.Extensive experience in ETL methodology for Extraction, Transformation and Loading using Informatica and designed data conversions from wide variety of source systems like RedShift, Oracle, SQL server, Flat files, and unstructured data files.Expertise in providing end-to-end business intelligence solution by designing dimensional modeling, configuring metadata & building Analytics Repository, building business models, generating reports, creating Inter-active Business Intelligence Dashboards using Oracle Business Intelligence (OBIEE) 10.x, 11x and 12c .Worked Extensively on Oracle BI Administration Tool, web / Presentation Services, Answers, & Interactive Dashboards and Security Implementation.Expertise in implementing the Oracle BI Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).Extensive experience in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Contextual Navigation, Business Rules with User Identity & Roles, Profiles & Personalization.Experience in installation and configuration of OBIEE 10g, 11g and 12c and excellent understanding of Star & Snowflake Schema methodologies & Dimensional Modeling.Extensively worked on Operational Data like Workday, PeopleSoft, Oracle EBS and POS Systems like JDE, Kronos etc., and created a sophisticated reporting structure with Fact-less Fact table.Very good in Debugging, Optimizing and Performance Tuning of BI Dashboards/Reports.Excellent command over Oracle Forms/ Reports, SQL, PL/ SQL programming, which includes stored procedures, functions, packages, views, cursors, triggers, indexes, Dynamic SQL, snapshots, materialized views, table/ index partition, collection, analytical functions, Oracle UTL_FILE features, external tables, SQL Optimizer Hint, Explain Plan, TKPROF, AWR Report, SQL*Loader and SQL/ stored procedure tuning.Has proven analytical skill and has been instrumental in developing innovative solutions for projects implemented in Barclays and in prior assignments.Experience in leading large development, migration, technology re-write and upgrade projects from inception and planning to delivery acting as the project driver from technology with hands on approach. Capable of being an individual contributor as well.Extensive experience in stakeholder managements and co-ordination amongst several infrastructure and Operations teams.Technical SkillsOperating SystemWindows, HP-UNIX, LinuxSkill setsPower Center 9/10, Power Exchange, EDW, IBM-Optim, OBIEE 11g/12C, OBIA, SQL, PLSQL, AWS-Redshift, AWS-S3Databases & ToolsOracle 9i/11g/12c, Sybase, Impala-HiveOther UtilitiesAutosys Scheduler, TWS Scheduler, BMC Remedy, Service-Now, CA7, u-Deploy, IBM-Artifactory, DAC 12C1#Employment ProfileCompanyLeidos, Reston, VAClientEntergy Services Inc-TexasProjectBI AnalyticsDesignationTechnical LeadDurationDec-2021-ContinSkill SetPower Center-informatica, Oracle, SQL, AutosysRoles and Responsibilities:Working as an individual contributor on the DW technologies which involves technologies such as Power Center-Informatica, Oracle, SQL, Autosys, HIVE and Informatica BDM.Work with the BA/BSA on the analysis of the new requirements and business requirement analysis documents for the technical design documents and development for the ETL mapping and workflow.Work closely with the architect and engineers to understand the data model after addition of the new DB objects.Work closely with offshore team on the deliverables.Own deliverables related to development, implementation, and testing.2#Employment ProfileCompanyWipro, Plano-USAClientCharles Schwab, Westlake, TXProjectFinancial Reporting Layer-FRL/Digital Accelerator(Zelle, Heart Campaign)DesignationTechnical LeadDurationAugust-2020 -Dec-2021Skill SetPower Center-Informaica, Teradata, SQL, Control-M, CD/CI, BambooRoles and Responsibilities:Working as an individual contributor on the DW technologies which involves technologies such as Power Center-Informatica, Power exchange, Teradata, SQL, Control-M, CI/CD, Bamboo, HIVE and also using talent framework on the BDH platform for the financial reporting layer project and Zelle.Work with the BA/BSA on the analysis of the new requirements and business requirement analysis documents for the technical design documents and development for the ETL mapping and workflow.Work closely with the architect and engineers to understand the data model after addition of the new DB objects.Work closely with offshore team on the deliverables.Own deliverables related to development, implementation, and testing.2#Employment ProfileCompanyWipro, Plano-USAClientPHEAA Financial Services, Harrisburg-USAProjectDARBI-Data Migration From Mainframe To AWS-RedshiftDesignationTechnical LeadDurationApr-2019 to August-2020.Skill SetPower Center 10, AWS-S3, AWS-Redshift, UNIX, Tableau, JIRA, GLITZRoles and Responsibilities:Worked as a Technical Lead Consultant in financial domain (student loan services) which involves technologies such as Power Center 10, Power exchange, Oracle 12C, Unix, Data-Lake, AWS-S3, AWS-Redshift SQL, PLSQL.Also I have beginner working knowledge and experience on the MondoDB(NoSQL).Particularly involved in the development activities like workflow, session and mapping for the data migration from mainframe to AWS environment. Data source is AWS-S3 where data arrives from DB2 through python scripts. Doing hands on activities to develop the mapping and writing DB view script and stored procedure as an individual contributor as well as leading a team to provide the technical supports.Interacted with data analyst team to understand the business requirement and the functionality of the various applications for the ETL process.Was responsible to create TDD, STM (Source to Target Mapping) spreadsheeted, ETL workflow diagram, enterprise architectural diagram changes, code review and mapping/workflow/SQL/Stored procedure, DB view and code migration from UAT to QA.Data source is AWS S3 Bucket and target is AWS Redshift.Particularly involved in projects space and responsible for the conducting POC on DW technologies, feasibility studies, end-to-end design and delivery along with daily production and support activities.2#Employment ProfileCompanyTCS, NJ-USAClientPNC Bank, Pittsburgh, PA-USAProject1.Technology Enterprise Reporting (TEP)2.Human Resource Reporting and Analytics (HRR)DesignationTechnical LeadDurationSep-2018 April 2019Skill SetPower Center 10, Oracle 12C, Unix, DAC, CA7, uDeploy, IBM Arti Factory, SQL, PLSQL, EFX, Power ExchangeRoles and Responsibilities:Worked as a Technical Lead Consultant to provide the production support and enhancement activities for the Technologies Enterprise Platform and Human Resource Reporting projects Involved technologies are Power Center 10, Power exchange, Oracle 12C, Unix, DAC, CA7, uDeploy, IBM Arti Factory, SQL, PLSQL along with BDH platform.Particularly involved in the projects enhancement and responsible for the conducting POC on DW technologies and interacted with BA to understand the business requirement and the functionality of the various applications for the ETL process.Was responsible to create TDD, STM (Source to Target Mapping) spreadsheeted, ETL workflow diagram, enterprise architectural diagram changes, code review and mapping/workflow/SQL/Stored procedure, DB view and code migration from UAT to QA.PeopleSoft, Workday, Oracle, flat file, HTTP, Archer/Service Now Application, Corner Stone, IBM Kanexa and main frame are source outbound and Oracle DW is inbound.3#Employment ProfileCompanyFujitsu America Inc. Richardson, TX-USADesignationTechnical LeadDurationSep-2017 Dec-2017Project: Data Archival and Decommission/Client: Comerica Bank, Detroit-MI/Duration:092017-122017Roles and Responsibilities:Interacted with BA and application owner to understand the legacy system for the decommissioning the application and achieved the business-related data into IBM Optim Server for reporting purpose to BI team which involved technologies such as IBM Optim, Unix, Oracle (SQL, PLSQL, OBIEE), Crystal Report, IBM-MainFrmae.Particularly involved in projects scope definition as per contract and was responsible for conducting POC on the data archival by using the IBM Optim.Responsible to create TDD, STM (Source to Target Mapping) spreadsheeted workflow diagram, enterprise architectural diagram changes, code review and mapping/workflow development.DB2, Oracle, flat file, HTTP, Archer, and main frame are source outbound and IBM Optim Sphere is inbound.Involved technologies were IBM Optim, Unix, Oracle (SQL, PLSQL, OBIEE), Crystal Report, IBM-MainFrmaeProject: Value Chain Planning (VCP)/Client: JM Smucker, Orrville-OH/Duration:092016-072017Roles and Responsibilities:Interacted with SME, BA and application owner to understand active dashboard and ad-hoc report of the value chain planning application that was needed to rebuild and migrate from OBIEE10g to 12C by using EDW.It was technologies change/platform change project from PLSQL, OBIEE 10 g into DW technologies EDW and OBIEE 11g.First phase for this project was to build ETL mapping and schedule the ETL jobs to extract the data from the Demantra and EBS by using DAC after understanding the existing business rule and logic that was written SQL/PLSQL and second phase was RPD creation with star schema, aggregation, level-based as well as parent child hierarchy and OBIEE Analysis, Dashboard and ad-hoc report.Created 40 ETL mappings that includes SCD1 and SCD 2 for the dimension and fact tables.Created 65 reports in BI Analyses to show a different capability of OBIEE to the users.Created the Physical, BM and Presentation layers/Subject Area by using OBIEE RPD based on dimension and fact tables (daily, weekly and monthly aggregate tables).Involved Technologies were Oracle/OBIEE 12C, SQL, PLSQL, DAC 12c, Unix, SVN, Power Center 10, EDW5#Employment ProfileCompanyHSBC, Pune-IndiaProjectSPARCDesignationAssociate Project ManagerDurationMay-2016 sep-2017Skill SetOracle/OBIEE 12C, SQL, PLSQL, Control-M, Unix, ETL (Power Center 9x)Roles and Responsibilities:Frequent interactions with business user from different region to understand the business requirements and ongoing issue to automate the production issue.Frequent interactions with Unix and Oracle Admin at the time of the Code and SPRINT release.Did gap analysis to fix the performance issue and tuned the existing stored procedure, mappings (SCD2/SCD1) and reports. Did tuning in the repository side too by implementing the aggregate and fragmentation methodologies.Provided support to the testing team at the time of the UAT while writing the SQL and did production support during warranty period.Particularly involved in projects scope and definition with stakeholder and was responsible for conducting POC on the data new requirement and implementation, feasibility studies, end-to-end design and delivery along with daily production and support activities.6#Employment ProfileCompanyCTS, Pune-IndiaDesignationProject Manager-TechnicalDurationDec-2007 June-2015Skill SetOracle/OBIEE 12C, SQL, PLSQL, Control-AutoSys Unix, Power Center 9x, D2K(Forms/Reports), VB.Net, SQL/Stored Procedure Tuning and PerformanceDuration : Apr-2014 June-2015 Project Manager-Technical (Pune-India)Client : Hartford Financial Service Group, Inc. Hartford, Connecticut-USAProject : Billing and Audit Integrated ServicesRoles and Responsibilities:Was responsible in building and mentoring the team after cognizant took over the new project from an existing vendor of The Hartford in Billing and Audit area.Was involved in hiring of team members, mentoring, co ordination of KT sessions, Reverse KT sessions, End to end Service and Artefact handover, end to end planning and team organization.Went on to lead the production support team for the Direct Billing applications in the project. These are the companys commercial and personal Insurance billing applications that report directly to the general ledger and hence are survival critical.Was responsible for Incident management, day to day work allocation to the team, status tracking, project reporting and stake holder management.Had the ownership to monitor and keep the business survival critical batch and real time processes running 24x7 and had to ensure that his team adheres to the strict SLAs mutually agreed between Cognizant and The Hartford.Had to utilize his expertise in technologies like Oracle Forms, PLSQL, SQL, LINUX, Shell Scripting, Oracle application server, Autosys batch scheduling, Mainframe, Web services etc. to address and resolve the various batch failures and the issues faced by the business users. He often had to perform complex analysis and coordinate and drive the critical/Major Incident calls with interfacing teams.Was also responsible for delivery of enhancement requests to the system.Duration : Dec 2012 Feb 2014 - Project Manager-Technical (Pune-India)Client : Credit Swiss, Zurich, SwitzerlandProject : Swiss Finance PlatformRoles and Responsibilities:Created the physical layout of the database, DB View, Stored Procedure using Sybase Power Designer Tool, Oracle (SQL, PLSQL)Responsible for developing RPD and Reports/ Dashboards as per clients requirement by using OBIEE 10g.Involved in developing the SQL to transfer data from inbound section to outbound section using view, materialized view and data load.Developed SQL Loader and Mapping to load the flat file into Oracle Database and spool file by using SQL loader and Power Center 9.0.Created SQL scripts to load data into the temporary staging tables.Created and altered database objects such as tables, views, sequences, and synonyms.Developed highly tuned SQL to use inside the Java Application.Implement Dynamic SQL methodologies whenever necessary in the Packages/ Procedures/ Views.Providing the accurate solutions to complicated issues to meet the customers expectation.Apart from all above points I was HCM supervisor for OSP resources.Duration : Dec 2010 Oct 2012 Technical Lead Consultant (Pune-India)Client : MeadWestvaco, Richmond, VAProject : Planning and Performance ManagementRoles and Responsibilities:Worked as a Database Solution Consultant for DW Technologies.Involved in project management activities like (Weekly Status Call/ Project Metrics/ Resource allocation/ Work assignment).Assisting in preparing the Business Requirement Document (BRD) as to provide a better understanding of business processes and identify improvements.Created mappings and workflows to extract the source data and staged the data in staging tables (ODS database) and then extracted the data from RPS database and loaded the data into target warehouse (SAP BW) using various transformation logic like Lookup, Aggregator, Joiner, Source Qualifier, Normalizer, Expression, Stored procedure and many more while designing and developing complex mappings by using Power Center 8.6.1.Enhancement of existing PL/ SQL packages, procedures and repository customization and developing Reports/dashboard as per clients requirements and TD document.Performed SQL tuning using indexes and created bitmap indexes on low cardinality columns as they resulted in reduced response time for queries and substantial reduction of storage spaceDeveloped complex queries on data warehousing and developed PL/ SQL procedures to provide nice strategic plans to higher level of managementCreated SQL scripts to load data into the temporary staging tables and Used Dynamic SQL (D-SQL) programming techniques to build and process SQL statements "on the fly" at runtime.Tuned complex stored procedures for faster execution and developed.Duration : Jan 2009 Dec 2010 Technical Lead Consultant (Pune-India)Client : Volkswagen-Audi, Herndon, USAProject : Checkpoint Reporting System and Inventory ApplicationRoles and Responsibilities:Involved in project management activities like (Weekly Status Call/Project Metrics/Resource allocation/Work assignment).Enhancement of existing PL/SQL packages and procedures according to the requirement.Developed complex queries on data warehousing and developed PL/SQL procedures to provide nice strategic plans to higher level of managementTuned complex stored procedures for faster execution and developed database structures as per the requirements in Oracle data warehousingFrequent Interaction with business users to understand the business requirements.Developed complex PL/SQL packages and procedures as per the business requirements for data transformation from one system to another.Prepared technical design documents.Environment: Oracle 10g, SQL Server 2008, SQL, PL/SQL, Report Builder and UNIXDuration : Jan 2008 Dec 2008 Technical Lead Consultant (Pune-India)Client : Schering-Plough, USAProject : Adverse Event Reporting System 4.5Roles and Responsibilities:Analyzed the business requirements for new report as well as existing report if any modification is required.Involved in development of various Interfaces.Prepared the code end review before delivering the code to the client.Handled queries from the working teams as well as from the client.Modified and creating package for performance improvement.Translated functional requirement into detailed technical requirement.Customized the AERS application using Oracle Report9i to meet client's requirements.Prepared test plans, test cases, and test scripts to validate conversion.Responsible for testing and validating the client requested modifications.Environment: Oracle 9i (Reports, PL/ SQL, SQL), SQL Server 2000, TOAD, Windows6#Employment ProfileCompanyTech Mahindra, Pune-IndiaDesignationSr. Associate-ProjectClientBritish Telecom, UKDurationMay-2007 Dec-2007Skill SetOracle (SQL, PLSQL), UNIX, Control-MRole and Responsibilities:Involved in writing and modifying packages, procedures, functions and viewsWorked on scheduling, monitoring, and supporting the batch jobs using crons.Prepared LLDs and Release scripts and Release NotesResponsible for support/ maintenance, which included on call support as well as EOD batch supportPerformed monitoring of database and space usageInvolved in unit/ performance testingEnvironment: Oracle 8i (SQL, PL-SQL), UNIX7#Employment ProfileCompanyIT-People, Dubai-UAEClientMercator, Dubai-UAEDesignationSr. Oracle DeveloperClientBritish Telecom, UKDurationJan-2007 Apr-2007Skill SetOracle (SQL, PLSQL), D2K (Forms, Reports)Role and Responsibilities:Worked on the production and maintenance issues as an individual team member.Developed tables, sequences, stored procedures, functions, packages, triggers, views, front end screen/ report using D2K (Forms/ Reports) and indexes for the developing business logic using TOAD.Responsible for testing and validating the client requested modifications.8#Employment ProfileCompanyUnited System, Muscat-OmanClientMinistry of Defense, Muscat-OmanDesignationSr. Oracle DeveloperDurationFeb-2006 Dec-2006Skill SetOracle (SQL, PLSQL), D2K (Forms, Reports)Role and Responsibilities:Worked on the maintenance issues as an individual team member.Developed tables, sequences, stored procedures, functions, packages, triggers, views, front end screen/ report using D2K (Forms/ Reports) and indexes for the developing business logic using TOAD.Responsible for testing and validating the client requested modifications.9#Employment ProfileCompanySatna Cement Works, IT Section, Satna, IndiaDesignationSystem AnalystDurationJul-2000 Jan-2006Skill SetOracle (SQL, PLSQL), D2K (Forms, Reports)Role and Responsibilities:Was involved Development, Maintenance, Enhancement and L3 support of the different application modules like finance and costing, sales and inventory management.Worked in front end development using D2K Forms/Reports and backend development in SQL, PL-SQL and Unix Shell scripting.EMPLOYMENT HISTORYOrganizationDesignationDurationWipro Limited, New Jersy-USATechnical LeadApril-2019-Dec-2021TCS,New Jersy,UATechnical LeadSep-2018-April-2019Infosys, Plano, Texas-USALead ConsultantAug 2018Aug 2018Fujitsu America Inc., Richardson, TX-USASr. Technical ConsultantSep 2016Dec 2017HSBC, Pune-IndiaAssociate Project ManagerMay 2016Sep 2016CTS, Pune-IndiaProject ManagerDec 2007June 2015TechM, Pune-IndiaSr. Technical AssociateMay 2007Dec 2007IT-People, Dubai-UAESr. Software-EngineerJan 2007 Apr 2007United System, Muscat-OmanSr. Oracle DeveloperFeb 2006 Oct 2006SCW (IT Section), Satna-IndiaSystem AnalystJul 2000 Jan 2006EDUCATIONM Tech (Computer Engineering) - OSPU, Odessa, Ukraine.B.Sc. Egg. (Computer Engineering) - OSPU, Odessa, Ukraine.AWARDS & RECOGNITIONReceived Rainmaker Award twice from Cognizant |
