SUMMARY

• Over 13 years of experience in field of Information Technology with emphasis on system analysis, requirements gathering.
• In depth knowledge of Software Development Life Cycle (SDLC) and Agile Methodology with thorough understanding of various phases such as Requirements, Analysis/Design, Development, and Testing.
• Adept at creating Requirements Traceability Matrix (RTM), tracing test cases, use cases, functional requirements, and business requirements.
• Experience in business analysis using Microsoft tools such as MS Visio, Word, Access and Excel.
• Experience in gathering business or user requirements, developing Business Requirement Documents (BRD) and transforming BRDs to FRDs (Functional Requirement Documents).
• Assisted in documentation of Test Plan and Test Cases by tools such as Requisite pro, Enterprise Architect and JIRA.
• Experience in documenting business rules, operation's specifications, and interface specification solutions as the initiation point for modern technology requests.
• Written concise user stories with precise and accurate acceptance criteria in a true Agile/Scrum environment.
• Developed Use Cases and performed Design Analysis conductingfunctionality testing and User Acceptance Testing.
• Experience in translating business requirements from use cases into functional specifications using Analysis and Design.
• Experience with process modeling using Flow Charts, Sequence Diagrams, Activity Diagrams, UML and Use Cases.
• Experience with requirements elicitation techniques including conducting interviews, workshops, Joint Application Design (JAD) sessions, and building prototypes.
• Experience with D Confidential Mining, D Confidential Visualization and DEDs (D Confidential Exchange Documents).
• Experience in source to target mapping, writing queries and querying DB d Confidential using PL/SQL.
• Working experience on different d Confidential sources ranging from Oracle, Terad Confidential, SQL Server, UDB DB2, XML, flat files, Excel.
• Experience in d Confidential management performing d Confidential analysis, d Confidential discovery, gap analysis, and d Confidential mappings.
• Experience with BI Tools such as Cognos, Micro Strategy for generating analysis reports.
• Experience using Business Process Management and Business Rules Engine (BRE) technology.
• Multiple years of experience leading and carrying out all phases of full SDLC lifecycle enterprise system development, from planning, analyzing, designing, building, and testing new Client/Server applications, to maintaining and modernizing legacy Mainframe applications.
• Excellent communication, interpersonal, and analytical skills and a dedicated team player.

TECHNICAL SKILLS:

ETL Tools: Confidential InfoSphere D Confidential Stage v11.x/9.x/8.7/7.x, Designer, Director and Administrator, Confidential InfoSphere Analyzer, Ab Initio GDE v2.x, 1.13.25, v1.x, Informatica Intelligent Cloud Services (IICS), Power Center 10.x/9.x/8.x (Designer, Workflow Manager, Workflow Monitor, Repository manager), SQL Server Integration Services(SSIS).

Software Languages: SQL, T - SQL, PL/SQL, C, MS Office, HTML, MATLAB.

D Confidential base: Oracle 12c/11.x/10g/9i/8i, DB2 UDB v9.1, Terad Confidential v14.x/13.x, SQL Server 2012/14/16.

System Tools: TOAD, SQL PLUS, Oracle SQL* Loader, Golden, SQL Navigator, Erwin v9.6/8.x, MDH, Microsoft Visio, ER Studio, Cognos BI Studio, Rational Requisite Pro, Rally, Clear Quest, JIRA, Bugzilla, MS Project.

Methodologies: Dimensional D Confidential Modeling, Snow Flake, Star Schema, Facts and Dimension Tables, Agile/Scrum, Scrumban, WaterFall, IT service management, SDLC, UML, AWS/Azure Cloud computing, API, JSON.

Scripts: Korn Shell Scripting, AWK, Perl.

Operating Systems: DOS, Windows98, XP, UNIX, AIX, Sun Solaris.

Scheduling Tools: Autosys, ESP, Crontab, Ctrl-M, CVS.

PROFESSIONAL EXPERIENCE:

Senior Architect

Confidential

Responsibilities:

• D Provide ETL (Extract, Transform, and Load) and d Confidential analysis skills as part of a project team building a d Confidential warehouse and marts utilizing Mayo Clinic's UDP (Unified D Confidential Platform) and MCL(Mayo Clinical Laboratories).
• Design, build and support complex d Confidential warehouse and mart architecture to support various OLTP and OLAP systems. Create source to target mappings and provide recommendations to DBA and project team on modelling and design upgrades.
• Utilize Confidential D Confidential Stage development tool to Design, Develop and Test ETL integration code for process report, validations and control entities. Create best practices and coding standards for ETL development team tasks and performance tuning methods using Confidential D Confidential Stage tool. Create specialized ETL jobs to support the movement and transformation of lab d Confidential . Involved in common mapping and transformation of various d Confidential elements.
• Analyze d Confidential from several sources and follow design principles and software development methodologies. Provide technical solutions to d Confidential warehouse personnel performing system and software development tasks including the review of products for quality. Understand project requirements and participate in requirement reviews.
• Review and sign off for deliverables. Perform story and task tracking using agile methods and provide daily status reports to concerned leads/managers.

