Developer Manager

Sr. BI Developer

Industry Experience

Having 20+ years of strong IT experience in Software Business Intelligence, Analysis, Design,

Development using SQL, PL/SQL on Oracle and SQL server databases, for complex business

functionalities on UNIX / LINUX and Windows platforms.

Excellent communication skills, including the ability to articulate results and

recommendations of analysis to a variety of audiences within the organization.

Ability to adapt to shifting priorities, demands, and timelines.

Proven ability to develop and maintain strong professional relationships with customers and

colleagues.

Very Good Experience in Building SSRS Reports / SSIS Packages.

Expertise in Power BI reports and Dashboards.

Very Good Experience with VSS/SVN for Check-out / Check-in and maintaining the

different versions of the code.

Expertise in Unix / Linux shell scripting.

Involved in requirement gathering, conceptualizing, designing, developing, unit testing for

variety of business problems or scenarios

Well versed of Extract, Transform and Load (ETL) process.

Good Experience in MSSQL 2008/2012/2014.

Experience in Debugging performance issues using SQL Profiler.

Hands on Experience in writing SQL queries and views.

Hands on Experience writing Stored Procedures using T-SQL and SQL.

Experienced in Ticketing / defect tracking systems like Dell KACE, Jira and HP QC

Exposure in basic Java, Hadoop, Spark, Hive.

Proficient in Oracle, SQL Server, MS Access

Experienced in Business analysis, Requirements analysis, and preparation of Functional

specifications and detailed design documentation for enterprise applications.

Proficient in monitoring tools like AutoSys and Control-M

Experienced in Project Management for critical application support.

Expertise in writing stored procedure / function on Oracle as well as MS SQL Server

Databases.

Experience in dealing / interaction with Law Enforcement department.

specifications.

Exposure to SCRUM in Agile methodology

.

Technical Skill Set

Languages

Korn Shell, PL/SQL, SQL, T-SQL, UNIX/Linux Shell Script, SAS, R programming, Python,

Technologies

SSRS, SSIS, SSAS, SSMS, Data Science, Power BI, Tableau, Business Object, Data Warehouse, Extract Transform and Load (ETL) Process, Crystal Reports,

Monitoring Tools

Autosys, Control-M

Databases

Oracle, MS SQL Server, MS Access

Ticketing / defect Tracking

Dell KACE, Jira, HP QC,

Version Control

Bit Bucket, GitHub, SVN, CVS, VSS

Tools

TOAD, SQL Developer

Operating Systems

Windows, Unix, Linux

Business Domains

Law Enforcement Department (Government), Aviation, Telecom, Manufacturing, Finance, Inventory and Logistics, Shipping

Project Summary

Project: Police Record Management System Apr’ 2020 – till date

Public Safety Department, Milwaukee, WI, USA Role: Sr. SSRS / BI Developer

Description

Web based RMS developed by ProPhoenix Corporation, allowed field officers efficiently maintain Law and order in the community by cutting their incident reporting time. RMS allowed custom fields, forms, modules, dashboards and a report generator. All entered information flows across the integrated public safety records management system which compliant with statutory requirements.

Responsibilities:

Participating in all issue tracking meetings

Coordinating with Project Lead/ Manager for application support activities

Participating in defect / issued status calls to report project status

Following up with core development team for any defects those found during end user testing.

Responsible for writing and modifying SQL scripts for application Maintenance.

Developed stored Procedure and Functions for SQL Server database.

Responsible for supporting changes to the RMS application administration includes periodic functions in the areas of: Database extracts, syndicated data extracts.

Created various packages for Data import by customized ETL tool using Microsoft SSIS.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS)

Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services SSAS 2005/2008/2208R2.

Created various reports using BI tool Microsoft SSRS, Tableau and Crystal report.

Created various Dashboards and reports using Power BI tool for Sr. Managers and Executives

Responsible for all the Core system support to maintain the environments and give higher level of customer satisfaction through meeting SLA’s.

Responsible for maintaining all the RMS application support related tickets, which come through from users, for both PROD and Non-PROD Environments.

Resolve issues related to RMS systems components.

Troubleshoot issues related to RMS Application.

