Uploaded File
add photo
Kushagra
tkushagra78@gmail.com
774-728-2443
New Brunswick, NJ 08989
Business System Analyst/Data Analyst
9 years experience C2C
0
Recommendations
Average rating
41
Profile views
Summary

Over 6+ Years of experience as a Business Analyst/Business System Analyst/Data Analyst in various domains including Banking Finance, Mortgage, Government, Multimedia.
• Experience analyzing and documenting project scope documents and SOWs, project plan, project/requirement change request forms, BRD, FRD, SDD, requirement traceability matrix, use cases/sequence diagrams, UML, wireframes/mockups, end user documentation and BPM notations.
• Worked extensively with teams for development of Business Rule Engines to support SOA architecture and web services.
• In depth knowledge of the Software Development Life Cycle (SDLC) using Agile and other methodologies such as Waterfall.
• Experienced working with Business Intelligence (BI) and Data warehousing tools like Tableau, Hyperion Essbase and Informatica.
• Worked on end-to-end implementation of Business Intelligence (BI) reports & dashboards.
• Worked in background on software/web application development with tools such as JavaScript, HTML, C#.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Basic hands on AWS experience including familiarity with the console, S3 & EC2.
• Assisted in creating user stories and co-ordinate with seniors for using acceptance criteria.
• Assisted in creating burn up and burn down charts to track the progress of tasks.
• Created interactive dashboards using multiple data sources in Tableau & performed data cleanups.
• Monitored team progress by viewing sprint reports.
• Create and manage roles, configuration policies, and system/software automation procedures.
• Collaborated with Leadership, Project Managers and Stakeholders to execute BI (Business Intelligence) & DW (Data Warehouse) projects. This includes outlining specific technical deliverables, provide input to project plans and milestones.
• Created reports and data driven presentations with impact-identified trends and occurrences in data and translating finding into various mediums including text, charts, graphs, displays and tables.
• Worked on SQL Server Integration Services (SSIS).
• Experience in design, configuration, development and deployment of Business Intelligence applications using OBIEE.
• Proficient in IBM Security Identity and Access Management (IAM).
• In-depth knowledge of Project Management Book of Knowledge (PMBOK).

