Niraj Naik Email & Phone Number

St Paul, MN, US

• Created an aggregated report daily for the client to make investment decisions and help analyze cyber risks.
• Validate Computation/Automation objects, define Feature governance requirements through working withFeature development teams and other risk management units such as Enterprise Data Management, Model RiskOffice, and.
• Created Python scripts on Databricks which extracts data from Snowflake server and upload the files to s3buckets using python.
• Create monitoring reports to support business operation for retention, back office in the branded credit cardbusiness and schedule them to run on cadence. Write Shell scripts to automate data loading into.
• Performed validation of data according to the business intent and help iron out the errors and gaps betweenunderstanding of business intent and the implementation.
• Documented project reporting requirements and translate them into functional specifications

New York, NY, US

• Analyzed current state SQL queries that generates current reports, documented those logic in pseudo codes tomake better understanding to technical folks for their technical requirement documentation.
• Cleaned and processed third-party spending Data into maneuverable deliverables within a specific format withExcel and python libraries such as NumPy and Pandas.
• Utilized Python and SQL Scripts to optimize complex SQL queries, to build and test various ETL data pipelines forFeature Implementation.
• Responsible for developing database objects like Stored Procedures, Functions, Packages and Triggers usingSQL.
• Involved in relational and dimensional data Modeling for creating Logical and Physical design of the databaseand ER diagrams using data modeling like Erwin.
• Used SQL to execute queries against the Oracle databases towards data analysis and data extraction into, amongothers, MS Access, MS Excel, and Text files.

• Created data pipelines and multiple ETL tasks and data warehouse solutions using SSIS, and storeprocedures/jobs and windows services.
• Collated and converted user requirements into business requirements, performed analysis and segregated theminto high level and low-level business requirements.
• Performed analysis using Python libraries for large datasets provided by clients.
• Created and maintained reports for clients such as portfolio summary, ad hoc reports, EOD Balance, customerstatements and more.
• Deployed reports and dashboards to clients internal/remote servers.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files,JSON, XML, Excel, Oracle and SQL Server.

New Albany, Ohio, US

• Gathered requirements, analyzed and wrote the design documents.
• Involving in complete Agile Requirement Analysis, Development, System and Integration Testing.
• Built various graphs for business decision making using Packages like NumPy, Pandas, Matplotlib, SciPy andggplot2 for Numerical analysis.
• Involve in data mining, transformation and loading from the source systems to the target system.
• Working with various Integrated Development Environments (IDEs) like Visual Studio Code and PyCharm.
• Designing and Developing reports from multiple data sources by blending data on a single worksheet inTableau.

• Interacted with end users to gather Requirements. Created technical, user documentation.
• Studied and designed the system.
• Install, Update, Configure and Maintain the MS SQL Server.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• T-SQL queries for the retrieval of the data.
• Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filterreports.