Mohammad Kaleem

Email: ad2uh7@r.postjobfree.com

Phone: 630-***-****

Status: US Citizen

LinkedIn: https://www.linkedin.com/in/mohammed-kaleem-b6406731

Profile

Summary:

** ***** ** ********** ** the IT Industry with strong hands-on skills as a Sr. Data Integration Developer / JRA Management Professional with Data Analytics Certified in / AWS / Azure /DevOps / Agile management, Reporting, Project Management and Power BI Cloud and Digital Transformations and Integration Design, Cyber security. Development in Business Intelligence.

Around 5 years of experience working for FEDERAL Government Clients: - Navy Federal, General service administration, TSA, Department of Homeland Security, Federal Communications commission and Department of Defense.

7+ years of specialization in Data Integration Development: - Data Analytics Platform Integration, Data Bricks, Data Lake, Snowflake, Data Warehouse, Data Validation, Data Migration, Process Validation, Data Prepping, Data Connection, Data Ingestion, Metadata, Data Visualization, Data Queries, and Release management.

Resolve Dependencies by creating subtask in JIRA to complete the task within sprint.

Very well versed in Analytical and Adhoc reports and Presentations.

Experience in AWS cloud services using EC2 that can Virtual servers in the cloud that can be easily scaled based on the user’s needs and support various OS, applications, and configurations.

Elastic Beanstalk to run applications without dealing with the infrastructure.

S3 for storing large amounts of unstructured data, such as documents, images, and backups.

Experienced in Data Governance, Data Science, Business Analytics, and Cloud (AWS or MS Azure or Google Cloud) consulting & implementation experience in BFSI industry.

Experience in transforming Data Landscape through digital innovation and Data Technologies / Modern Data platform with Snowflake.

Strong hands-on skills with Tableau (8 years) and Power BI (4 years) in making changes to platform templates with features and functional requirements.

3 years of API Integration skills.

Specialized in providing Data Connection, Data Validation and Data Viz in transitioning high wireframes.

Create packages for reporting environments in SSIS,SSRS and SSAS

Grafana, Prometheus, Loki performance monitoring and reporting

Implement Cyber security and trouble shoot any existing issues.

Expertise in creating multi-complex SQL Queries and Commands.

Very proficient in designing and developing Business Intelligence (BI) report and User Interfaces (Dashboards, Scorecards, Report Services Documents, Grids and Graphs) working closely with the Business Intelligence Architect to ensure designed BI solutions meet end user Requirements

Sound expertise in developing functional requirements and wireframe transitions.

Experience in Reporting and Marketing Analytics, Financial reports, Agile scrum management, Banking retail and Healthcare etc.

Excellent problem-solving skills with a strong technical background and good interpersonal skills

Certifications

AWS Certified DevOps Engineer – Professional

AWS Certified Solutions Architect – Professional

Microsoft Azure developer Certified Professional

Power BI

MicroStrategy Platform Admin, CDMD, CPD, CRD

Informatica Admin Certification

Project Management Professional

Education

DeVry University, Addison, IL 2003

Bachelor of Telecommunications Management

Mumtaz College Osmania University, Hyderabad, India 1990

Bachelor in Geophysics

Experience

Professional Experience:

Lingatech/Deloitte Dec 2022 – Dec 2023

Client: US Department of Defense

Role: Delivery Manager Integration and Migration

Responsibilities:

Performance reports for Department of Defense in all the above Programs under the Under Secretary of Defense Acquisition, Technology, and Logistics (AT&L). AT&L assigned responsibility for execution to the Director, Test Resource Management Center (TRMC) and the JMETC Program Management Office.

Technical risk reduction by providing readily available, persistent distributed test environment for data stores, to include intellectual property rights.

Partnered with other electrical engineers during development, take over products as they reach maturity, and support them through end-of-life.

Data Discovery data management and governess, Managing Metadata to run static and Adhoc reports as and when needed by the portfolio managers

Pilot activities at select ranges, test agencies, and/or acquisition programs to modernize their data storage, management, and automated analysis prototype suites.

Document discovery and metadata management including smart document generation and executive analytics

DOD Manual summarizing best practices and recommendations for implementing and adopting these practices as part of the actions described

A retrospective exemplar in the form of a prototype Bayesian Decision Support System for performing integrated, sequential T&E.