Solutions Architect

Confidential

Responsibilities:

• Design, Architect and Develop NextGen ETL integration code using Confidential D Confidential Stage, SSIS and Unix scripts for process report, validations, control entities. Perform agile story tracking to provide daily status reports to leadership.
• Responsible for load management of d Confidential sources along with targets. Involved in common transformation of d Confidential elements.
• Design and build d Confidential warehouse architecture to support various OLTP systems. Also working on upgrading to cloud-onsite futuristic model using Azure and BLOB storage settings. Work with client delivery pods in Scrum & Kanban environment.
• Create best practices and coding standards for ETL development team tasks and performance tuning methods. Schedule ETL jobs as part of contingency and automated batches. Use UNIX shell scripting to create interfaces. Designed packages in SSIS with various complex transformations as derived column, conditional split, lookup, aggregation, execute SQL.
• Analysis of legacy systems to design, develop and migrate over to the new ones. Work on product Release/project Delivery and maintain relevant documentation. Conduct Unit, Performance and System Integration testing and interact with technical teams on daily basis.

Lead Systems Analyst

Confidential

Responsibilities:

• Provide technical directions to DWH personnel performing system, software development tasks including review of products for quality. Coordinate with Project Manager to ensure problem solution and customer satisfaction.
• Prepare milestone status reports and presentations on system concepts. Also develop and document high-level design and functional specifications, Source to Target mapping, UML etc.
• Using enterprise architecture to design models, UML, prototypes, use cases, etc. to support project requirements.
• Produce user-story deliverables related to the project(s) assigned and assist in implementation support using Agile projects.
• Make recommendations for approval of major computer system installations and provide daily supervision to supporting analysts and technicians. Also review business requirements, technical designs, and test artifacts.
• Responsible for the design and development of IT solutions based on business requirements documents. Assist business analysts by clarifying requirements during requirements development. Responsible as SME for development and test teams. Use results of d Confidential analysis in planning, design and problem resolution. Used Rally for story points, grooming.
• Create and modify physical, logical d Confidential models to assist with project releases. Also reverse engineered models when required. Created various DDLs and uploaded them to project specifications to maintain sanity.
• Analysis and resolution of production issues. Production support on a rotational basis with team.

Lead DWH Analyst

Confidential

Responsibilities:

• Worked with sourcing and marking the supply and end systems with Visio structures/ documents.
• Analysis of d Confidential volumes/req to assess complexity of jobs. Utilized to support business statistics for resource estimations.
• Led and managed an archival project involving d Confidential migration from main tables to staging tables and subsequently separate archival schemas to hold legacy information. Worked with stakeholders to gather business requirements and converted them to functional and technical specifications. Analyzed business process and identified improvements for processes.
• Organized and led requirements elicitation meetings and work sessions with business sponsors, users, stakeholders.
• Developed both high-level and detailed business, user, functional and non-functional requirements and related documentation to support business needs.
• Developed User Stories based on business and system requirements and defined and elaborated user stories with validation and acceptance criteria. Developed and maintained Requirement Traceability matrices (RTM).
• Supported development and testing teams by providing clarification of requirements during Development and Testing. Assisted with policy and procedure development. Met end-users to analyze problem reports and enhancement requests.
• Prepared reports summarizing findings and consolidated recommendations based on best practices and industry standards.
• Worked with business stakeholders to ensure solution meets business requirements and could be successfully implemented. Helped scheduling teams set up production ETL jobs and UAT A-B schedules in close coordination with mgmt.
• Maintained project plans for WBS and efficient work allocations. Also, created multiple DDLs maintaining appropriate partitioning on tables with keys as dates etc. and relevant indexing methods.

Lead DWH Systems Consultant

Confidential

Responsibilities:

