Puneet Jain

Client: Trans America, USA Project: 91540 - Partner Feeds Reporting

Description: Trans America is a US company providing Retirement plans, Employee Benefits, Investments, Insurance and Annuity plans. Our project is to build a common platform to generate reports which will later share with different external partners. The current legacy process to generate reports is separate for each partner. We are generating different types of reports like commissions, funds, participant information, broker information, participant assets etc. With the new implementation we are consolidating data of Mid-Market and Large-Market into a single file to avoid sending multiple files to end clients like UBS, Wells Fargo, Morgan Stanley, Northwestern Mutual, Linsco and Private Ledger etc. We are using AWS batch and file services to upload files at client FTP location. Generating different report formats based on client needs like Excel, Flat files, PDF. All reports are triggered based on the scheduled frequency as per the client requirement like daily, weekly, or monthly.

• Collaborate with business stakeholders to understand their requirements, goals, and objectives
• Translate business requirements into technical specifications and align with business objectives and constraints
• Conducting in-depth analysis of complex datasets to extracting meaningful insights from data to identify trends, patterns, and correlations that can inform business strategies and decision-making
• Data Modeling and Visualization - Developing and maintaining data models, dashboards, and reports to present analytical findings in a clear and actionable manner
• Utilizing data visualization tools such as Tableau, Power BI, to create interactive visualizations and reports
• Data Quality Assurance - Ensuring the accuracy, completeness, and integrity of data by performing data validation, cleaning, and reconciliation processes
• Identifying and resolving data inconsistencies, anomalies, and errors to maintain high data quality standards
• Ensuring compliance with data governance team for the policies, regulations, and standards such as GDPR, HIPAA, or SOX
• Implementing data privacy measures, access controls, and security protocols to protect sensitive data and mitigate risks
• Collaborating with cross-functional teams including data engineers, business analysts, and decision-makers to define data requirements, develop analytical solutions, and drive data-driven decision-making across the organization
• Acting as a liaison between technical and non-technical stakeholders
• To maintain Continuous Improvement and Innovation staying updated on emerging trends, tools, and techniques in data analysis and analytics
• Proactively seeking opportunities to enhance data processes, automate repetitive tasks, and optimize analytical workflows to improve efficiency and effectiveness
• Providing mentorship, guidance, and training to junior analysts and team members
• Sharing best practices, methodologies, and insights with the broader team to foster a culture of learning and continuous improvement
• Leading data analysis projects from inception to completion, including project planning, resource allocation, and progress tracking
• Demonstrating leadership skills by effectively prioritizing tasks, managing timelines and deliverables, and driving successful project outcomes.

Client: Asurion, USA Project: ServiceBench

Description: ServiceBench is the leading service management solution that helps customers deliver best-in-class service with effective, efficient, and accurate exchange of information between channel partners in every transaction. The ServiceBench service management software platform integrates service call scheduling, service dispatch, field service management, parts ordering, and warranty claims management. Each solution includes service intelligence analytics to mine data for strategic information to improve the service process, increase the dependability of products and reduce operational costs.

Responsibilities:

• Work as Technical Lead to create a technical design of the business requirement, closely work with other development team members to get it implemented, review their code, and do the hardcore development of the application for the project.
• Work as a Scrum team to deliver this project following Agile methodology addressing backlog grooming, prioritizing, sprint planning, standup calls, and sprint retrospectives.
• Interact with business analysts/ business representatives for prioritizing, estimating, impact analysis items in sprint backlog.
• Fixed Security related issues and memory leaking issues.
• Involved in writing JUnit test cases, Unit test, and integration testing of application.
• Write UNIX scripts to schedule jobs.
• Write stored procedures, views, complex queries.

Environment: Node JS, Angular JS, Oracle 11g, GIT, Bitbucket, Postman, Oracle SQL Developer

Client: Asurion, USA Project: EDS