Digital model prototypes for two acquisition programs, to include digital Integrated Decision Support Keys

DOD Manual on modeling and simulation for DOT&E and the associated verification, validation, and accreditation process.

Working with JMETC data for Department of Defense’s (DoD) corporate in linking distributed Test and Evaluation (T&E) facilities of warfighter capabilities.

Cyber environment for interoperability, cybersecurity, and Key Performance Parameter compliance testing.

JMETC support for the Acquisition community customers in evaluating new and legacy systems and capabilities.

Power BI and Tableau report presentation to Director’s approval and implementation and publishing of reports.

ZILLION Technologies FEB 2021 – Dec 2022

Client: Navy Federal

Role: Program manager Data Integration and JIRA Management

Manage teams to leverage Collaborate APIs and workflows

Coordinated with external vendors and partners with the technical integration of applications and systems

Monitor and conduct software platform upgrades and perform regression testing by implementing AGILE scrum methodologies, Creating Stories, Assigning Task and Backlog infringements.

Management JIRA Tickets management and workflows to enable Issue trackers, Review trackers etc.

Updated JIRA with backlog of features, project plan, status, and dependencies.

Ingesting data from third party in Azure data lake.

Designed and build cloud tools that democratize access to the cloud to accelerate software engineering and data science teams’ ability to deliver products and services.

Supported non-functional requirements such as serviceability, supportability, logging, monitoring, and alerting etc.

Adhere to the change management and other established processes and procedures

Refine, automate, and advocate for automation, standardized processes, issue tracking, change management, and process improvement

Respond to and troubleshoot incidents. Provide off-hours support.

Experience with Relational Databases (MySQL, MS SQL Server, etc.), NoSQL Databases and/or Big Data technologies

Experience of building a range of Services/Solutions in a Public Cloud Service provider (AWS. GCP, Azure, etc.)

Proficient in AWS technologies, including EC2, S3, Lambda, Glue, EMR, Kinesis, Athena, and Redshift.

Created and maintained ETL jobs and workflows using AWS Glue, Python, and Spark.

Experience with performance tuning and optimization, using native monitoring and troubleshooting tools and techniques, including complex

Adaptable team-player with a focus on results and value delivery

Able to prioritize, organize and plan work independently

Have a strong work ethic, attention to detail and excellent organizational skills

Ability to set and achieve challenging short-term, medium-term, and long-term goals which meet or exceeded the standards in the field

Experienced with cloud native (CloudWatch, GCP Cloud Monitoring, Azure Monitor, etc.) as well as third-party monitoring solutions like AppDynamics

Preferred Qualifications

Experience working within an Agile environment

Willingness to adapt to a changing environment and changing requirements.

Ability to quickly acquire new skills and tools

Strong understanding of SDLC methodology•

Worked with executives and other business leaders to identify opportunities for improvement

Created reports for internal teams and/or external clients

Collaborated with team members to collect and analyze data in Redshift and Snowflake and Data modeling needs.

Use graphs, infographics, and other methods to visualize data

Established KPIs to measure the effectiveness of business decisions

Structure large data sets to find usable information

Worked with a team of analysts and other associates to process information

Created presentations and reports based on recommendations and findings

Deploy and administer connectors to backend database systems to populate the metadata management platform

Support the technical requirements of the Collibra Data Intelligence Cloud Platform

Fountain Group FEB 2019 – FEB 2021

Client: CDK Global

Role: Sr. Data Integration and Performance Developer / JIRA Management Lead

Created migration readiness scorecard/status reporting templates for Human Capital management that outline both overall and module specific data readiness.

Created data quality strategy that captures each data issue, criticality, owner, number of issues, clean up rate, and mechanism for cleanup.

Established data quality meeting cadence.

Defined detailed specification approval, change approval process, and management procedures.

Collected the data mapping templates that will be used to document the conversion rules from legacy to target values.

Defined high-level data requirements of what should be loaded for each Tenant. We recommend getting as much data loaded as early as possible, even if bare bones at first.

Define status communication and issue escalation processes.

Created legacy and future Workday data diagrams that capture data sources, business owners, functions, and high-level data lineages.

Ensured the future state Workday landscape aligns with data governance vision and roadmap.

Reconciled legacy and future state data landscapes to ensure there are no major unexpected gaps.

Facilitated meetings conduct research and conduct interviews to understand learner needs.

