| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Lead ETL developer, Data AnalystCell# PHONE NUMBER AVAILABLE,PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLECurrent Location: Cleveland, Ohio, USA.Career objectiveI am eager to contribute to development projects that enable data to business as a strategic asset.Professional summaryOver 18+ years of Analysis, Designing, ETL development, management experience for providing Business Intelligence solutions in Data Warehouse and Database Application development with concrete understanding of Banking and financial business processes. I have played a key role inlarge scale data warehouse analysis, designing, creation and migration, and have led efforts to optimize data handling, ultimately achieving significant improvements in data processingefficiency.Extensive work experience in the US banking and financial service industry with expertise inRetail Banking, Lending, Credit Card payments. Hands on experience on Banking and RegulatoryCompliance i.e. Anti-Money Laundering (AML), Basel Accords, Dodd-Frank Act, Customer Identification Program (KYC/CIP).Proficient knowledge of Corporate Finance, quantitative analysis, balance sheet analysis, General Ledger Reconciliation, financial modeling, and financial statements forecasting.Experience in Data Governance activities Data Analysis, Data Profiling, Data Quality,Data Mining, Data Migration, Data Integration, Data Mapping, Data Cleansing andConfiguration Management.Proficient experience in ETL (Extract, Transform, Load) in Microsoft SQL Server, Oracle, SSIS,Informatica development.Strong experience in PL / SQL development and query performance improvement.Proficient experience in Relational database systems(RDBS) like Microsoft SQL Server, Oracle.Proficient experience in data integration and ETL skills like SSIS, Informatica from various data sources like XML, Flat file, CSV, Excel, and various databases to Data warehouse.Experience in Business Intelligence (BI) tools like Microsoft Power BI, Tableau for analyzingdata and transform into a model and dashboards which can be used by management to takevarious decisions.Hands on experience to work with Python and its functionality with various Databases.Expertise in developing various Database objects like stored procedures, functions, triggers,cursors, User defined functions.Expertise in database migration from Microsoft SQL Server 2008R2 to 2012, 2012 to 2016 and 2016 to 2019.Proficient in all phases of SDLC (Software Development Life Cycle) and Agile methodologies.Hands on experience on Cloud services like Microsoft Azure Data factory, Microsoft Azure for SQL.Expertise in working with multiple data center environments and private cloud infrastructure.Proficient experience in working, coordinating, managing offshore onsite working model.Experience with technical management of project with strength of 65+ team members in the crew based agile development approach.Expertise in automating manual efforts and process improvements.Experience with Servicenow incident creation, management, closer. Creation ofChange Request(CR) and using various Servicenow tools.Experience in version code control tools like Git Bash, Microsoft Teams Foundation (TFS),Bitbucket. Using CI/CD Git Pipeline for code integration and deployment for each environment like Dev, Test, QA, Production.Experience in working on Dynatrace, Truesight automated server and its resource monitoringtool.Expert in working and managing Jira and using it for sprint management and taking it tostory closures.Professional ExperienceOrganizationTata Consultancy Services Ltd.ClientPNC Bank National Association, Strongsville, Ohio, USAPeriodFeb - 2012 till dateRoleLead ETL developer, Data Analyst DatawarehouseResponsibilitiesHelps PNC bank to implement various Federal Reserve regulations across all the data warehousesImplements merger and amalgamation strategy of other banks into PNC. In this process I had analyzed, Designed and ETL data from other banks data repository to PNC bank Data Warehouses.Working with Business analyst of PNC bank to understand the requirements and on that basis design dataflow, creating data mapping, Designing ETL integration activities with SSIS, Informatica to load data into various data warehouses.Creation of Business Requirement documents on the business logic.Building Business intelligence development framework to build data warehouse applications. In this we had utilized integration tools like SSIS, Informatica.Development of SSIS packages for data warehouse to Extract, Transform, and Load data from various sources to a data warehouse. Every day it extracts, transforms, loads 100 GB of data by 200+ SSIS packages in whole data warehouse.Design and develop Informatica mappings, workflows, sessions.Extract Data from mainframe in CSV files and getting those files from Mainframe to NAS location through Connect Direct.Implementation and management of project with strength of 65+ team members in the crew based agile development approach.Coordination between DBA, business analysts, development team and testers to make sure development and validations are in synch.Development, validation and implementation of Data Wareshouse applications in various environments like Development, Test, QA, Production.Involved in creating Unit Test Cases and Test Scripts.Data analytics with Power BI, Tableau to create reports on dashboard and present it to management for decision making.Help management to take optimal decision for various business products.Database conversion from Microsoft SQL Server 2016 to Microsoft SQL Server 2019 for large data warehouse systems.Participation in data center Disaster Recovery activities to check disaster readiness and maintain application RTO.Build framework to reduce clients costs and development efforts.Team management with technical development and coordination.Production support and monitoring.Technical SkillsDatabase Tools: Microsoft SQL Server 2016,2019, OracleIntegration tools: SSIS 2016, 2019, InformaticaBusiness Intelligence tools: Microsoft Power BI, TableauIncident and CR management Tool: Service NowDeployment tool: IBM uDeployCode Version Control tool: Microsoft Teams Foundation (TFS), Git(CI/CD pipeline), BitBucket repositoryProject Management tools: Jira, Confluence, MS Teams, Visio, MS Outlook, MS OfficeAchievementsAutomate manual production monitoring with Microsoft SQL server scripts. This results into $100K/year cost saving to client. It also saves 3000 hours/year production monitoring efforts.I had worked in application migration from MS SQL Server 2016 to 2019.I had planned all the migration activities start from Development environment to Production so it can be validated at various levels.I had developed various commands to deploy code through uDeploy automatically this reduces development efforts for 1 hour on daily basis.I had planned mock deployment as well so any issues can be identified and resolved in pre-production environment only.Due to user interaction in pre prod environment I had identified all the users and made them aware about application outage so that they can plan their activities accordingly.I had worked on various query performance improvements to save query execution time which improves processing time. Ultimately results into efforts and costs saving.Due to planning and deployment strategies we didnt get any post deployment error.Built library of models and reusable knowledge-base assets to produce consistent and stream lined business intelligence results. We had developed KEDB ( Known Error Data Bank) so commonly known error can be handled by care center agents so those things will not come to developer. This process improvement saves manual efforts of 3000 hours / year.OrganizationTata Consultancy Services Ltd.ClientCitibank Financial Services Kolkata, West Bengal, IndiaPeriodJuly 2010 Feb 2012RoleSenior Delphi Developer, team leadResponsibilitiesCreating Stored procedures, Cursors, Oracale packages.Integration between loan origination application and Oracle database.Code review and improvement.Implement various US Federal Reserve regulations in home loan applications.Code development for DLL, Exe as per user requirements.Coordinating between business analyst, developers, and Quality analysis team so all the teams are on the same information page.Code changes and deployment for various user suggested changes.Closely worked with migration team.Worked on various vendor based products toTechnical SkillsFront End tool: Delphi for .NetDatabase Tools: Oracle 9iAchievementsI had worked in application migration from Delphi to Java.I had planned all the migration activities start from Development environment to Production so it can be validated at various levels.I had worked on various Federal Reserve implementations like RESPA.I had led a team of 10+ associates.OrganizationCygnet Infotech PVT . LTD, Ahmedabad, Gujarat, IndiaPeriodSep 2005 to July 2010RoleDeveloperResponsibilitiesDeveloping Delphi objects.Developing Microsoft SQL Server Database objects like Stored procedures, functions, cursors.Discussing and finalizing application requirement.Design and development of application according to requirementUnit Testing.Application deployment.Technical SkillFront End Tool: Delphi 7, Delphi 9, Delphi for .NetDatabase Tool: IBMS, Microsoft SQL ServerVersion Control: Microsoft Teams Foundation ServerReport tool: Rave ReportsTechnical skillsSoftwareDatabase: Microsoft SQL Server 2019, 2016, 2012, 2008R2, PL/SQL, Oracle 8i PL/SQL, Oracle 9i PL/SQL, Oracle 10g, Interbase Database.Firebird Database.Data ETL tool: Microsoft SQL Server Integration Services(SSIS) 2019, 2016, 2008, InformaticaBI Tools: Microsoft Power BI, TableauDatabase monitoring tools: Truesight, DynatraceImplementation tool: Service NowSoftware Development: Delphi 7, Delphi 2006, Delphi 2007, Delphi 2009HardwareWork on the integration of Cash Drawers, Printers, Sales Receipt printers with Point of Sale Systems etc.ToolsMicrosoft Team foundation Server, IBM uDeploy, ServiceNow, Truesight, Dynatrace,CitrixHP Quality Center 10.0Visual Source Safe Version Contorl System 10.0Rave Reports Reporting tool.Report builder Reporting tool.JEDI version control system.Adobe Output designer reporting tool.SDAC database components.MethodsAgile, Software Development Life Cycle (SDLC), 3 tier Client server approach.DomainUS Banking,Retail Lending,Banking and Financial Services 2.2, Point of Sales System, CRM, Security management System, Health CareManagement ExperienceIn my all the assignments I handled the team of 65 or more members. Each and every time I try to give my best to them and fetch the best efforts from them also because for me leadership is a two way communication. I also gain respect and knowledge from my team members.I always keep defect at its minimum level i.e. at the development level which also reduces the UAT defects in this way I achieved a total defect count ration of 90 % in my all assignments as a team leader.I always try to keep all my team members and my onsite counter part at the same information level which also helps me to reduce defect count.To resolve any issue my approach is to Root Cause Analysis, so first I determine what is an actual problem, after that I determined its effects in various parts and then I determine its solutions.Business DevelopmentI had been part of various project proposals and successfully take them to the closures. I lead the following regulatory projects to satisfy client's requirements which will help them to grow their business and meet government regulations and in that way I obtained business process knowledge also.1) Preemption2) Uniform Loan Delivery Dataset3) GSE Appraisal Value Method.4) RUSA5) Fraud and CollateralI also developed various Oracle database objects like functions, Stored procedures triggers to achieve business objects.Education SummaryQualificationSubjectPercentageMASTER OF COMPUTER APPLICATIONSoftware Engineering63.79BACHELOR OF COMMERCEAccounts67.43 |