• Worked with identifying and marking the source systems with DMD (d Confidential modelling documents).
• Helped architecting a new layer for integrating various modules for cleansing and transforming d Confidential between SGH (Singapore), MYH (Malaysia) and IMO (Indonesia) models. Worked with various global, customized and local elements between different country specific regions to support the warehouse loads.
• Managed a Conceptual model using ERwin based on requirements gathering and analysis. Developed further normalized Logical and Physical d Confidential base models to design OLTP system for commercial banking applications as Cards and Customers.
• Assisted teams with Master d Confidential management (MDM) to manage critical entities stored and distributed in multiple domains as customers, stores, products, etc. which helped to achieve user defined results.
• Worked consistently with multiple IT Teams to successfully size, execute and maintain the operation of a variety of internal and third-party applications. Developed concise & effective user stories with accuracies in a true Agile/Scrum environment.
• Conducted JAD sessions to collect the system requirement specifications (SRS) and maintained RTM(requirement matrices).
• Translated stakeholder requirements into various documentation deliverables such as functional specifications, Non-functional specifications, technical API specification, use cases, user stories, workflow/process diagrams.
• Worked with commercial banking projects with a new division for migration of reporting elements from demising legacy systems to upcoming ones. Involved heavy d Confidential mapping and manual feeds to design an automated system.
• Interacted with all the business units in GLT to facilitate the implementation and migration of new products, services.
• Involved in creating Requests For Proposal (RFP) for large transformational initiatives defining the integration of systems. Conducted GAP, Root Cause Analysis and recommended the alternatives to streamline the process flows.
• Created test scenarios and developed test plans to be used in testing the business applications and UAT efforts.
• Generated the D Confidential Information Gathering Report, Requirements Document and Technical Analysis Reports.

Senior ETL Systems Analyst

Confidential

Responsibilities:

• Worked with the whole DWH development life cycle (SDLC) ranging from requirement gathering to assisting production support activities. Identified the requirements and analyzed source systems. Designed Star schemas for the detailed d Confidential marts involving conformed dimensions.
• Supported Delivery Manager and Technology Directors by facilitating project management activities including scope estimations, identifying deliverables, resource assignments, dependencies, resource management, developing schedule & budget baselines, tracking progress, performing change & risk management while adhering to business guidelines, risk assumptions and risk profiles. Used Agile/Scrum methodology to work with sprints for better execution of Claim projects.
• Worked with Stakeholders to understand the requirement and create HLD/Detailed designs. Analyzed Requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using Visio.
• Responsible for setting up weekly meeting and walkthroughs for project updates and to devise a plan to detect and handle bottlenecks. Assisted with project planning, quality analysis, user requirements and reconcilement procedures.
• Made sure the process worked effectively by accepting bug requests, prioritizing it, determining availability of QA resources and assigning the tasks. Worked with project managers and attended weekly meetings to keep the processes updated.
• Performed analysis and design workflow for various processes by document Business Use Cases, System Use Cases and create Process Scenarios. Used different test environments to implement versions of codes before the production releases.
• Worked as a lead to perform system and UAT testing for the Agile project. Created Acceptance Criteria for each user story in the product backlog for the Agile project. UsedProject Management Frameworkin(RTC)fortracking work items, reporting.

BI Systems Analyst

Confidential

Responsibilities:

• Worked with Analysis and Architectural Design/Development of the PBM and Rx Claim integrated systems.
• Documented user requirements, translating requirements into system solutions and developing implementation schedule.
• Helped designing enhancements for few modules/subject areas as Drugs/Customer/Claims/Location/ Confidential t.
• Design, development and implementation of the Decision Support System.
• Supported various test modules for integrated and system testing of ETL codes and maintained Requisite pro for functional requirements/Test models. Supported service desk ticket resolutions from production environments.

Systems Programmer Analyst

Confidential

Responsibilities:

• Extracted d Confidential from various sources like Mainframe ODBC, Oracle, DB2 UDB, Fixed limited files, Sequential Files and Flat Files. Worked with SQL loader and Unix shell scripts to perform loading, update and maintenance of various tables in Oracle Warehouse. Worked with control files to perform the functionality.
• Helped in migration from Oracle 10g to DB2 UDB using SQL, PL/SQL using various Stored Procedures, Functions, Cursors and Triggers. Used Autosys. crontab extensively to schedule various jobs & several UNIX shell scripts to facilitate automation.
• Identified and documented business rules and created detailed Use Cases. Conducted periodic check-point meetings with the business users to ensure functional specifications were in line with the business requirements
• Used the MS Office Suite extensively, which included MS Word, MS Excel, MS Access, MS Visio and MS PowerPoint for project documentation and report analysis
• Developed PDM (Personal D Confidential Mart) to extract information from DB2 UDB tables to generate various flat files according to the reporting requirements. Worked with external JAVA UDFs and procedures to perform the process.
• Extensively used FTP (post-processing stage) to transfer the files between various machines. Used shell scripting to manage the FTP and emails between various systems.