Shared work with subject matter experts, business stakeholders and peers for regular review and feedback.

Maintained project documentation and utilize standard processes and templates in JIRA.

Written quite a few groovy scripts for post-functions in the JIRA workflows.

Introduced and worked extensively on the Asset management Insights application and integrated it with the JIRA Instance.

Migrated the JIRA data from one Atlassian cloud instance to another and then merged the final consolidated single Cloud instance data into the JIRA instance

Performed the day-to-day JIRA Admin tasks Daily standup meetings and created new wiki documents and maintained the existing wiki documents in Confluence and created the Training material for all JIRA users.

Built performance dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices and to show SLA

API data acquisition from multiple sources and load the data warehouse.

Data pipeline creation and data prep by creating connections and data sets for visualizations.

Involved in trouble shooting of performance issues, for Tableau reports and administration

Manage ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau and Grafana environments.

Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance,

Cloud platform management with AWS and Azure

Used Amazon web services (AWS) like EC2 and S3 for small data sets.

Monitoring reports on servers and AppDynamics and Zenoss Data and creating Grafana reports to meet SLAs

Documentation collaboration and consultation and end-user training

Train Developers architects for best practices and opportunities for innovation as well as providing feedback on designs.

Lead development team to code software or application solutions on the whole platform for AutoNation.

Established deployment metrics and ensures each division, function, and region are measuring pre and post "Go Live" success metrics

Ensured timely escalation and mitigation of issues and risks to ensure smooth deployment process

Partnered with the IS Governance team to ensure compliance with regulations, policies, standards, procedures, and associated documentation.

Karsun Solutions Feb 2016 – Feb 2019

Clients: GSA /TSA / DHS / FCC (Federal Government Clients)

Sr. BI Engineer and Data Integration

Gather, analyze, and document functional and technical system requirements for enhancements to existing application modules and collect the appropriate level of detail required to and drive towards immediate technical results to solve client problems.

Work independently with stakeholders and clients to design and deliver JIRA workflows to meet the stated and unstated business requirements

Train end users on JIRA features during project deployments and with ongoing support via office hours

Primary JIRA Management professional for the whole JIRA Data Center instance from the scratch and implemented the entire system.

JIRA Server level and Performance level monitoring with Nagios/Tivoli tools.

Comply with applicable government standards. Application design specifications to evolving requirements and standards using Business Intelligence tools at large federal clients across a complex data landscape.

Architect/re-Architect Data Schemas to allow for efficient MicroStrategy, Tableau Grafana and Business Objects, Qlik and Qlik sense reports and dashboards

Develop new applications, modules, functionality, and features using the MicroStrategy SDK.

Develop enhancements and defect fixes to existing applications and modules.

Support the performance optimization of data aggregation and real-time reporting

Coordinate the development and migration of new application capabilities for deployment into the government enterprise modules.

Act as a team member for the development of technical and functional requirements leveraging multiple artifacts and documentation throughout an iterative, agile development lifecycle.

Developed and delivered efficient and cost-effective technical solutions to meet customer business requirements Managed and evaluated system enhancements and resolved system issues

Provided business analysis support and technical support and guidance to customers Provided quotes for estimated development time and costs for clients Liaised with line management on business developments

Provisioning, configuring and tuning Azure cloud environments supporting teams of people.

Supported data scientists in a financial environment.

Helped in machine learning and business level understanding of enterprise systems to drive innovations and transformations

Worked with senior managers, IT and business stakeholders

Provided BI & SQL Analytics and strong analytics and visualization dashboards

Microsoft Azure Cloud experience and Machine Learning architecting and solution for public/private & Hybrid cloud

Designed and developed Databricks for Azure

Guided in Data Science and Big Data - Statistics, Market Research, Market Analysis, Analytics, Data Visualization, Statistical Modeling

SQL, workflow management and Data Lake design and development

Python programming in CI/ C D Pipeline

Claim Management and Visualization reports

Advanced analytics – technologies: T-SQL, SQL Server, SSIS, Data Factory, Power BI, ETC

Provided holistic and right scale cloud solutions that in Scalability, availability for Service continuity.

Design understanding and experience in RDBMS, NoSQL, RDS, PostgreSQL and Cosmos DB.

Infosys Inc Jan 2015 – Jan 2016

Clients: Epicor / Aon Insurance

Sr. Data Integration Developer / JIRA Management

