Sas Programmer | Onsite Application Lead Resume
San Antonio, TX
SUMMARY
- Certified Scrum Master with 11+ years of experience in Agile Project Management, Enterprise Data Management, Data Warehouse Implementation, Data Analytics Initiatives, System Integration and BI Consulting across Banking, Insurance and Healthcare Industries.
- Plan, develop and execute a series of agile projects in Data management andBIspace, which helped business in making more informed decisions and achieve operational excellence. Focus areas include Enterprise Datawarehouse, Healthcare Analytics, Financial Datawarehouse, Member Analytics, Credit Card Analytics, Campaign Management, Bank Collections Analytics and Credit Card Campaign Effectiveness.
- Excellent in Agile SCRUM implementation, expert at driving the adoption & enforcement of Scrum rules, removing impediments and fostering self - management. Utilized Agile Scrum practices to help the team increase their velocity by 63% within the first year of agile adoption.
- Functional as a Scrum Master with comprehensive knowledge of Scrum Methodology. Capable of bringing overwhelming enthusiasm and awareness to projects, applying expert judgment to the removal of impediments, keeping teams focused and delivering success in rapidly evolving and dynamic environments.
- Facilitated agile adoption retrospective for the organization with the leadership and guided teams with actionable outcome resulting in enhanced performance. Provide leadership and mentorship to the team.
- Enforced Kanban principles as a Scrum Master that resulted in reduction of cycle time by 20% thus increasing team's throughput in less than 8 weeks.
- Lead daily stand-ups and scrum ceremonies for multiple scrum teams. Work with product owners to groom the backlog and plan sprints. Track, escalate and remove impediments. Report at daily Scrum of Scrum meetings. Track burn down, issues and progress in Jira. Work with component teams to resolve issues.
- Responsible for establishing and managing the framework for governance of Scrum and promote better visibility of scrum teams. Establish schedule and process for product demo’s and facilitate across scrum teams.
- Build high performing teams, build shippable product, and be responsible for leading agile project coordination to support various upstream and downstream teams. Coaching agile teams to enhance scrum.
- Coached new Scrum Masters and trained global teams, which resulted in early delivery of project and reduced process waste caused by lack of common understanding.
- Implemented Agile Scrum Methodology throughout the organization to improve communications between Engineering, Product Management, and Business to provide more transparency across the departments and to obtain great business value with short turnarounds.
- Facilitated Release Planning, Sprint Planning, Backlog Grooming, and Retrospective meetings. Spearheaded migration from Waterfall process to Agile (SCRUM, TDD, Build Management and Continuous Integration).
- Serves as the servant leader for the team to ensure clear communication and organization of the team, along with maintaining the product backlog, release plan and facilitating the core scrum ceremonies
- Experience in RDBMS & Data warehousing concepts and expertise in leading/executing all phases of a DW projectlife cycle which includes Scope Study, Requirements Gathering, Architecting, Design, Development, Implementation, Quality Assurance, Application Support for end-to-end IT solution offerings in BI space.
- Oversee the day-to-day progress of Agile, Waterfall & Hybrid based development projects and release initiatives with regard to time, budget, scope and quality.
- Functional as a Senior BI Consultant / SAS Programmer with extensive expertise in Base and Advanced SAS for developing SAS applications, proficiency in data science, data analytics, data mining, campaign analytics, market research and forecasting with expertise in consumer segmentation and customer profiling.
- Functional as a Lead ETL Developer and has strong Data Warehousing experience using Informatica Power Center with client tools like Designer, Repository Manager, Workflow Manager and Workflow Monitor.
TECHNICAL SKILLS
Operating System: Windows 98/XP/7, Windows Server 2003, Unix
Database: Oracle 9i, DB2, Netezza, MS SQL Server, BIGSQL.
Programming Languages: SAS, SQL, PL/SQL, Unix Shell Script
Tools: R, SAS Enterprise Guide, Datameer, Informatica PowerCenter Designer, Informatica PowerCenter Workflow Manager, Informatica Power Center Workflow Monitor, Squirrel, Control-M Desktop, Control-M Enterprise, Winscp, Aginity, Starteam, Jira, Confluence.
PROFESSIONAL EXPERIENCE
Scrum Master | Functional Analyst | BI Consultant
Confidential - San Antonio, TX
Responsibilities:
- Responsible to lead Bank BI projects from inception through completion and ensure delivery to business partners, while adhering to project scope, schedule, quality and budget.
- Managing the roadmap of projects and lead transformational journeys that will enhance the capabilities of Bank Business Intelligence and Data analytics with focus on Data Warehouse, BI tools, and reporting capabilities.
- Lead teams in implementing Scrum in order to maximize velocity. Work with Product Owner to ensure highest value features are delivered at agreed time.
- Track progress on a daily basis through burn up, burn down and velocity tracking. Understand and help manage product back log.
- Consistently worked to improve the processes and quality of our team's work by: implementing test-driven development, ensuring that software conformed to architectural standards and participating in design and implementation reviews.
- Coordinated and participated in weekly estimation meetings to provide high-level estimates (Story Points) for backlog items.
- Monitored the development progress throughout each sprint to ensure project was within scope and budget.
- Interacting with the project stakeholders to discuss on the various project cost, quarterly budgets, timelines effort and issue escalation.
- Perform a governing role for ensuring that the proposal, execution, control, deployment, training, hand off, warranty support, and project closure meet promised schedules.
- Facilitate the Scrum process like daily stand-ups, sprint planning, backlog grooming, sprint reviews & retrospectives. Facilitate communication within the team and with the key stakeholders.
- Partner with module and component leads to do capacity planning & resource allocation.
- Perform risk identification and mitigation activities, escalating unresolved issues to the Executives or Steering Committee to secure their timely decisions and approvals.
- Identified product and functional requirements which helped build the product plan and project scope.
- Conducted user interviews to help identify and understand different process for each user while simultaneously identifying their pain points.
- Identified potential project risks and helped developed a mitigation plan to resolve potential issues.
- Facilitating the Agile ceremonies: Sprint Planning, Daily Scrum, Sprint Review and Retrospective.
- Responsible for managing the product backlog, iteration backlog, user stories, capacity planning, release planning, burn down charts, co-ordinating task assignment and planning poker estimation.
- Coaching the Development Team in self-organization and cross-functionality;
- Removing impediments to the Development Team’s progress and helping the Development Team to create high-value products.
- Review and oversee updating of the Risk Management Plan (RMP), Risk Registry, Change Management Plan, QA Plan and Master Status Report.
- Responsible for the design, development and implementation of the strategic plans for the Bank Data Analytics Program. Leads the day-to-day operations, financials, marketing and success of this Program.
- Identifying risks at the project level in terms of resources, quarterly budget allocations, availability of business SME etc.
- Worked closely with Product Owners, coordinating product backlog grooming and story estimation.
- Responsible for Leadership meeting with offshore management to discuss program operations such as employee hiring plan, employee skill development plan, delivery quality improvement initiatives etc.
- Facilitated Daily Scrum Meetings and Monthly Reviews meetings. Conducted sprint retrospective and followed up on action items for continuous improvement
- Maximized ongoing performance and efficiency of cross-functional agile engineering teams to ensure product is produced rapidly and with high quality.
- Administered Project activities including: developing and maintaining project schedules, maintaining project issues lists, maintaining project spending forecasts, planning and creating team meeting agendas and meeting minutes, and creating project status reports.
- Assisted to ensure technology aligns with business needs, making sure technology investments fit strategically and tactically.
- Responsible for meeting with business/technical partners directly, facilitate/lead requirements/WBS gathering sessions (white boarding, brainstorming), plans, coordinates, monitor and drives risks, issues and timelines, managing the full lifecycle including resource allocation, progress tracking and monitoring change control.
Scrum Master | ETL Technical Lead
Confidential - San Antonio, Texas
Responsibilities:
- As a BI consultant and project technical lead, involved in project planning with client partners, business analysts and team members to analyze business requirements and outline the proposed solution.
- Successfully delivered as a Scrum Master for the daily project stand-up of the agile methodology.
- Coordinate with the project dev lead, project managers, and product owners to do sprint and release planning for the product.
- Interface with project teams, project managers, product managers & BA’s to make sure that stories and other project deliverables are of sufficient quality and provided in a timely manner.
- Work with architecture and engineering teams in distributed locations to drive planning, issue resolution, and development on platform & project specific technical topics
- Requirement Gathering, Preparation of Detail Design, run Proof of Concept to validate the design.
- Coached team members on agile processes and facilitated planning meetings and retrospectives. Maintained task board and produced daily burndown charts.
- Removed impediments and protected team members from interruptions and distractions to maximize productivity. Encouraged and implemented process improvements. Created team-building opportunities.
- Developed and followed agile project management plan in Jira (Agile Ceremonies). Facilitated build requirements log (product backlog) with cost estimates and priority.
- Conducted Scrum Daily stand-up, Product backlog, Sprint Planning, Sprint Review & Sprint Retrospective meetings.
- Determined the team capacity (velocity) from historical data. Created Work Break down structure (user stories) and corresponding activities (tasks).
- Monitored the project progress and radiated the information to stake holders. Identified and mitigated team risks and impediments (Blocking Issues, Critical Defects) on daily basis.
- Worked with Senior Management, Business & Release Management to understand the vision of the product, prioritize and develop software release planning.
- Worked with multiple agile teams to foster a culture of collaboration and continuous improvement.
- Coached and empowered teams to self-organize and grow cross-functionally.
- Championed Agile concepts & methodologies outside of the software development teams, leading to the adoption of Agile
- Led and coached Product Owners to improve story writing & requirements gathering process, leading to an increase in customer
- Created and updated detailed project budgets and resource estimates using Microsoft Project and JIRA
- Understanding of the existing SAS framework, as-is business and design documents of the application and measure the feasibility of migration to the new ETL framework. (Informatica)
- Attending design document walkthroughs with customer and document business logic, mapping strategies, transformations involved in the ETL process.
- Manage defect backlog including working with product management to prioritize and defer defects Provide weekly reporting on project progress against release goals and team activity.
- Responsible for on-boarding, training, sprint plan, deliverable signoff, monitoring velocity, backlog, coordinating project updates and project cost management.
- Identify risks and to clear roadblocks, facilitate resolution of risk and compliance issues.
- Translate requirements and high-level design into detailed functional design specifications.
- Responsible for source data analysis and involved in Data Modelling.
- Complete understanding of the concept of Financial Security Indicator (FSI) and develop SAS model for generation of the FSI score.
- Extensive SAS code analysis, development of the design documents and build the solution to implement the application in Informatica.
- Development of SAS code to generate FSI score for 15 models across each LoB’s (Line of Business)
- Implemented SQL PASSTHRU facility to read data from other sources. Extensive use of SAS macros, SAS Data Steps, SAS Procedures for data analysis.
- Import raw data files, transform and derive data, merge SAS data sets, perform statistical analysis, generate reports as per business requirements.
- Extensive usage of SQL, SUMMARY, REPORT, FORMAT, FREQ, RANK, TRANSPOSE procedures.
- Responsible for creating SAS reports in HTML, PDF, MS Excel formats using ODS & Macros.
- Extensive development of SAS code for data extraction from multiple systems and build the input data for the FSI models.
- Set up process to publish FSI scores to multiple applications like UNICA, EDW (Enterprise Data Warehouse) and MSAE (Marketing & Sales Analytics Environment).
- Generate SAS reports as per business requirements and the client standards for the change analysis application.
- Used Informatica PowerCenter for extraction, transformation and loading data from multiple source systems.
- Used UNIX shell scripts to automate repetitive database processes, file transfers and job scheduling.
- Extensively used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters, FTP Session Parameters and Source-Target Application Connection parameters.
- Performance tuning of the mapping and workflows.
- Managed the team both at onsite and offshore, delegating assignment to offshore team, analyzing and proposing solution to the offshore team.
- Worked with Senior Management, Business & Release Management to understand the vision of the product, prioritize and develop software release planning.
- Peer code review of offshore deliveries and verify the generated product counts for marketing new/continues/loss before final delivery to TCOE team.
- Worked with QA team to create test cases for QA testing in ALM (Application Lifecycle Management).
- Responsible for automation by building Control-M cycle to schedule the SAS jobs and Informatica workflows.
SAS Programmer Analyst
Confidential
Responsibilities:
- Development of SAS model for determining optimal interchange rate with parameterised Interchange Rules.
- Interaction with client on a regular level for understanding the Mainframe system and set up the corresponding functionalities on SAS.
- Responsible as Onsite Lead and co-ordination with offshore for daily activities, deliveries and proposing solutions to the offshore team.
- Design and Development of SAS programs to import the complex VISA and MasterCard data of US, UK and Japan from flat files.
- Application of the Interchange rules through SAS programs to calculate the interchange rate and Fee Type description.
- Generation of summary report based on Interchange rules
- Comparison and analysis with interchange reports from Confidential, Visa and MasterCard on a summary and transaction level.
- Report of variances between optimal and actual interchange rates
- Suggestions for the business to implement respective changes in the system for application of the correct interchange rate.
- Root cause analysis of significant variation.
- Performance tuning and optimization of various queries for improvement of the SAS system to effectively handle large volume of data.
SAS Programmer | Onsite Application Lead
Confidential - New York
Responsibilities:
- Design and Development of SAS programs for IMP’s SAS DW and Campaign functionalities.
- Developed SAS programs to create a customer mailing list for Direct Mailing and Telemarketing.
- Performed forecast analysis for campaigns. Used PL/SQL and PROC SQL Pass through Facility to work with ORACLE and DB2.
- As Project Lead involved in detail design of the campaign applications and manage offshore SAS support team for Campaign Analytics.
- Performed in-depth analysis of data using SAS procedures and delivered customized reports to marketing managers.
- Responsible for designing and development of complete data warehouse. These include metadata design, data modelling and update process.
- Responsible for Data Extraction, Data Preparation, Data Validation and Analysis.Performed statistical data analysis, generated reports and graphs using SAS/Base, SAS/Macros, SAS/SQL, SAS/Access and SAS/Graph.
- Responsible for delivery of Change Requests and resolving issues based on the priority.
- Extensively used SAS Data Step and PROC SQL to generate various reports as per ad-hoc requirements
- Maintain existing programs, reporting - troubleshoot in case of errors/issues & enhance them based on requirements. Create audits & quality checks for new & existing reports.
- Performed statistical data analysis, generated reports and graphs using SAS/Base, SAS/Macros, SAS/SQL, SAS/Access and SAS/Graph.
- Used UNIX shell scripts to automate repetitive database processes, file transfers and job scheduling
- Develop high quality SAS code that is efficient, automated, maintainable, and follows industry best practices.
- Performed in-depth analysis of data using SAS procedures and delivered customized reports to marketing managers.