SUMMARY

• Professional with around 8 years of experience in financial industry
• Over 6 years of experience working on SQL, UNIX, Shell scripting, FTP, MAILX and automation
• Worked on quick turnaround adhoc analysis requests using SQL and Excel Pivot tables
• Experience in troubleshooting, Problem resolution, and root cause analysis for data loads
• Worked with multiple teams involved in gathering requirements, testing, development and support
• Worked on large data warehouse involving fact and dimension star schema modeling
• Excellent team player, worked in agile environment and able to work independently
• Experience of release management, change management and process management
• Created test cases and help team execute them to achieve deliverables on time
• Worked on black box and white box testing techniques
• Extensively used different modules Regular expression, Mechanize, File, DBI for data extractions in Perl
• Experience in data mapping, production support, query tuning, report building and analytics
• Strong working experience of different flavor of UNIX
• Strong experience in creating JIL in Autosys and batch automation
• Strong experience in Shell scripting in BASH.

TECHNICAL SKILLS

Databases / Languages: Sybase, Oracle 10g, UNIX, MYSQL, Shell Scripts, Perl, XML, PL - SQL

Database Tools: DBArtisn, Sybase Central, Oracle TOAD, SQL Developer

Reporting Tools: Microstrategy, Excel Pivot Tables, Access, MS Excel

Operating System: UNIX, LINUX, Windows, DOS

Job Function: SQL & UNIX Developer, Data/Business Analyst, Testing, Perl Developer

Other Skills: Putty, JIRA, BugZilla, SVN, Autosys, Crontab

PROFESSIONAL EXPERIENCE

Confidential

UNIX-Shell scripting Developer

Responsibilities:

• Provided Data Analysis, gathered Business requirements, Designed and developed various Business Reports
• Created reports using SQL, MS Excel, UNIX, Shell scripting and Perl
• Efficiently used different modules like File, DBI, Data-Dumper, Regular expression etc. for data mining and data extractions, and data validation in Perl in Unix Environment.
• Expertise in Perl data s and data structure
• Extensively worked on loading flat files from UNIX to Sybase database using shell scripts
• Monitoring the existing code performance and to change the code forbetter performance
• Strong experience in writing Perl scripts, Shell scripting covering data feed handling, implementing business logic.
• Extensively Performed data validations using Shell scripting, Data integrity before delivering data to operations
• Good working Experience in database monitoring and data stewardship
• Developed complex SQL queries using sub queries, left outer joins, volatile tables, multiset and derived tables
• Worked extensively on date manipulations in Teradata using update statements
• Analyzed data by pulling data from data warehouse into MS Excel and build graphs.
• Used Sybase Central and DBArtisn for SQL Assistant to build the SQL queries
• Script automation using UNIX Scheduler, Shell scripting and FTP/EMAIL files
• Query and table tuning by using collect statistics and explain plan
• Pulled data using reporting tool and supported reports
• Data presentment using Excel Pivot tables, text flat files and user tables.
• Worked on data issues using problem solving skills
• Extensively used Autosys and worked on batch automation.
• Written shell scripts and regular Expression to extract data from raw data/file.
• Wrote complex queries and worked on query tuning on database.
• Wrote scripts in Shell to extract data from log and generated statistics report for higher management and regulatory team
• Client facing role, supporting existing applications and development of new processes.
• Coordinated with various horizontal teams which included data quality checks, team members, tracking deliverables, code release management and tasks management.
• Prepared daily/weekly/monthly dashboard data reports with drilldown functionality
• Worked on SQL query tuning and performance enhancements of stored procedures
• Worked in an agile environment with multiple teams IT & business teams
• Requirement gathering and extensive coordination with the project team
• Shell script automation using Nohup and Scheduler in Unix environment.
• Worked on SVN for version control in Unix Environment
• Worked on UAT and production environment to identify potential data defects.

Environment: Sybase, Perl, UNIX, Shell Scripts, Ultra Edit, Notepad++, DBArtisn, SQL, Sybase Central

Confidential

UNIX - Shell scripting Developer

Responsibilities:

• Basel 3 implementation to improve the banking sector's ability to absorb financial risks
• Developed highly complex tables, views, procedures, SQL shell scripts, query performance, excel pivot tables. Use data for analysis and determine root cause of a business problem
• Analysis & calculations by working on VAR (Value At Risk) for identifying potential Credit risks
• Worked on batch performance through data processing using Perl, Shell scripting and Unix.
• Conducted team meeting for release, prepared release note and got customer approvals
• Prepared financial and data reports for the users to compare system results with historical data on daily/weekly basis as per the requirements
• Provided s to the new team members on change management, release management and project workflow as per the process.
• Preparing monthly, quarterly reports for FSA (Finance Service Agents) and JFSA (Japan Finance Service Agent) based on Month end data processing
• Created UNIX reports & flat files using SQL and UNIX
• Monitoring the existing code performance and to change the code forbetter performance
• Extensively Performed data validations, Data integrity before delivering data to operations
• Data presentment using Excel Pivot tables, text flat files and user tables.
• Worked on data issues using problem solving skills
• Validated already fixed data defects and ensure data quality before releasing the fix in production
• Worked in an agile environment with daily standups involving multiple teams
• Used JIRA application as a defect tracking tool where defects were assigned to the team
• Business Analysis, Defect Analysis, Data Analysis by writing complex SQL queries
• Extensively Performed data validations and Data integrity before delivering data to production
• Developed SQL queries using sub queries, inner joins, left outer joins
• Worked extensively on date manipulations in Sybase using update statements
• Documented business process and steps for the team for purposes
• Used aggregation functions, case statements and limit conditions in SQL queries
• Worked across different time zones in US and offshore teams
• Worked on batch performance through data processing
• Completed Unit testing and manual testing for the assigned Jira.

Environment: Sybase SQL, UNIX, Shell Scripts, Perl, MS Office, JIRA

Confidential

Programmer Analyst

Responsibilities:

• Testing of different data sources, peer reviews, performing GAP analysis during issues and extracting data using row expressions
• Guided team members to develop efficient modules to crawl sites using multithreading concept to save time and resources.
• Suggested and developed automation tool to keep track of QA and development time and performance to have better transparency.
• Prepared reports for higher management to keep track of Payments/Billing from client for the completed crawlers and crawlers in pipeline.
• Worked on data mining and coordinated with QA team and improved application performance.
• Co-ordinated with different level of hierarchy and prepared data reports in Excel.
• Implemented process of Unit testing and peer to peer testing to save QC time.
• Worked on Unit testing and manual white box testing.
• Executed test cases for the manual testing
• Worked on Perl, Shell Scripting in Unix environment to generate XML output.
• Worked on JIRA and BigZilla to keep track of bugs raised, reviewed, fixed and re-opened.
• Used Oracle Developer suite and MS Access to build front end data entry forms and reports
• Requirement reviews and approvals with the administrators and coordinators to ensure that the front end forms and reports are accurate
• Entered historical data manually and by using Excel macro based tools
• Developed business logic using Oracle PL/SQL

Environment: TOAD (Tool for Oracle Application Developers), Perl, MS Office, JIRA, BigZilla, Oracle