Project Overview: Center of Excellence

Demonstrated and mentor relationships and project teams.

Manage JIRA projects through Kanban Board by Creating workflows and reports and well-defined, specific, measurable activities.

Jira deliverable with Checkpoints and Milestones that need to be reached

in order to keep the broader project on track in JIRA.

Discover valuable insights to effectively manage ongoing projects in JIRA by running reports

Adhering to Best policies/practices to make the JIRA instance stable and reliable

Track the personnel and resources allocated in JIRA to each and assess where work stands at a glance.

Control project variances and change and worked with various Streams and Program Manager when escalation is appropriate, Managed technical and business risk

Understand matrix and project organizations to work effectively to resolve project issues.

Demonstrated ability to work collaboratively with, lead, and motivate other employees in a team environment to meet aggressive goals and pre-defined timelines.

Demonstrated ability to integrate complex, diverse project activities into a total system solution where projects may consist of: new technologies, highly specialized technologies, aggressive timetables, multiple concurrent tasks, tight budgets, and span multiple areas and geographies.

Provided input from the teams that helps improve the roadmap, marketing and general approach.

Follow up on deliverables to make sure everyone understands expectations and timeline Identify utilize and manage key resources required to meet project objectives.

Developed Tableau user interface knowledge: charts, graphs, tables, expressions, properties, tabs, layouts

Tableau scripting, data analysis and data sets

Developed QVDs work with Tableau to provide a scalable, reusable, metadata-driven data layer

Developed front end applications using Tableau

Developed Processes to Extract, transform and loaded data from multiple data sources into the Tableau application

Designed, build, test and debug Tableau solutions based upon specified requirements

Data acquisition Utilizing source control tools

Epic Radar and Reporting workbench report request review and analysis

Worked with Epic application SMEs to ensure Radar reporting homepages and/or dashboards are configured appropriately

Assist with discussions around Radar user security

Assist with security and access discussions regarding Reporting Workbench

Build more complex Reporting Workbench reports, as needed

Assist with creation and tracking of any new Reporting Workbench templates, as needed

Engage in production change activities

Facilitate end user report training as needed

GAP Inc. Nov 2013 – Dec 2014

Sr. MicroStrategy Solution Architect

Technologies: MicroStrategy

Installed and configured MicroStrategy 9.4.1 software Upgrade on Windows, Unix and Linux Servers

Lead and guided the project teams to ensure DEV, QA, UAT environments are stable to maximize availability for development and testing.

Monitored, mentored, and helped other IT departments like Portal and LDAP teams for MicroStrategy environment integration with their application.

Incident management to ensure timely resolution of production issues (on-call rotation) and root cause analysis.

Teradadata Claraview Project History Highlights Aug 2012 – Nov 2013

SEARS Holdings

Sr. MicroStrategy Consultant

Project Overview: Marketing analysis with respect to sears email Campaign to study the buying pattern and trends of the customers and Market and variance analysis.

Technologies: MicroStrategy

Role Description: Email campaign dashboards created for the client to give them a snapshot about their email campaign performance campaign and its conversion towards successful Sales and customer behavior.

Created Instrumentality Dashboard to see the incremental sales and materialized sales of online as well as in store sales with respect to coupons.

Comparative analysis to see the top 10 sales and campaign format and bottom 10 campaign formats to target the customers and to forecast future sales.

Data validation after the dashboard produced the data and the earlier user reports to show the dashboards are reporting accurately by creating test cases.

Hertz Car Rental Sublease Project

Project Overview: Converting legal requirements into business requirements for Hertz accusation of Thrifty car rentals

Technologies: Cognos Studio, SQL Database

Role Description: Create test cases use cases and verification of data for POC.

Gather requirement to create each business case to cover POC and data validation to show changes as in sublease project with respect to different criteria.

Test cases and user acceptance with respect to different criteria of the project for example: Returns, Salvaged cars, casualty and other various factors

Data validation and source to target mapping creating for data migration

Kohl’s Departmental Stores Oct 2011 – July 2012

Sr. Infrastructure Administrator

Project Overview: MicroStrategy upgrades implementation of Mobile server installation, configuration, Security, and administration.

Technologies: MicroStrategy, Teradata, Linux, WebLogic

Role Description: MicroStrategy BI upgrade for version 8 to 9, Schema updates

