Data Analyst/sprint Manager Resume
Richmond, VA
SUMMARY:
- IT Professional with 15 years of experience in all phases of Software Development Lifecycle (SDLC) including Requirement gathering, Analysis, Design, Development, Testing, Deployment, Delivery and Support. Managed to deliver large - scale Data warehouse software and Web development projects on time and on budget.
- Salesforce Certification - SF Certification verification link and SAFe® 4 Certified Agilist Agile SAFE 4 Agilest certification verification and Communicating and Sharing Value-Proposition of Agile, Kanban and Scaled Lean Methods and Processes
- Hand on development experience Business Intelligence Reporting Tool - Teradata, ORACLE, Sybase, SQL - Server, DTS, Crystal Reports, MUMS,,MS-ACCESS, Core JAVA, Hands on experience working other Web based technology like Classic Asp, Asp.net, C#, Net 3.5. Good knowledge and handled the project that has JAVA, TERADATA,TSF Hadoop Map-Reduce job scheduler paradigms, Hive, Pig, Flume, Sqoop, Oozie and NO SQL database like HBase.
- Around one year as handling Big data and Salesforce.com as Project Manager, Developer and Admin requirements.
- Facilitated Agile Ceremonies like Daily Stand-up, Sprint Planning, Capacity Planning, Sprint Burn down, Velocity Management, Impediment Management, Demo & Retrospective sessions, Product Backlog prioritization, Story Pointing, user story gathering & Release Planning.
- Demonstrated capacity to analyze complex business requirements and translate them into technical specifications, while maintaining a customer focus for outcomes.
- Professional experience performing as Technical Project Manager/Scrum Master/ Solution Architecture and strong in project management skills analyzing scopes, developing plans and controlling scope/schedule. Experience in SAFE Agile development as Scrum Master . Executed complex projects in Amex in collaboration with multiple LOB’s like Retail banking, Credit Cards and Investment divisions.
TECHNICAL SKILLS:
Hadoop/Big Data: HDFS,Mapreduce,HBase, Sqoop,Flume,MongoDB,Cassandra,oozie,Pig
Data services: Hive, HCatalog and Solr
Management: Technical project manager, Project manager & SCRUM Master
Project Management Tool: Rally, Clarity and Jira
Datawherehouse: MS DTS, Sql Server integration services, Teradata
Java & J2EE Technologies: Core Java, Servlets, JSP
IDE s and Tools: Eclipse, Net beans, MS visual Studio.Net, TFS,Preforce, GitHub
Cloude: Salesforce and AWS
Frameworks: Win Runner, Load Runner, QTP
Programming languages: C,C++, Java, Jscript, C#.Net, ASP,ASP.Net,Visual basic,MUMS,Linux shell scripts
Databases: Teradata, Oracle 11g/10g/9i, MySQL, Sybase, MS-SQL Server, Pig
Web Technologies: HTML, XML, JavaScript, AJAX, SOAP, WSDL
ETL: MDF,SSIS
Reporting Tool: Crystal Reports
Integration System: Kafka
PROFESSIONAL EXPERIENCE:
Confidential, Richmond, VA
Data Analyst/Sprint Manager
Responsibilities:- Transforming waterfall modal to Agile. Facilitate Sprint ceremonies including Daily Stand ups, Sprint Planning, Sprint
- Retrospective to discuss project status & updates and address any impediments.
- Perform data and code analysis for the issues reported by various membership/claims
- Source systems and downstream reporting systems on data stored in data warehouse.
- Apply technical knowledge using Teradata Tools (SQL Assistant) and Teradata Utilities
- (BTEQ, Fast Load) for system analysis and maintenance of data warehouse.
- Conduct meetings with end users to detail the Business needs and determine/define
- Scope of data and code fixes and support user acceptance testing.
- Create complex SQL queries to verify historical and incremental data and code
- Changes and validate the changes in SIT and Production environment.
- Key role in the definition, development, implementation, and ongoing improvement of agile practices (with an emphasis on Scrum) within the organization.
- Help to build an environment where continuous deployment/ improvement of the development process are the focus and everyone’s common goal is to deliver outstanding software as fast as possible to our customers.
Confidential, phoenix, AZ
Technical Project Manager/Scrum Master
Responsibilities:- Gathering requirement for Document archival and big data archival framework.
- Facilitate Planning/Kick-Off meetings, Retrospectives and Daily Standup
- Scheduling and Conducting the Agile Iteration Planning and Retrospective (lesson learned) meetings
- Work directly with Application Owners and Project Managers to prioritize User Stories for each iteration and release
- Calculate development velocity. Work with QA and Demand Management to manage and forecast iteration capacity
- Manage all release activities, including code deployment and verification
- Coordination of activities with Release Management to ensure successful delivery of iterations and deployments
- Managed and conducted the Sprint Demos
- Participated in developing Agile and Kanban workshops that leveraged a modular content approach to enable each IT organization to create custom training programs. Coordinate dependencies between teams with other Iteration Managers
- Managed API integrations, web services, workflows and triggers.
- Met with customer operations managers to identify issues and areas of potential improvement.
- Supported business needs with technical design documentation.
- SOAP and REST services using the Salesforce to integrate with cloud
- Knowledge of Infrastructure Automation with AWS and tried for POC
- Implemented ETL solution with Hive and also written custom UDFs for building marts.
- Manage and Implemented Hive tables and HQL Queries for the reports
- Manage and Implementing a solution that could map Oracle external table to Hive and at the run time it could provide seamless data for dynamic queries
- Integrated with Tessaract (OCR) to extract the text information from scanned documents
Environment: Hadoop, HBase, Hive, Tesseract OCR, SVN, TFS,Solr, AWS, Nice, Greenplum, Vertica, Salesforce Cloud and Rally
Confidential, Louisville, KY
Technical Project Manager & Sr.Architect
Responsibilities:- As Scrum Master responsible for planning and scheduling of sprint sessions in collaboration with stakeholders. Executing and tracking sprints progress working with Development, Testing and Business teams. Responsible for Capacity Planning, Effort estimation, scope and schedules.
- Worked on facilitating, coordinating and scheduling requirements, development and testing. Proactively working with team help develop requirements and scope documents. Maintaining and reviewing Risk and Issue logs addressing and resolving working with the stake holders.
- Worked on creating user stories, grooming of product backlog, prioritizing and assigning to sprints in detail with team inputs for control of scope/schedule and keeping stakeholders informed and getting buy-ins. Handled scope changes by evaluating impacts and having changes approved. Interacting with usecase owners and worked towards solutions by providing details about existing functionality and current BAU process.
- Scheduling and running daily sprint calls and weekly project meetings to discuss status and issues with different stakeholders addressing any potential issues/risks. Collaborating with PMO, Business and Testing organizations to ensure success of the project. Responsible for leading a team of 10, Coordinating Onsite/Offshore teams for meetings.
- Served as a subject matter expert (SME) to application managers, program managers, and project managers on Agile (Scrum) and Kanban lean methodologies.
- Coordinating and planning of usecase and feed migration delivery dates and schedules for effective end to end testing of the usecases. Working with QA teams in gathering testing requirements to test various Technical management of projects that develop programs that can ingest this real-time data into Enterprise Data warehouse running on like Oracle and/or Netezza
- Responsible for SLA & Penalties management, Incident, SR, Release and CR management.
- Manage and control timelines through tracking of project tool Rally.
- Extensive SQL and PL/SQL Procedures, Functions in to Hive and Pig flow respectively.
- Provided technical expertise to handle non equi-join issue and provided work around to resolve the problem.
- Creating business use case, charters ad reports using rally and incident management tool
Environment: Hadoop, Hive, Pig, Sqoop, Oracle, Rally, SVN, TFS,Salesforce, Campaign and Companion Management tool.
Confidential
Technical project Manager & Sr.Architect
Responsibilities:- Plan, execute, and finalize projects within triple constraints of delivering on time, within budget and scope objectives
- Designing documentation deliverables including: process models, process decomposition diagrams, network architecture diagrams, data models, data flow diagrams, entity-relationship diagrams (ERD)
- Identify, effectively communicate, and resolve project issues and risks.
- Effectively communicate project status to project stakeholders. Coach, mentor, and motivate team members, influencing them to take positive action and accountability for assigned work.
- Day to day follow up with the Client managers to suggest the improvements in existing process of obtaining requirements. To gather requirements and do the scoping.
- Manage and assist the offshore team in the creation of design, development and testing, mitigate technical risks, if any and provide quality and timely deliverables.
- Resource allocation, monitoring and control Management.
- End to End AMEX project Management using clarity
- Ensure internal agreement, cost, and delivery capability.
- Worked in IDN Data Warehouse Transformation for complete uplifting of our existing system and platform to Teradata.
- Manage on SIT, UAT, GO & NO GO decision and Warranty support.
- Worked with IDN Delivery of Sybase to Teradata, Teradata to Sybase data migration process developed as part of the IDN Transformation
- Managed on the project Contact BI ETL deliverables on - Analyzing, optimizing table and query to have for minimum response time in dimension fact load from Sybase to Teradata transformation using star schema or snowflake schema that allow for flexibility while improving performance (views, join indexes, functions, stored procedures, global volatile temporary aggregate tables, reporting ) on Teradata and Cassandra etc.
- Performed the data analysis and mapping; database normalization and clean-up; data extraction, transfer, and loading (ETL).
- MQ payload modeling and channelizing it to HDFS.
- Designed and Implemented XML parser (Record Reader) to parse XML string in Hadoop.
- Proposed and Implemented Reconciliation logic to match the transactions and to get tagged with ECR
Environment: Hadoop, Hive, Cassandra, MongoDB, Oracle, SQL, Pig, Sqoop and Teradata, Git Hub,Sybase Flume, Kafka, Pig, Oozie, Java, Rest for sales cloud,AWS and Clarity for project management.
Confidential
Lead Designer
Responsibilities:- Manage multiple projects under single program umbrella specifically in the area of Offshore-Onsite model.
- Program / project schedule, cost and resource management
- Work with multiple project team and managed the program
- Status reporting to the senior management
- Held Teradata Database Designer role on this project.
- Developed/modified, tested and performance-tuned data manipulation procedures for the warehouse: store-day combination data deletion procedure (for unload of erroneous data), aggregation calculation procedures and others.
- Templates for the other developers to follow.
- Fast - ESP integration with existing application.
- Participated in architectural decisions regarding the newly built system
- Managed the program in a smoother way with multiple acquisitions happened at the customer side
- Key Person for achieving rapid growth in revenue and team size of the engagement
- Project planning, execution, monitoring and resource balancing skills with ability to support multiple simultaneous projects in a matrix organizational structure.
- Experienced in coordinating, negotiating and motivating outside vendors and off-shore resources in support of time line and IT project deliverables
- Working closely with Microsoft to Integrate the ANZ application and the Search engine FAST ESP.
Environment: FAST ESP, Team foundation server(TFS),TeraData and Sql server.
Confidential
Technical Project Lead
Responsibilities:- Basic functional design. Created UML diagrams using Microsoft Visio.
- Constructed Class Libraries containing code for business and data access in the form of ASP.NET pages.
- The logic was implemented using C#.NET and ADO.NET.
- Used ADO.NET Dataset Object to access the databases and gather all relevant information to be stored.
- Developed stored procedures to carry out all the Data Manipulation operations on the Database.
- Created ASP .Net pages and Class Libraries containing code for business and data access logic using C#.
- Negotiated by study delivery managers, with contract award contingent upon project manager assignment.
- Demonstrated outstanding leadership and superb project management skills, consistently scoring 90% or Greater on Customer Satisfaction surveys distributed to study delivery managers during project initiation, Monitoring, and closeout phases.
Confidential, Columbus, OHIO
Technical Project Lead
Responsibilities:- Reviewing and assessing existing data processing methods and techniques
- Rationalizing existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage
- Designing documentation deliverables including: process models, process decomposition diagrams, network architecture diagrams, data models, data flow diagrams, entity-relationship diagrams (ERD)
- Modeling processes, work-flows, and structures
- Involved in Design, Construction and testing of applications such as Portfolio tracker
- Created ASP.NET web pages that provide new features such as Smart Navigation.
- Extensively used ASP.NET to develop front end screens making use of
- Server and User Controls.
- Working with SSIS and SSRS for Reports.
- Was involved in Status reporting to the senior management.
- ASP.NET validation controls such as RegularExpressionValidator and CustomValidator to validateand information provided by the users.
- Designed the web forms in ASP.NET and code logic in C# to effectively mirror the business processes.
Environment: C#, ASP.net, MVP, MVC, SSIS, SSRS and VB.Net