• Work closely with the Business Analysts, different business POCs to understand the requirements
• Involved in all the meetings for migrating legacy Applications to build on new platform
• Involved in creation of CI/CD pipelines for continuous integration and deployment
• Worked on migration of IICS mappings into Spark SQL
• Worked on deployment of Spark SQL scripts in cloud
• Ramped-up new team members in the project
• Unit/ Integration testing and QA/UAT support
• Consumed Restful Web Services and created web methods to retrieve the data
• Worked on performance tuning to improve the performance of Stored Procedures and Queries
• Created SQL Server Agent Jobs.

Client: Asurion, USA Project: iCare

• Work closely with the Business Analysts, different business POCs to understand the requirements
• Schedule Meetings with LOB and gathered all necessary requirements and designed Business Requirement Documents
• Provide High Level Estimates for middleware projects
• Identify dependencies, prepare road map/milestone dates and share these details with IT/Business teams
• Create Complex Middleware Architectural Flow, High-Level Design Documents which consist of functional and technical specification
• Monitor of the defects raised by QA team, work on bug-fixes, assign the defects to the development team and review the bug fixes
• Provide support for integration testing and UAT testing
• Creation of database objects like Stored Procedures, Tables, Views, Triggers etc
• Involved in all the meetings for migrating legacy Applications to build on new platform
• Consumed Restful Web Services and created web methods to retrieve the data
• Worked as a Production Support Engineer and fixed the issues on daily basis
• Created Stored Procedure, Views, Tables, and Indexes as per Business requirement
• Worked with Offshore Support Team and knocked out by fixing Critical Production Failure jobs
• Developed SQL scripts to get data from Source Tables and used them in SQL workflow Task and scheduled them to run through Scheduler.

Client: Asurion, USA Project: iCare

• Work as Technical Lead to create a technical design of the business requirement, closely work with other development team members to get it implemented, review their code, and do the hardcore development of the web-applications for the project
• Work as a Scrum team to deliver this project following Agile methodology addressing backlog grooming, prioritizing, sprint planning, standup calls, and sprint retrospectives
• Interact with business analysts/ business representatives for prioritizing, estimating, impact analysis items in sprint backlog
• Work closely with the offshore team to ensure they have proper requirement understanding, resolve their requirement and development related queries, provide them with high level design
• Unit/ Integration testing and QA/UAT support
• On-call production support
• Coordinate with virtual teams across different geographies
• Ramped-up new team members in the project
• Creation of test plans, test scripts, test data and expected test results along with managing test cases and tracking test defects
• Monitor of the defects raised by QA team, work on bug-fixes, assign the defects to the development team and review the bug fixes
• Provide support for integration testing and UAT testing
• Creation of database objects like Stored Procedures, Tables, Views, Triggers etc.

Client: Asurion, USA Project: iCare

• Involvement in Sprint analysis and business calls
• Impact analysis of requirements gathered from client
• Maintaining functional and technical documentation of the requirements
• Development and support for the requirements
• Providing support/analysis for the Live Environment incidents/issues
• Providing 24x7 support for production applications.

Client: Asurion, USA Project: iCare

• Involvement in Sprint analysis and business calls
• Impact analysis of requirements gathered from client
• Maintaining functional and technical documentation of the requirements
• Development and support for the requirements
• Providing support/analysis for the Live Environment incidents/issues
• Providing 24x7 support for production applications.

Client: Asurion, USA Project: iCare

• Functional analysis of business requirements
• Impact analysis for parallel and downstream applications
• Development of applications using ASP.Net, C#.Net, SQL-Server 2008, JavaScript, AJAX
• T-SQL coding (Developing Stored Procedures, Triggers, UDFs)
• Worked with QA to support their testing.

Project: Web Applications (SMS Web, AZSouk)

• Development of applications using ASP.Net, VB.Net, SQL-Server 2008, Crystal Reports
• T-SQL coding (Developing Stored Procedures, Triggers, UDFs)
• Worked with QA to support their testing.

Project: Jewelry Manufacturing System (JMS)

• Functional analysis of business requirements
• Impact analysis for parallel and downstream applications
• Development of applications using ASP.Net, VB.Net, SQL-Server 2008, Crystal Reports
• T-SQL coding (Developing Stored Procedures, Triggers, UDFs)
• Worked with QA to support their testing