SUMMARY

• Over 16+ years of extensive experience in IT, managing project life cycle through all phases and providing high quality solutions along with IT Data /Enterprise architectural design and development experience using Agile, scrum and waterfall methodologies.
• Possess strong leadership qualities and critical thinking capabilities.
• Project management experience includes large and small scale software development with a strong technical background in systems architecture, database design. In - depth knowledge and experience in cost management, time management, risk management, and integration management.
• Expertise in IT project budget analysis, outsourcing strategies, contract management. Well conversant with the data warehousing & data modeling methodologies.

TECHNICAL SKILLS

Languages: R,JCL,SAS,REXX, CLIST,VB Script, XML,HTML, Shell scripting, Java, Java script, awk, PERL, SQL,PL/SQL, NO SQL and COBOL

Environment: s: Cloud/AWS (Amazon web services), Windows NT/2000/XP/7/10, MVS/ESA, UNIX/LINUX and OS/2

Databases: DB2, SQL Server 2008 & 2012, Oracle (10g, 11g & 12c), Oracle Application Server, VSAM, MS Access, SYBASE and DB2 Connect, Cassandra & Teradata.

ETL Tools: Informatica Power Center 8.6 & 9.6.1, Informatica Web Services 8.1, IDQ, MDM, ODI, and PL/SQL, BI Tools (OBIEE, MSBI (SSRS, SSIS & SSAS) & Tableau.

Tools: & Other Technical Skills: R Studio, TSO/ISPF, DevOps( Jira Jenkins, Confluence, GIT, GIT hub), XPEDITOR, SYNCSORT, PEGASYS, ENDEVOR, INSYNC, FILE-AID, SUPERC, ELIPS, OMEGAMON, QMF, SPUFI, CLIST, ABENDAID, CA-7, ESP,COMPAREX, Win Runner/ VATT,QTP/ Test Director, AQT, ESPT, Oracle ODI, Visual Source Safe, PC anywhere, VPN, Web services, TCP IP, FTP, SFTP, Microsoft Project, Visio/Lotus Notes, Microsoft Office, Visual Studio.NET, putty, FileZilla client, Visio & HP Fortify, Black duck, TOAD, SQL Developer, SQL Assistant, Teradata Studio, Selenium WebDriver & Eclipse, Sometimes, MS Live meeting, WebEx, CISCO Jabber and Adobe reader.

PROFESSIONAL EXPERIENCE

Confidential, Ashburn, VA

Sr. Data Architect / IT Technical Project Manager

Responsibilities:

• Designed and developed complex mappings using various transformations in Informatica Designer to load data from Flat Files, Oracle, SQL Server, Teradata and DB2 into the target Data warehouse / Data Mart.
• Developed parameter file templates and used parameters, variables to make mappings more flexible, developed shell scripts, awk scripts to automate the process.
• Managed and supported very critical production environments which run a large set of reconciliation from the different source system and expertise to identify root cause and implement the resolution of production processing issues.
• Expertise in UNIX shell scripting, job scheduling, communicating with the server using SFTP/ FTP/MFT and file management in various UNIX environments.
• Experience in ETL Production batch processing using CA 7 and ESP, developed JCL, PROCs to automate ETL jobs
• Expertize to maintain code repositories in Subversion SVN or GIT Hub. Prepare release plan, ITSM and Cherwell incidents to track the Production deployment and Processes impact.
• Integrated Jira, Jenkins with Endevor, Mainframe Version control tool to automate the build and deploy process
• Automated VEC sales systems health checks & DR activates using Selenium web driver and scheduled them using Jenkins/CICD pipeline.
• Played a key role to convert TCS (mainframe) system into VPF/ETL (Informatica 9.6.1).
• Expertise in performance tuning of reports by implementing star schemas for optimal performance, minimizing the number of reports on a dashboard page, checking explain plan using the SQL.
• Involved heavily in Single Biller (Vision5) Transformation initiative during 2014 through 2016.
• Designed and developed NT cycle jobs to Support Vision5 conversion.
• Played major role in Corporate Data Stewardship (CDS) migration, from SYBASE to DB2
• Played a key role in decommissioning of CDS Solaris servers.
• Played a key role in Knotts Island and Long distance Out of Franchise Migration, which has enabled RIBS shutdown.
• Heavily involved in Confidential Advanced Data Inc ( VADI ARBOR) Fast packets accounts Migration into NBBE( MDVBiller)
• Heavily involved in Frontier extracts and other deliverables, enabled West Cutover.
• Expertise in implementing complex reporting solutions using multiple BI like OBIEE, MSBI (SSRS, SSIS & SSAS) and Tableau.
• Fully accountable for supporting all day to day Operations, by resolving Center issues and Incident Records.
• Subject Matter Expert with End to end knowledge from Product offering, ordering through billing.
• Hands on knowledge from Field Operations, which is acquired during strike duties.
• Well versed in the on-site and offshore model.
• Expertize in mentoring junior associates, providing feedback; engage them in right tasks to improve their productivity & Resource planning
• Specialized in Change management activities, release processes, and program management activates
• Specialized in PCR (product change request) & WR (Work request) life cycle
• Acquired Sound knowledge in using many Confidential internal Tools like VCOP, Clarity, and Service now.
• Expertize in building secure applications and knowledgeable in data security
• Preformed source code scans using HP Fortify and fixed all vulnerabilities.
• Involved in the migration of NT UNIX and Windows servers & applications to AWS.
• Sound understanding of REVERS IRB process.
• Hands-on experience with agile development methodologies.
• Acquired a good understanding of Data Analytics, Big Data, data science and built various Machine Learning models(KNN, Linear Regression, Gradient, Association analysis) using R and R Studio.
• Expertize in building advanced queries using Teradata SQL assistant and Teradata Studio.
• Hands-on experience with the development of logical, physical data models, generate and execute SQL scripts using CA ERwin data modeler from conceptual models.