SUMMARY

• Total IT experience of 11+ years in a wide spectrum of roles including Project Manager handling BI/ETL, Big Data, Data Manager/Governance, Data Analytics Manager, Product Owner, Senior BA Manager, QA Manager, Automation, Lead Business Analyst, Data Quality Analysis, Tech Lead, Process Improvement Lead.
• Extensive experience with banking, Healthcare, Insurance, Wealth/Capital Management, Entertainment and financial services industry in several domains including investment banking, commercial banking, payment processing systems.
• Have supported and contributed significantly in the end to end process of IST, UAT, Relational acceptance testing and business process testing with expertise in Defect management lifecycle including setting up and utilizing tools like HP Quality Center/ALM (Application Lifecycle Management), TFS and JIRA.
• Demonstrated strong leadership, time management, problem solving and interpersonal skills in coordinating with Developers, Modelers, frontline business units andTesters working across geographical boundaries for complex projects during full Software Development Life Cycle (SDLC), Agile Methodology and Software Testing Life Cycle (STLC).
• Adept at systematic documentation and effective delivery of artifacts like BRD, FSD, PFS, Use - case docs, issue logs, gap analysis docs and functional prototypes.
• Experienced acting as a Scrum Master for multiple distributed scrum teams and successfully maintained metrics that provided visibility to stakeholders on team-level progress and quality.
• Proficient and have sound working knowledge in Business Intelligence concepts, ETL, data warehouse concepts, BA, manual, functional, performance and automated testing techniques including tools such as QTP, Load Runner, Informatica, Teradata, Control-M, Cognos, QlikView, SSIS, SSMS.
• Experienced in PMO reporting and tools, and an ability to create, standard, repeatable reporting models that accurately reflect the status of the portfolio.
• Experienced in scope management, Cost-Benefit analysis, ROI analysis, budgeting & estimation, business case development, content management and change control.
• Expertise in BASEL Risk, Regulatory, CCAR, D-FAST, SOX and reports from SOR-Staging-Integration-Semantic layers business requirements and business process.
• Expertise in analyzing requirements, identifying improvements in business processes, and write functional/technical requirements.
• Strong familiarity in GxP systems guidelines with the pharmaceutical and healthcare clients.
• Expertise in NLP (Natural Language Processing), PGS (Peer Group Selection), KPIM ( Key Performance Indicator Management), SAP ERP, SAP BW/BI E2E process.
• Expertise in SRS, BRS, FRD and SDS to ensure the business needs with the deliverables including the documentation for the stakeholders.

TECHNICAL SKILLS

BI/ETL tools: Informatica Power Center8X/9X, Teradata, Power Exchange, SSIS,Cognos, Control-M, BusinessObjects, QlikView. QlikSense, SAP ERP, SAP BW/BI,PeopleSoft, JDE ( JD Edwards Enterprise One 9.1), ALM (Application Life Management) tool, Tableau, Taleo.

Databases: SQL Server, Oracle 7.X/8/9i/10g

Data Modeling: Dimensional Data Modeling, Relational Data Modeling, Star and Snowflake Schema, Fact and Dimension Tables, Conceptual, Logical and Physical Data Modeling

BigData: Hadoop, MapReduce, Apache Pig, AWS, Amazon Redshift

Testing Tools: HP Quality Center, HP Quick Test Professional, ALM, Load Runner, Apache JMeter, TFS, JIRA

Operating System: Unix, Windows 7/Vista/XP/2000/NT Server

Other technologies/Tools: TFS, JIRA, OnTime, MS Project, VISIO, Mainframe, Java, J2EE, AUTOSYS, CONTROL-M schedulers, SOAP UI, DB2 Client, SQL assistant, XML, .Net, PHP.

PROFESSIONAL EXPERIENCE

Product Owner & PM, Data Engineering Solution Manager, BA Manager

Confidential, Stamford CT

Responsibilities:

