SUMMARY:

• I have a total 8+ years of IT experience covering different horizontals (Software Development, Maintenance and Support & MIS Analytics) across various Banking Applications. I have more than 5 years of experience in developing and implementing enterprise - scale reports and dashboards using PL/SQL through various BI reporting tools such as Cognos, SAP Crystal Reports, and Tableau. Also I have vast experience with data warehouse technologies and ETL processes as well as data modelling concepts.
• In addition to this, I have 3+ years of Production Support experience using Mainframe technologies which includes good understanding of JCL, COBOL, DB2, IMS, CA7 etc. as well as support tools such as Maximo, JIRA.
• I have proven my excellence in analyzing business processes, eliciting requirements, defining business needs and translating it to BRD and Technical Requirement Documents, developing solutions, implementation and support.
• Also I am well competent in creating Requirement Traceability Matrix (RTM) to list all the requirements and ensured all required documents like Use Cases, Test Cases are well written and compiled. In addition to above knowledge, I have very good business knowledge in regards to Mortgage Banking, primarily servicing .

PROFESSIONAL EXPERIENCE:

BI Analyst / Developer / Oracle PL/SQL Developer

Confidential

• Strong understanding of Mortgage Servicing business model and competitive/benchmark landscape; recommend and drive best practice adoption.
• Managed communications with internal leadership teams within the organization to identify requirements and scope of reporting project.
• Created and maintained reports & Dashboards using PL/SQL, VB scripts and through other BI tools such as SAP Crystal Reports, IBM Cognos etc.
• Monitored and ensured timely delivery of daily operational reports
• Analyzed MIS reports to provide feedback and made changes whenever needed.
• Assisted reporting manager in the design of business reporting templates/dashboards etc. and automation of reporting requirement either through BI tools as well as via SQL procedures.
• Prioritized and handled multiple projects.
• Have very strong analytical skills that are required for BI analyst such as thorough understanding of how to interpret business needs and translate them in to application and operational requirement.
• Identified process improvement opportunities within the application by developing new strategies and improving processes as well as performances.
• Utilized knowledge of SQL programming, BI Software such as SAP Crystal Reports, IBM Cognos, Tableau etc., Excel and other optimization methods to perform quantitative and qualitative data analysis.
• Worked with business to capture requirement and conceptualize solution
• Worked with technical groups to create, implement solutions and maintain reporting processes.
• Conducted acceptance testing of reporting solutions.
• Created and delivered Ad-hoc reports as needed.
• Good Communication skills and expertise in MS Excel, MS Office.
• Very good knowledge in developing VBA macros.
• Excellent written and verbal communication .

Tools: / Software Used: SAP Crystal & CEC, Cognos 11, Tableau 10.3, Oracle 11g, Toad, SQL Developer, VBA Scripts

Data Warehousing / Data Analyst / ETL Developer

• Primarily focused on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.
• Strong Expertise in Datastage ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
• Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions).
• Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing.
• Developed mappings in Datastage to load the data from various sources into the Data warehouse different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Datastage sessions as well as performance tuning of mappings and sessions.
• Experience in system analysis, design, coding and testing. Extensive experience in the Data Warehousing implementations and Data Migration.
• Experience using Oracle 10g/9i, DB2, MS Access 7.0/2000, SQL, PL/SQL, SQL*Plus, TOAD.
• Experience in Database Development mainly using Oracle database.
• Experience with Data Cleansing, Data Profiling and Data analysis through SQL and PL/SQL coding.
• Wide Experience in Database Development including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk Binds, Capabilities of using Oracle Built-in Functions.
• Performance Tuning of Datastage Mapping and workflow.
• Business Intelligence experience using SAP Crystal Reports and working knowledge of Cognos.
• Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem solving skills to undertake challenging jobs. Able to work well independently and also in a team by helping to troubleshoot technology and business related problems.

Tools: / Software Used: IBM Infosphere Datastage, DB2, SAP Crystal Reports, Tableau, Oracle 11g, Toad, SQL Developer, VBA Scripts, Maximo, Remedy, JIRA

Mainframe Production Support / Developer

Confidential

• Ensured that Client’s applications are available and supported in line with defined system service level agreements.
• Acted as point of contact for Client application service interruptions; oversee all crisis and incident management processes.
• Implemented permanent bug fixes by doing root cause analysis and code changes for recurring issues.
• Analyzed production tickets assigned to group for all issues and made decision of permanent fix as code change.
• Coordinated with testing teams such as TCOE/CST to get the signoff for these changes.
• Ensure successful implementation of the changes by performing post implementation certifications as well as monitoring for the same
• Implemented minor enhancements to enhance user experience and reducing clarification calls.
• Ensure all the Online & Batch processes goes well for BOSS round the clock.
• Timely delivery of manually generated adhoc reports from the database.
• Involved in regular discussion with Onsite team/clients in every stage of the project to look proactively so as not to have any changes in the later stages of the project which might affect both cost and schedule of the delivery
• Allocating and monitoring of the work-items given to the team
• Delivered Analysis / Research / Data Reports/ Root Cause Analysis timely.
• Provided Daily/weekly status updates to Client Managers.

Tools: / Software Used: Mainframe z/OS, RSA, COBOL, IMS, JCL, CA7, FILI, ELIPS, JIRA, Maximo, PODS, Easytrieve, File Aid.