Deepak Baskaran Email & Phone Number

Dearborn, Mi, Us

Environment: Hadoop 2.6 & 3.1, Voltage, data guise, Data Proc/Hive, Secure CRT(Shell), Secure Fx, Google Cloud Platform (GCS/ Data Proc/ Big Query), Aginity Pro, Putty, Striim, Java eclipse.Responsibilities:• As a data governance analyst, I was specialized in managing the security, integrity, and availability of data within the Enterprise Data Platform. Moved Data from On-Prem (Hadoop 3.1) to Google Cloud Platform (GCS).• Worked with Data replication tool Striim for data migration from On-Prem Hadoop environment to Google Cloud Storage bucket as well in Data Proc and Big Query.• Analyzed and overseen strategies designed to enhance data reliability and minimize redundancies.• Applied data governance standards within the context of data ingestion and data discovery processes. • Worked on Jira tickets for creating and overseeing data access request processes.• Processed Data Decryption authorization based on PHI and PII standard protocols. • Operational support carried for New hive data request, Data Egress, and Data ingestion process.• Reviewing, developing, and implementing various standards involving data governance concepts.• Main scope of the Operational support model was the creation and revision of data governance procedural documentation periodically.• Ensuring metadata is captured correctly.• Created and utilized methods for monitoring and reporting any incidents of misused or unsecured data.• Participated in Scaled Agile Framework (SAEE) efforts as needed for the projects. Worked on different projects with the EDP model.• Created and maintained data dictionaries, target mapping, and catalogs.

Environment: Tableau, Power BI, SQL, Azure, Python, IBM Infosphere/ Informatica (ETL), Data Lake, Data Analytics & Reporting, Business Intelligence, and Data Science.• Analyzed one of our most complex packages surrounding customer contacts, then applied a new business rule architecture to make it more flexible and easier to modify• Introduced Oracle arrays to provide numerous overall benefits from performance, readability, and business rule footprint standpoint• Coached Jr. team members on internal system knowledge as well as technical skills related to performance tuning, organization, readability, and usability• Reviewed with team members any new technology utilized, resolutions to issues, or any other relevant knowledge sharing items.• Developed a comprehensive search tool that allows us to quickly search for items such as database objects or strings across all team code sets• Involved in designing, developing, and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).• Identified and refined data quality checks and data monitoring supporting the business rules and changes, defines, and refines data quality measures, reports, and dashboards.• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.• Created detailed level summary report using Trend lines, Statistics, log axes, groups, and hierarchies.• Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets, and hierarchies, etc.• Involved in end-to-end implementation and enhancements on Web-based dashboard platform starting from requirement gathering and dashboards development in Tableau Desktop.• Developed, maintained, and produced individualized monthly reporting packages for MSP clients based on the specific needs of each customer organization, as well as ad hoc reporting.

Environment: MS SQL Server, MS SSIS, MS SSAS, MS SSRS, Informatica (ETL)Responsibilities:• Provide process improvement analysis using process modeling and simulation techniques to understand the impact of process changes• Provide operational analytics to support better management of MIS• Attend technology design meetings and recommend security and data improvements – and will be empowered to work on those prioritized changes• Develop scripts to automate the execution of ETL using shell scripts under Unix environment• Providing routine process/operational control reports and/or Controls Dashboard support• Designed database, tables, and views structure for the application.• Used SQL to connect the database with other oracle versions.• Conducted data migrations from third-party databases to create a consolidated database system.• Successfully transferred inbound data from various sources like flat files, MS Access, and Excel into the database using SSIS Packages.• Optimized query performance and populated test data• Maintained the database using Procedures, Functions, Cursors, and Triggers• Performed quality assurance and testing of SQL server environment• Assisted clients in using implemented software projects• Coordinated with the management to discuss business needs and designed database solutions accordingly.• Implemented batch job processing, scheduling and production support.

Master'S Degree, Management Information Systems, Business Analytics

Master Of Business Administration (Mba), Business Administration, Management And Operations

Bachelor Of Science (B.Sc.), Computer Science