• Managed and analyzed data from various sources, including surveys and other studies
• Designed Diversity scoring and evaluation products by determining goals of survey collection, methodologies of data analysis, and determining weighting practices
• Created presentations and reports by documenting data analysis and data management procedures and interpreting results
• Managed a database conversion from various db to Redshift.
• Managed relationships with consultants on system requirements, usability and features needed
• Created training syllabi for employees based on the various user and power user roles
• Managed the in-house reconciliation of historical data from various databases to Redshift (AWS)
• Performed data analysis to support strategic goals, service delivery, and operations and monitor performance against contractual and strategic goals
• Plan and manage multimillion-dollar projects aligning business goals with technology solutions to drive process improvements, competitive advantage and bottom-line gains.
• Led teams across broad technical, financial and business disciplines.
• Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.
• Mitigated risk factors through careful analysis of financial and statistical data. Anticipated and managed change effectively in rapidly evolving global business environments.
• Defined processes and tools best suited to each project.
• Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.

Project BI/Big Data Manager, Data Analyst, BA Manager

Confidential, Montvale, NJ

Responsibilities:

• Created and executed project work plans and revised plans as appropriate to meet the ever-changing business needs and requirements.
• Contributing from origination of project by working withUser Business Analysts team to define requirements to satisfy the business objectives.
• Preparation of documentation including project plan, execution plans and reports for end to end phases of the project.
• Designing & reviewing the QA Test strategy, the test cycles, test estimate and monitoring of test execution.
• Provided data integration best practices and technologies for understanding and resolving data integration issues.
• Reviewing daily execution reports and project status reports with clients and all stakeholders.
• Coordinating the daily defect status meetings/discussions between QA and Development team to resolve any conflicts.
• Coordinating testing of large scale data warehouses and System of records during various stages of ETL process using tools like Informatica and Teradata.
• Established the data environment for the cloud application and their migration.
• Provided project & program management over large-scale, top-priority and complex technology initiatives.
• Implementing and controlling the flow of data to and from AWS
• Identifying appropriate use of AWS operational best practices.
• Migrating an existing on-premises application to AWS
• Participates in application release planning and status sessions for complete solution Architecture group.
• Working and monitoring on conversion ofmanualtests intoautomatedtest scripts.
• Defect Management using the ALM, TFS & JIRA to track and coordinate with the development team for the defects identified as part of the testing process.
• Discussing with the stakeholders for the Entry/acceptance criteria and Exit criteria for any requirement/project QA.
• Incorporated Agile methodology and SCRUM techniques to manage requirements and enhance the evolving applications.
• Facilitated Scrum planning meetings to coordinate between Clients, Product Owner, Dev and QA teams.
• Facilitated management of the scrum team’s dependencies between the program team and third parties, release managers or other scrum teams.
• Systematic and formal test planning/design for COTS or SaaS.
• Align and manage Test Plan to User Requirement for COTS (Not Gaps) and successful implementation with the co-existing software’s to fulfill the requirements.
• Shadow and assist some of the Product Owner activities by providing high level estimates, prioritizing stories for the sprint and maintaining backlogs and release plans.
• Manage the assignment of user stories to relevant BAs based on the feature and process expertise.
• Analyzed massive and highly complex data sets-big data, performing ad-hoc analysis and data manipulation.
• Handled Quality Assurance services forCCAR Technology Implementation projects.
• Wrote reports using Cognos reporting system to extract data for analysis using filters based on the analysis.
• Worked on complex information model-big data, logical relationships, and the data structures that support different jean brands.
• Introduced Hadoop MapReduce apache pig on the reporting layer to improve the performance and availability of data.

Project Manager, Data Analytics Manager, Senior BA

Confidential, Jersey City, NJ

Responsibilities:

