Banani Sinha
Assistant Consultant, TATA Consultancy and Services
Work authorization: EAD (L2)
Personal Email: adirwy@r.postjobfree.com
Phone: 669-***-****
Fremont, CA
TECHNICAL INTERESTS
Analysis using complex SQL queries, data Analysis and debugging in database, requirement gathering, data Modelling and mapping with SAP Hana and troubleshooting. Pharmacovigilance application API development with PLSQL/SQL (Argus development and support).
EXPERIENCES
TATA Consultancy and Services Nov’2009 – Present
Assistant consultant (Onsite developer with Cisco, San Jose, CA) June’2019 – Present
IT-Analyst/System Engineer (Offshore developer with SEI Investment, PA / Eli Lilly, IN) Nov’2009 – June’2019
EDUCATION
Bachelor of Technology (Duration: 2005-2009) in Information Technology
Veer Surendra Sai University of Technology (Formerly UCE Burla), Orissa, India CGPA: 8.78/10
Oracle Certification IZO-051
All India Secondary School Certificate Examination, CBSE, 2005 Score: 89.4%
All India Secondary School Examination, CBSE, 2003 Score: 93%
SOFTWARE SKILLS
Programming languages: PL/SQL, SQL, HANA SQL Script
Database: Oracle 11g, SAP HANA
Platform: UNIX/LINUX.
Tools: Mcraft, Quality Center, TFS,HP ALM
SDLC: Agile
Tool: Argus Safety (Oracle tool for Pharmacovigilance reporting), SQL Developer, Toad, HANA Studio.
CAREER SUMMARY
9+ years of experience as Oracle PL/SQL,SQL, SAP HANA data model Developer in Analysis, Design and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS).
Experience in implementation and development of Argus safety at database level.
Worked in Argus 8 upgrade and Japan adoption
Application Support of critical issues on Argus Safety (Oracle) meeting the SLA and KPI of critical issues.
Modification of configurable table to generate correct E2B reports to meet the regulatory requirements.
Adding and modifying the CFG E2B queries to meet the requirement of FDA and EMEA.
More than a year experience of working with SAP HANA data models. Building and implementing HANA calc views and models on IB data to integrate with REST API.
Hands on experience in writing and analyzing complex SQL queries.
Hands on experience in using SQL * PLUS, TOAD, SQL Developer.
Exposure on Data Modelling and Normalization Techniques.
Created Oracle Database objects such as Tables, Views, Synonyms, Indexes, Sequences, Triggers, Packages, Procedures and Functions.
Effectively made use of few features like Analytical Functions, Aggregate Functions, Table Functions and Hierarchical Queries in SQL.
Oracle Supplied Packages such as DBMS_JOBS, DBMS_SCHEDULER and UTL_FILE.
Implemented Types, Collections, PL/SQL Records, Global Temporary Tables, Bulk Collects, Parallel Processing, Hints, Indexes and Partitions for boosting the performance of existing processes.
Optimized and tuned SQL and PL/SQL programs by examining EXPLAIN PLAN statistics.
Performed DBA activities like CREATE USERS, GRANT ROLES and PRIVILEGES.
CRONTAB, SPOOL, Materialized Views and DB links.
Involved in writing interface programs for importing data from flat files into Oracle staging tables using SQL LOADER, External Table and UTL_FILE.
Managed large table processing by creating Partitions.
Written PL/SQL programs using REFCURSORS, Dynamic SQL, XML types and Exception Handling.
Used SVN/TFS and PVCS for version control of code during releases.
Experience in working in Agile model of Software. Participated in daily Stand up Calls, Demos, Sprint Planning and Sprint Retrospective Meetings.
SUMMARY OF PROJECTS
1.HANA backend developer (CISCO in Cisco Ready Project) San Jose (CA) June 2019 to Present.
Details:
a)Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
b)Worked in Agile and WaterFall Project management approaches.
c)Managed Offshore and Onshore team model.
d)Worked extensively on Data Modeling design like developing HANA Objects.
e)Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models
f)Cooperated with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture
g)Designed, Developed and Maintained HANA models by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies
h)Hierarchies are implemented to support drill down reports
i)Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
j)Monitoring and troubleshooting data loads
2.Database consultant in global patient services (Eli Lilly): Noida(India) January 2017 to Jauary 2019
Details: Analysis and resolution of live production issues in Argus and interfaces. This role also includes responsibility to track and manage multiple incidents and problem tickets on the application in service now. This role not only include support but also development of critical releases to fix production issue and incorporating new features. I was involved in making complex changes in configurable tables of E2B reports. I was also involved in modification of reporting rule queries and configuration of Product/License/Drugs as per business advice in the database level.
3.Eli Lilly and Company Argus 7 upgrade Database developer: Noida (India) Mar 2016 to January 2017
Details: Database developer for Lilly on pharmacovigilance interfaces. The role mostly includes developing interfaces like packages, triggers and email services for population and manipulation of clinical data based on client requirements. It also includes converting Linux interfaces into database schedulers and process. In this role, I have been involved in not only development but also debugging and analysis of critical issues.
4.Corporate Action Processing Scrum Team: Bangalore (India) January 2013 to June 2015
Details: Worked as a designer to develop the HLD for changes in corporate action processing due to change of custodian for SEI investment. This includes delivering the HLD after detailed analysis within strict agile timelines.
5.SEI investment catering banks like HSBC, Torilla and PBGB in GLOBAL PO Bangalore (India) January 2010 to Jan 2013
Details: Programmer analyst in TCS FINANCE with SEI investment in building and maintaining a Global Wealth Management Platform that supports security trade, security administration, and corporate action for US and UK clients. I worked in change request like income tax and backup withholding for US and UK instance. This includes implementation of PAYUP and PAYDOWN CA in US and UK markets on asset backed instruments. The job involved requirement gathering, analyzing, designing the high-level documents, making the low-level documents, coding and unit testing. My job was to convert QPP code to Pl/SQL procedures.
Technology used for the project: Mcraft and Quartz (a TCS financial product for supporting wealth management).
REFERENCES
References are available upon request.
DECLARATION
I hereby declare that the above information is correct to the best of my knowledge.
Date:
Place: Fremont, CA Banani Sinha