Troubleshoot application production outages by checking JAVA application and log files on windows server

Handled day-to-day problems with high level of interaction with users through email and Ticketing systems.

Checking of all the log files on regular basis.

Project: Financial Management System Sep’ 2019 – Mar’ 2020

Client: Chicago Department of Aviation, IL, USA Role: Sr. BI / Database Developer

Description: Providing support to Web-based Financial Management System (FMS) . This system facilitates Chicago Department of Aviation’s Finance department as well as other department for their routine tasks like Creation of All Purpose of requisition forms, Accounts Payable / Receivable, Budget, Capital Finance, Contracts, Various documents approvals and tractional as well as management reports.

Responsibilities:

Coordinated with FMS team to provide them the necessary stored procedure and packages as well as insight into the data.

Worked on SQL* Loader to load data from flat files obtained from various facilities in certain frequencies.

Involved in the continuous enhancements and fixing of production issues.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD for Data Analytics.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Extensively involved in using hinds to direct the optimizer to choose an optimum query execution plan.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL* TRACE and AUTOTRACE.

Creation of database objects like tables, views, materialized views, procedure and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Used Pragma Autonomous Transaction to avoid mutating problem in the database trigger.

Extensively used the advances feature of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Created various Dashboards and reports using Power BI tool for Sr. Managers and Executives .

Created various packages for data import by customized ETL tool using Microsoft SSIS.

Created various reports using BI tool Crystal Report and Microsoft SSRS.

Sound Experience and understanding of SSAS, OLAP cube and Architecture.

Responsible for creating and maintaining Analysis services objects such as cubes, dimensions, measures. Created report model on SSAS cubes as well as changing default configuration on existing cubes.

Worked with other developers in performance tuning of Databases.

Was responsible for all the core system support to maintain the environments and give higher level of customer satisfaction through meeting SLA’s.

Handled day-to-day problems with high level of interaction with users through phone/ email

Project: Police Record Management System Apr’ 2016 – Sep’ 2019

Client: Police Department, Milwaukee, WI, USA Role: Sr. BI / Database Developer

Description

Migration of legacy Record Management System (RMS) to new web-based RMS developed by CentralSquare Technologies [earlier Tritech System].

RMS allowed custom fields, forms, modules, dashboards and a report generator. All entered information flows across the integrated public safety records management system which compliant with statutory requirements.

Responsibilities:

Participating in all initial Trainings and issue tracking meetings

Coordinating with Project Lead/ Manager for application support and development activities

Participating in defect / issued status calls to report project status

Understanding of creating and troubleshooting stored procedures, indexes and views using T-SQL.

Using SQL Profiler for troubleshooting, monitoring and tuning of SQL Server from SSMS.

Providing Production support and Incident management through ITSM tickets assigned to us and resolving them as per SLA.

Responsible for writing and modifying SQL scripts for application Maintenance.

Developed stored Procedure and Functions for Oracle and SQL Server database.

Created various packages for Data import by customized ETL tool using Microsoft SSIS.

Co-coordinating with our developer’s team to review and validate the code at each phase.

Created various reports using BI tool Power BI, Microsoft SSRS and Crystal report.

Developed a script to tag Police CAD DB qualified records which generate is send to a CSV file report and copy to shared location to pick up by Axon’s [Photo and Video tagging Website] job.

Resolve issues related to RMS systems components.

Troubleshoot issues related to RMS Application.

Handled day-to-day problems with high level of interaction with users through phone/ email

Checking of all the log files on regular basis.

Jan’2005 to Apr 2016 with Tech Mahindra, as a Technical Consultant

Oct’2002 to Jan’2005 with Creative Vision, Pune as Software Engineer

Apr’2000 to July’2002 with Shree Infosys P Ltd, Pune as Programmer

Certifications

Oracle 9i Certified Associates (DBA)

Data Scientist (SimpliLearn.com)

Education

MBA in Finance, from University of Pune, in 2010.

Masters Diploma in Computer Management (MDCM) from Datapro InfoWorld Ltd., Pune in 1997 (Secured 1st class with distinction).

B.Com from Pune University, Pune in 1994.

Manoj Umate

Contact this candidate