• Preparation of documentation including project plan, execution plans and reports for end to end phases of the project and handled the complete vendor team management.
• Involved through entire life cycle in business requirement gathering, designing the QA Test strategy, the test cycles and monitoring of test execution.
• Coordinated as the single point of contact for clients and Business relationship manager.
• Reviewing daily execution reports and project status reports with clients and all stakeholders.
• Coordinating the daily defect status meetings/discussions between QA and Development team to resolve any conflicts.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Executing and monitoring the data loads using Control-M with Unix shell scripting.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the reporting objects in the reports against the design specification document.
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Monitor security batch processing jobs in multi-platform shop via Control-M.
• Extensively worked in application integration for the CCAR technology solution.
• Control-M agent accounts, and trouble-shooting Control-M production errors and coordinating with vendor when necessary.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Facilitate User Acceptance Testing (UAT) and production rollouts, and the defects detected were tracked and managed using HP Quality Center.
• Provided real time feedback to the methodology team based on experiences with software delivery teams.
• Produced reporting documents and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that had to be met.
• Perform data modeling, periodic report validation and data analysis by writing SQL queries using TERADATA.
• Designed a large data warehouse using star schema, flow-flake.
• Designed and developed Big Data analytics platform for processing customer viewing preferences and social media comments using Hadoop and Pig.
• Integrated Hadoop into traditional ETL, accelerating the extraction, transformation, and loading of massive structured and unstructured data.
• Loaded the aggregate data into a relational database for reporting, dash boarding and ad-hoc analyses, which revealed ways to lower operating costs and offset the rising cost of programming.

ETL Tech Lead, Lead BA & Data Analyst, QA BI/ETL Lead

Confidential, Jersey City, NJ

Responsibilities:

• Involvement in End to End project lifecycle for various web applications and managing the offshore team.
• Worked end to end on projects including requirement gathering, planning and execution for testing critical systems to payment processing and SWIFT messaging gateway.
• Prepared a reusable test suite that was subsequently exercised for regression testing.
• Worked on compliance standards analysis and testing of mission critical applications and ensuring systems including SWIFT gateway are in compliance with latest ISO standards.
• Tested complex sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Worked closely with developers and report planners/analysts to insure that an acceptance criterion is complete and accurate for desired report capability.
• Managed and executed the test process, using Agile Methodology.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Involved in preparing the Data-driven and keyword-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
• Performed Back-End Testing of flat files in Unix environment and also involved in writing and executing SQL queries on the database-using sql assistant.
• Participated in Business process testing to determine the need for automation and supported to the clients for User acceptance testing.
• Streamlined the existing tedious manual processes by creating a schedule matrix.
• This also included the details of process file types, owner, point of contact and resolutions for each process.
• Proactively developed prototype for optimization tool and proposed improvements in the design.
• Also worked with Change control support group and managed changes by reviewing, testing and incorporating compliance during various stages of SDLC.
• Actively communicated with users on system status, including system changes, problems, enhancements, and potential impacts.

Business Data Analyst, Lead Data Analytics

Confidential

Responsibilities:

• Created test plan, test suites and test cases.
• Performed Gray Box Testing, Regression Testing, Manual Testing, Functional Testing, Usability testing.
• Performed GUI functional and sanity testing manually for application builds.
• Performed backend validation by connecting to SQL server.
• Executed test cases to compare the actual result with expected results in accordance with business, technical and functional specs of the applications.
• Responsible for thorough testing of browser and platform compatibility issues.
• Ensure test data is properly identified, setup and availability of stub before execution of a test.
• Involved in Release Activities -testing a web site during a release.
• Validated applications GUI for compliance with Usability guidelines.
• Verify bugs fixed in new releases and report defects using QC.
• Translated business and technical requirements between the users and developers.
• Involved in writing Use Cases and Test Cases based on the Business narratives, Functional requirement specs (FRS), and Design specs.
• Designed and developed the Use Cases, Activity Diagrams and Sequence Diagrams using UML(Unified Modelling Language).
• Shared the knowledge across the teams and several peer reviews were conducted to make these artifacts informative.