Migrations, Metadata Management, User Management, and Project move, Project Merge, Package Creation.

Object Migrations, Documentation, SharePoint Repositories, Migration of Reports and Dashboard SDK look and feel configurations.

User Profiles, Projects, DB Instances, Duplicate Projects, Monitoring the Health of I-Servers.

Server maintenance, MicroStrategy War files, Patched, Create Cases and Deployment, Upgrades, Health Center. Enterprise Manager

Intelligent Cube Publish and Monitoring, WebLogic

Target Corporation Feb 2011 – Oct 2011

Sr. Systems Engineer

Project Overview: MicroStrategy BI upgrade

Technologies: MicroStrategy 9, Teradata, Linux, InfoPath, SharePoint, JVM

Role Description: MicroStrategy BI upgrade

Enterprise Manager Reports

Health center reports and monitoring

Clean up Environment with objects deletion, clean-up of Logical

Tables, Schema update, Migrations, Documentation SharePoint

Repositories, Migration of Reports and Dashboard, ACL Scripts

User Groups, User Profiles, Projects creations, DB Instances

Duplicate Projects Project merge

Monitoring the Health of I-Servers.

Sears Holdings Aug 2009 – Feb 2011

BI-Administrator and Designer

Project Overview: Provide comprehensive MicroStrategy BI solutions using MicroStrategy 9 for Enterprise Data Warehouse working closely with DBA, QA, BI Architects, and other ETL groups. Report design, data flow design, and logical/physical Model Architecture as related to the reporting

Technologies: MicroStrategy, Netezza, Teradata, Linux, Control M, Clear Quest, JVM

Role Description: Report design, data flow design, and logical/physical Architecture as related to the reporting.

Participated in the complete implementation, process, and strategies.

Designed and developed Business Intelligence report user interfaces (Dashboards, Scorecards, Report Services Documents, Grids and Graphs) working closely with the Business Intelligence Architect to ensure designed BI solutions meet end user Requirements

Effectively translated requirements into a solid technical design and solution

Demonstrated expert knowledge in multiple technical and business areas as well.

FedEx Smart Post July 2007 –Aug 2009

Sr. Systems Analyst / Informatica Admin

Project Overview: On Time Service Measurement billing project to charge customers based on the service and Delivery.

Technologies: Informatica 8 /9, Sybase, Teradata, Business Objects XIR 2, Quality Center, HP Open

View UNIX

Role Description: Gather user requirements; create Business requirements, Software requirements

Detail design Documents, Resource allotments, Concept to design

Performance Tuning, Implementation Plans for Production and ITGs, Help Tickets

Promotion request for DEV, Test QA and Prod, Prod Installs, Post implementation follow-up

Documentation for user sign offs through Symphony, Source Forge, Quality center, HP Open view

Create mappings, Load Data in EDW, Change Data Capture, History, Archiving

Manage workflows, Informatica repositories, Performance Tuning, UNIX administration of Informatics

Manage the health of repositories, create folders, Production installs

Migration of mappings, Sessions, Workflows

Gap analysis, new development, SRS, BRS, DDS and offshore projects lead

United States Postal Service July 2006 – June 2007

Sr. Software Developer

Project Overview: Automated Postal Counters

Technologies: MicroStrategy 8, Teradata, Sybase, Linux

Role Description: Develop MicroStrategy Reports, Dashboards, Scorecards, KPIs

Change Request, Create, Update, Edit, Metrics, Hierarchy, Prompts,

Teradata, SQL queries for remedy ticket management in EDW.

Unit testing for performance analysis, Variance Analysis, ECAT, Performance tuning

Create Report information pages, Sample reports, Create and Update

Promotion request in DEV, TEST, QA, PROD environments,

Narrowcast server, Distribution of reports, scheduling

Abbott international Mar 2006 – June 2006

Regulatory Affairs and Product Registration

Project Overview: New Product registration in other countries following EU and FDA regulations for Abbott nutrition product

Technologies: Informatica, Oracle, Epic, Flat Files, UNIX

Role Description: Technical Project lead

JAD sessions to collect the requirements

Create project plan and implementation

Analysis of Source data and data validation

Source to Target design document

New product registration through EU and FDA regulations

ETL Design, developed mappings, workflows and schedule to load EDW

Unix shell scripts for event watch

Log in defects in and manage review, Issue, Resolution trackers

References provided upon request

Contact this candidate