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 Technology Risk Management.● 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 thedatabase.Perform data quality control for Mainframe data migration.● 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● Created database objects like tables, views and functions using advanced SQL queries to provide definition,structure and to maintain data efficiently● Fine-tuned SQL queries to maximize efficiency and performance with strong working knowledge onRDBMS inSnowflake, SQL Server, Oracle, and Big Query with advanced SQL scripting skills like multiple joins, subqueries.● Highly efficient in Data Wrangling techniques: Data cleaning and transforming data in usable format, data quality,data profiling, data organization.● Collected large financial data sets in Microsoft Excel and Access and created reporting for senior management. ● Created Excel reports, Dashboards & Performing Data validation activity using VLOOKUP, XLOOKUP, Macros,formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map and Heat Map.ETC

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 Excel reports, Dashboards & Performing Data validation activity using VLOOKUP, HLOOKUP, Macros,formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map and HeatMap. ● Designed and developed weekly, monthly reports by using MS Excel Techniques (Charts, Graphs, Pivot tables)and Power point presentations.● Created various types of charts such as Heat Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts,Circle Views, Line Charts, Area Charts, Scatter Plots, and Histograms in Tableau Desktop, Looker and Excel toprovide better data visualization.● Worked extensively with Calculations using Actions, Parameters, Background images and Maps. Created trendlines, Groups, Hierarchies and sets to create detail level summary Dashboard / Reports using both Tableau &Looker.● Assisted in the oversight for compliance to the Enterprise Data Standards, Data governance and Data quality. ● Much more

● 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.● Conducted research, data collection, and analysis to help the company's stakeholders solve varying issuesrelated to missing shipments, delayed shipments, product price adjustments and account reconciliation.● Use data visualization tools to provide an easy-to-understand interface for end-users to quickly identify keypatterns within their data.● Provided support to the software development team and sometimes serving as a liaison between the end usersand developers.● Interacted on a day-to-day basis with different groups to achieve a common deliverable.● Provided user acceptance testing and training to clients.● Always documented new processes and updated existing processes.● Performed several database tasks such as refactoring stored procedures for easier understanding, and improvedperformance.

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. ● Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation. ● Performing data analysis and maintenance on information store in MySQL database. ● Working with Data Cleaning, Wrangling, Data Analytics, Modelling, Integration, ● Providing End-user Training and documentation for customer reporting services.● Participated in the Analysis, Design and Development Phases of report development, performance tuning andproduction rollout for every report of Information Technology Department.● Queried the databases, wrote test validation scripts and performed the System testing.● Worked with the developers during coding and while doing the remediation of the software.● Document all data mapping and transformation processes in the Functional Design documents based on thebusiness requirements● Performed Data Profiling and Data Quality checks.● Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.

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.● Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation. ● Performing data analysis and maintenance on information store in MySQL database. ● Working with Data Cleaning, Wrangling, Data Analytics, Modelling, Integration, ● Providing End-user Training and documentation for customer reporting services.● Tuning front-end applications like Visual Basic, which query the SQL Server databases.● Written Various ASP codes for user interactions.● Written Java Script for different validations● Used SQL Statements to Present Query responses.