Experience
Business System Analyst/Data Analyst
Information Technology
Sep 2018 - present
New York, NY
The New York City Department of Information Technology & Telecommunications (DoITT) provides for the sustained, efficient, and effective delivery of IT services, infrastructure, and telecommunications to enhance service delivery to the City's residents, businesses, employees, and visitors. Main objective of the Gateway Modernization Project is to make doing business with City of Newyork easy and efficient by providing e-Government services that are simple and secure. Responsibilities:
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Assist in creating user stories and co-ordinate with seniors for using acceptance criteria.
• Assist in creating burn up and burn down charts to track the progress of tasks.
• Create interactive dashboards using multiple data sources in Tableau & performed data cleanups.
• Monitor team progress by viewing sprint reports.
• Collaborate with Leadership, Project Managers and Stakeholders to execute BI (Business Intelligence) & DW (Data Warehouse) projects. This includes outlining specific technical deliverables, provide input to project plans and milestones.
• Create reports and data driven presentations with impact-identified trends and occurrences in data and translating finding into various mediums including text, charts, graphs, displays and tables.
• Test and validated reports to insure data accuracy and quality by using MS Excel functions.
• Act as liaison between IT, Business groups and vendor, researching and expediting resolution of issues.
• Prepare quarterly reports using MS Excel (Line/Pie/Bar charts, Pivot Tables, Vlookup, Solver), Access, and produce modeling dashboards/data model to help client strategize.
• Coordinate with Tableau developers and ETL developers to transform business level requirements to functional specifications.
• Provide input on proposing, evaluating and selecting appropriate design alternatives which meet client requirements and are consistent with client's current standards and processes.
• Determine analytical/text mining techniques from business requirements involving unstructured data Exposure on the other BI Reporting Dashboard tools in the market.
• Connect different departments of the city for a better communication channel, and significantly reducing the pending case processes.
• Gather requirements while communication with various stakeholders from many departments, and tailored a functional plan for the system based on reliability, performance, and security.
• Organize JAD sessions, brainstorming, focus groups, and surveys for requirement gathering and translating it to BRD & FRD.
• Communicate with SMEs on regular basis to understand the city processes and dependencies of each department on one another.
• Execute duties of data collection from 3rd parties, client facing through modes of email, phone and in person.
• Prepare estimations - effort and cost estimations to augment sales proposals - Support at external and internal customer facing events - as a technical representative to support business calls - Build custom demonstrations and deliver Proof of Concepts (POC).
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Assist in creating user stories and co-ordinate with seniors for using acceptance criteria.
• Assist in creating burn up and burn down charts to track the progress of tasks.
• Create interactive dashboards using multiple data sources in Tableau & performed data cleanups.
• Provided input on proposing, evaluating and selecting appropriate design alternatives which meet client requirements and are consistent with client's current standards and processes. Environment: SQL SharePoint, AWS EC2, AWS Red Shift, AWS DynamoDB, Jenkins, Tableau.
No skills were added
Remove Skill
Business Analyst/Data Analyst
Banking/Financial
Nov 2017 - Sep 2018
Boston, MA
Project 1 Mobile Banking The project involved a new Mobile Retail Banking application for all homeowners, providing loan pre-approval application facility, loan approval facility, and helping clients to choose the right kind of loan. The other areas of the project focused on adding features in Mechanics website to check their balance, depositing checks through Mobile devices, transferring funds, and paying bills online. I worked closely with Marketing, Customer Service Center, Operations, Legal and Compliance to help analyze, document business requirements, process flows, and data needs to leverage a smarter way which allows customers to carry out banking operations such as: Select Accounts, Credit Cards, Access electronic and wire Transfers and Payments, and Display Pending and Scheduled Transfers and Payments (Mortgage). The project encompassed Retail banking, Credit Cards, SOX, Basel lI, PCI compliance and Mortgage Applications. Responsibilities:
• Provided administrative support by working closely with Project Manager (PM) to create and maintain project documents and have written grant proposals.
• Aggregate and preprocess data using R and MySQL.
• Interact with SME's for gathering requirements and specifications for the applications and preparing business requirements document.
• Facilitate effective status update and sign-off meetings with Executive Board Members and PMO Representatives.
• Conduct requirement gathering, walkthrough sessions with business requestor, testing and Development team.
• Review Business Requirement Documents (BRD) and prepare Use-Case Specifications and Functional specification documents (FSD).
• Chair Requirement Gathering Sessions, Joint Application Development (JAD) sessions and lead the effort to get Business and System requirements baseline (stakeholder approval).
• Utilize Agile development methodology SCRUM as a lightweight process we used to manage and control software and product development.
• Take a major part of the Change Control process and followed up all the Change Request (CR) with impact analysis on Scope, Schedule and Budget constraints and worked with the Change Control Committee.
• Develop the Business Requirement Document based on the research & analysis of PCI.
• Gather and Document PCI regulations and requirements for credit card payments.
• Create Use Cases to document alternate business scenarios and designed UML diagrams.
• Propose requirements for the future state system by applying payment domain knowledge and information collected by interacting with legacy system users.
• Develop prototypes and screen mock-ups using MS Visio to facilitate interactive discussions with stakeholders and developers.
• Optimize the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Review Logical and physical database design using Erwin Tool.
• Using Business Intelligence development studio (BIDS) create Dynamic ETL SSIS Packages to validate, extract, transform, and load data from different sources like web services and also involved in checking data quality, data cleansing and data transfer.
• Worked on huge data transfers from & to SQL Server Databases using SSIS and used configuration files for production deployment.
• Determine the level of formality required and considered options for documenting and packaging requirements based on project type, priorities, and risks.
• Conduct Gap Analysis by creating Swim lane diagrams and highlighted the differences between the Current (AS IS) environments versus the Target (TO BE) environment.
• Clarify QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested the same.
• Initiate and Exercise various strategies involved in website Usability, Functionality, and Compatibility testing.
• Conduct User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues. Also familiar with testing tools to design and develop test plan and test scripts. Environment: UML, Agile (SCRUM), Use Case Analysis, MS Word, MS Power Point, MS Excel, MS SQL server, MS Outlook, T-SQL, SSIS 2012, MS Visio, MS Project, Quality Center. Project 2 Nice Actimize Solutions (AML Reporting) Enhancement of NICE Actimize solutions for the Anti-Money Laundering (AML) Transaction Monitoring System which enables end-to-end coverage for the detection, scoring, alerting, workflow processing, and reporting of suspicious activity. The project is focused on the preparation of CTR (Currency Transaction Report) and SAR (Suspicious Activity Report) as per the AML compliance laws using the NICE Actimize software. Responsibilities:
• Assist in the administration and review of Client Risk Scoring, Client Identification, Client Onboarding, identifying Key Risk Indicators (KRI) and KYC documentation oversight/management requirements.
• Led and implemented end-to-end AML KYC process and platform transformation initiative to improve AML Customer Due Diligence (CDD), Enhanced Due Diligence (EDD), Customer Risk Profiling processes to comply with OCC consent order requirements and AML regulations.
• Troubleshoot CDD and WLF alert issues working with Actimize and identified and reported trends of fraudulent inquiries to senior management.
• Thorough understanding of various modules of AML including Watch List Filtering, Suspicious Activity Monitoring, CTR, CDD, and EDD.
• Prepare Business & Functional requirement documents for securities reporting application using standard SDLC templates in MS Word.
• Maintain SDLC standards by documenting Project Request Document, Project Planning Document, BRD, FRD, Scope Document, RISK Scorecard, and Planning Phase End Metrics.
• Developed Tableau Data Visualization using Pareto's, Combo charts, Heat Maps, Box and Whisker plots, Scatter plots, Geographic Map, Cross tabs and Histograms.
• Write business requir
No skills were added
Remove Skill
Business Analyst/Data Analyst
Information Technology
May 2016 - Nov 2017
Coraopolis, PA
ServiceLink is the premier national mortgage services company that has been providing loan transaction services to the mortgage industry for more than 47 years. ServiceLink delivers home valuation, title and closing, and flood services to mortgage originators end-to-end subservicing to mortgage servicers and default valuation, default and loss mitigation title and closing, field services and liquidation solutions that support servicer loss mitigation efforts and the foreclosure process. Prime function of the project was to Automate Mortgage Loan Origination Process beginning with the customer initiation to title transfer. The system performs all the business functions of the loan process such as the Origination, Servicing, Closing, Loss Mitigation, Loan Modification, Appraisal, and Credit, Income, and Title functionalities by extracting credit data from external agencies. This project also involved the mobile application that was developed specifically for their Mortgage business. It implemented the automation of document upload functionality from legacy system to Easy loan application, and ensured the documents uploaded by customer were updated automatically without manual intervention. The project also reengineered the closing cost functionality for based on new compliance rule implemented by TRID (TRILA- RESPA Integrated disclosure). Responsibilities:
• Responsible for business requirements gathering and proposing BI solutions.
• Gathered and Business and Functional Requirements (BRD, FRD), during JAD sessions.
• Interacted with the stakeholders, developers, Project Manager and SME have to formulate Business Processes.
• Prioritizing requirements along with product owner in backlog which adds the most value, and is a stable and viable product.
• Worked in Cross Functional team environment, served as a liaison between SME's, Project Manager, and stakeholders to ensure accuracy in the SFDC implementation and other business requirement.
• Worked on Process flows, Wireframes and Mockups for the application.
• Worked closely with functional business analysts to design and develop efficient and standards-based BI solutions using Tableau BI products that satisfy business information reporting needs.
• Developed software solutions by understanding and studying systems flows, data usage and work processes.
• Developed DDLs and contribute towards Physical modeling on the Data Marts.
• Took requirements from business users, document and conduct UAT on the delivered Dashboards.
• Maintain quality, completeness and integrity on reporting ready tables on the different Data Marts.
• Developed processes to push data to interfacing applications or enable Pull process via API endpoints.
• Synergize with IT to test, clean, and standardized data to meet the business standards.
• Wrote, executed, performance tuned SQL Queries for Data Analysis & Profiling and wrote complex.
• SQL queries using joins, sub queries and correlated sub queries.
• Wrote complex SQL queries for validating the data against different kinds of reports generated by Business.
• Involved in data analysis and creating data mapping documents to capture source to target transformation rules.
• Extensively used MySQL to write stored procedures, functions, packages and triggers.
• Analyzed data report and prepared weekly, biweekly, monthly using MS Excel.
• Utilized Tableau visualization tool for analysis. Understood the Dashboard structure along with view orientation, sizing and layout, data emphasis, highlighting, color, fonts, tooltips, and performance improvement of complex dashboards/reports using data.
• Defined best practices for Tableau report development. Involved in Analyzing and integrating the data.
• Optimized long running stored procedures and queries for effective data retrieval.
• Responsible for designing automated solutions for recurrent reporting.
• Effectively managed time to meet strict deadlines in a high-pressure environment analyze and provide suggestions.
• Publish, analyze and improve management information dashboards, operational business metrics decks and key performance indicators.
• Wrote SQL Views and create Complex Joins and Nested loops for Tableau Data Source creations.
• Used Excel for data mapping and handling project management calendar.
• Worked in Excel, using Macros & Pivot Tables, and used Excel for Data Mapping and Data Cleaning.
• Created data visuals using Excel Charts (Line, Pie & Bar charts).
• Tested and validated reports to ensure data accuracy and quality by using advanced MS Excel functions.
• Used in-depth understanding of both data and visual sides of Visualization to deliver high quality work products that delight end users.
• Developed new reports and enhanced existing reports connecting to single or multiple data sources.
• Developed metrics, dashboards, and advanced filters in JIRA/eazyBI/Confluence to provide end-users and business leadership with meaningful operational/performance metrics and status reports Environment: Tableau Desktop 9.x, Tableau server / Administrator, Tableau Online, MySQL Workbench.
No skills were added
Remove Skill
Business Analyst/Data Analyst
Information Technology
May 2012 - Nov 2015
Indore, WV
Responsibilities:
• Participating in weekly client meetings.
• Work with business analysts to translate business requirements into data models for visualization deployment.
• Managing multiple projects, responsibilities and competing priorities.
• Creating and maintaining comprehensive project documentation.
• Identify, research, investigate, analyze, define and document business processes.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling.
• Conducted user interviews, gathered requirements, analyzed the requirements using Rational Rose requisite pro- RUP.
• Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Developed timelines for project delivery and managed projects and resources to successful completion.
• Liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships.
• Assisted in development of training materials for new technology and process improvements.
• Participated in developing of Training Materials for the new technology and User Training.
• Presenting data findings and working with other members of the Implementation team to identify and implement.
• Developed databases and systems that allow for the creation of Executive Dashboards, KPI Scorecards, and additional reports.
• Supported development of sustainable reporting and visualization solutions for legacy reporting associated with global and regional purchasing.
• Worked on product analytics by collecting user requirements and translating them into features performing A/B tests crafting iterative roadmaps based on quantitative and qualitative feedback optimizing existing features to achieve KPI improvement monitoring product performance and driving adoption
• Worked on research and strategy by performing test methodologies facilitating ideation workshops performing human-centered customer profiling, market research and competitive analysis interpreting test results developing recommendations for marketing campaigns and initiatives
• Performed Data visualization and presentation by transforming data into visually impactful dashboards developing visual context for presentations (e.g. mind mapping, customer journey mapping) delivering proposals and presenting research findings to stakeholders representing company at the national conferences.
• Analyzed customers' preferences about products, and concluded the major influential factors via SQL.
• Prepared monthly reports for managers, and visualized product information by making the dashboard via Tableau, breaking down data trends for stakeholders and clients.
• Research prospective clients offering services in Analytics, Digital Marketing, and Business Development going B2B and networking events representing the company.
• Supported development of data visualization standards and the application of developed and emerging best practices.
• Analyzing and communicating client's business and reporting requirements.
• Assisting with client reporting and dashboard creation.
• Handled detail, structured problems identifying roadblocks to task completion.
• Created tables, views, joins and store procedures to meet client requirements.
• Identified and connected additional data sources to new and existing Business Intelligence environments.
• Designed and generated tracking and monitoring tools.
• Worked with others in keeping the lead management database up-to-date. Environment: Tableau 9.x, T-SQL, SQL Server, MS Visual Studio, MS Access, MS Excel, Windows XP.
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Information Technology, M.P
not provided
Skills