SUMMARY:

• Software Developer possessing over 5 years professional experience in data warehousing solutions, business analysis and project management successfully completing complex projects in Industrial Automation & various Banking domains such as Mortgage, Business Development and Information Technology. Excellent requirements elicitation, structured analysis and project execution.
• Gathering business requirements via client interaction sessions on daily, weekly and monthly basis
• Extracting data from various sources, transforming it to fit operational needs and Loading it into the end target database
• Programming with Teradata utilities such as Bteq, Fast Export, MultiLoad, FastLoad and Tpump and Unix protocols such as ssh, sftp, scp, etc.
• Extensive experience with Data optimization, requirement gathering and Data reconciliation
• E2E Testing the entire application through Development, Integration and User Acceptance phases
• Writing Unix shell scripts & korn shell scripts to automate processes
• Conducting query performance tuning for the production queries and thereby reducing the production environment load
• Performing improvisation of highly skewed database - tables/views on Teradata & MS SQL Server to reduce database impact
• Data Migration of 80+ legacy reports from SAS code having SharePoint Reports to Teradata, Unix Code with IBM Cognos reports.
• Using IBM Cognos and QlikView for reporting, analytics and monitoring business developments
• Being a subject matter expert in key MI systems thus ensuring integrity of data and product hierarchies

TECHNICAL SKILLS:

Programming Languages: Teradata, Teradata Utilities, UNIX, MS SQL ServerPowerShell, Oracle, PL/SQLSAS, ASP .NET, GIT

Applications: WinSCP/Putty, Teradata SQL Assistant, Microsoft SQL ServerOracle, Microsoft Visual Code, Windows Powershell ISE

Scheduling Assistants: AUTOSYS, IBM Tivoli (TWS)

Defect Tracking: HP Quality CentreBarclays ServiceNow, ServiceFirst, JIRA

Reporting/Project Management: Microsoft Visio, MS OfficeIBM Cognos, Confluence

Beginner Level: C, C++, Java, ASP.NET, GitHub, Mainframes

WORK EXPERIENCE:

Confidential

Product Configuration Engineer

Responsibilities:

• Harnessing power of under-utilized data to empower businesses to make informed decisions
• Partnering with various manufacturing industry leaders to build a predictive analysis software platform that identifies problems even before it happens thereby saving money, time and lives.
• Responsible for Configuration management of the complex analytics platform using cutting-edge tools in the fields of distributed systems, data Ingestion and mapping and machine learning
• Working in a fast-paced DevOps environment, with continuous development/integration of software solution on the cloud platform
• BAU tasks include configuring in house CRM application using MS SQL, Powershell, GitHub, Web Application Development in ASP .NET & managing user tickets/issues via JIRA.

Confidential

Senior Analyst Developer

Responsibilities:

• SAS Migration: Over 80+ legacy reports were migrated from SAS/SharePoint to Cognos using Teradata, Unix shell scripting & SSIS, involving attention to detail, multiple UAT cycles and enhancement of reports with updated business rules
• Monitoring existing SSIS Packages using MS Visual Studio & existing query scripts on MS SQL Server as BAU tasks to ensure smooth run for daily load processes from Oracle - MS SQL - Teradata.
• Ensuring that all activities and duties are carried out in full compliance with regulatory requirements, Enterprise Wide Risk Management Framework and internal Barclays Policies and Policy Standards
• Working in close partnership with the business, providing data analysis & reporting support to identify vulnerabilities, opportunities and business requirements
• Interpret and explain performance within the business on a weekly, monthly and ad - hoc basis
• Working closely with Risk Team to ensure daily risk reporting and back testing is completed within the agreed framework and policy

Confidential

Business System Analyst

Responsibilities:

• Work alongside the UK team in respect of key planning assumptions and prepare financial forecasts, identifying risks and opportunities
• Assist in requirements and analysis sessions with Clients to process requests for support, functionality, data group access for various systems and ensure appropriate access security overall revenue data and distribution lists
• Owning a number of key reporting processes and ensure that accurate and robust analysis are delivered to Senior management on a timely basis - this includes daily, weekly and monthly reports
• Provision reporting ensuring systems are reconciled and enriched using IBM Cognos, SAS reports on SharePoint
• Upgraded & migrated legacy reports/functionalities from SAS reports to interactive dashboards using Teradata, MS SQL, SSIS, Unix shell scripting, Oracle, IBM Cognos & Qlikview

Confidential

Senior System Engineer

Responsibilities:

• Analysis of the business requirement, design, builds and testing the application
• Preparing Load Plan/Implementation plan and providing assistance in deployment activities
• Fetching information from various sources on daily, weekly or monthly basis and extract-transform-load (ETL) the processed data
• Technical expertise in data models, database design development, data mining and segmentation techniques
• Acquired data from live data sources and maintaining data quality in large-scale database/data systems
• Strong knowledge of and experience with database programming, ETL frameworks and process automation using Teradata utilities, BTEQ, Shell scripting

Confidential

Developer/Data Analyst

Responsibilities:

• Analysis of the large-scale system based on client requirements and formulating a procedure to provide preferential services to customers using Bteqs and korn-shell scripting
• Use of Teradata SQL scripting & Teradata Utilities such as FastLoad, FastExport, MultiLoad within Bteqs in shell scripts to extract, load and transform data from source to target systems