Baji Mohammad

adawe2@r.postjobfree.com

adawe2@r.postjobfree.com

860-***-****

Visa H1

Location: Milwaukee, WI

Looking for C2C position only

Senior IT professional having around 15 years of experience in Business Systems Analysis, Data Analysis, Project Management, Application Design/ Development and Client Relationship Management.

PROFILE SUMMARY

Highly accomplished IT professional with 15 years of experience in Insurance and database solutions industries in Business Systems Analysis, Data Analysis, Data Profiling, Application Design, Development, Production support and Client Relationship Management

Skills in gathering requirements and creating Business Requirements Document (BRD) and Functional Requirement Documents (FRD), facilitating Joint Application Development (JAD) sessions, rapid application development (RAD sessions, developing Use Cases, Test Approach, User Acceptance Testing (UAT), Requirements Traceability Matrix (RTM) and other client specific documents

Knowledge and experience with various ETL and Business Intelligence tools that includes Talend, Ab Initio, Informatica, Business Object Crystal Reports, Cognos.

Strong experience in working with various database environments like Oracle, GreenPlum, Teradata, IBM DB2, SQL Server 2010 and MS Access databases

Excellent team player with experience in working large size project team / Strategic initiatives that includes Business stakeholders, Architects, Project Manager, ETL Developers, Quality Assurance team

Proficient in eliciting requirements and assisting the ETL/ Quality assurance team for business intelligence / data warehousing environments including technologies and processes across data sourcing, validation, reconciliation, and reporting

Strong experience of directing the cross-function teams across complex strategic initiatives in a matrix company environment

Expertise in performing complex GAP Analysis and Impact Analysis on various large sized projects

Awareness of major SDLC methodologies & models – Staff Augmentation, Co-Sourcing, Managed Service, Fixed Prices, Waterfall, Agile in both onsite-offshore model

Leadership & Management Skills: Focused on integrating business customers, business process and technology to deliver business value. Expertise in various management activities includes resource management, on boarding, knowledge transition, supervision and performance appraisals

Excellent in implementing theoretically and practically sound solutions with end users in mind

Ability to adapt to change, balance multiple priorities and meet deadlines

Highly motivated, strives for excellence in delivery with strong communication skills, fosters relationships and active participant in process improvement

Extensive collaboration with the QA in providing inputs to create Test Strategy, Test Plans & Test cases

Strong analytical and organizational skills and highly detail oriented. Ability to access project process and streamline them for process improvement

Strong knowledge on Insurance Industry [P&C – Business and Personal Insurance] and experience working with various insurance Line Of Business, Third party data, Risk Management etc.

Experience in Data Profiling to identify data issues and recommend ideas for resolution

Expertise with statistical filing, regulatory & management level report content and fulfilling these requests

Strong knowledge of MS-Office products, Mercury tools, JIRA, TFS and Remedy

Experience with variance analysis, synergy and dis-synergies reporting.

Able to work independently and remotely from the program team but with a commitment to collaboration and communication and remote development of business relationships. The ability to adapt quickly in a fast paced environment.

Advanced experience in Microsoft Excel (e.g. pivot table, aggregating multiple data sources) including complex reporting and financial roll up to executives

Possess strong sense of personal accountability, ownership, delivery and ability to drive success

PROFESSIONAL EXPERIENCE

Business modeling:

Microsoft Visio

Requirement Management:

MS Office (Word & Excel), TFS

Front end tools:

MS Front page, MS Project, MS Office, .Net, MS Power Point

Defect Tracking:

HP Quality Center, JIRA, TFS

Query and Programming:

SQL, XML, COBOL, VB Script, Java Script, VBA, HTML

Databases:

Oracle, GreenPlum, Teradata 13.0, DB2, MS Access, SQL Server 2010

Document Management:

SharePoint, VSS

Methodologies:

Agile, Iterative Development, Full SDLC

Tools:

MySQL, phpMyAdmin, WinSQL, Alterian, SAS, Business Objects, IDQ, Meta Center, GW Policy Center, GW Claim Center, TOAD, HP MIS, SCM/ISCMS, Rally, AQT, Rational Rose, Ab Initio Web EME, Informatica, Talend, GuardIEn, CBRE Sequentra, CBRE TransAct, Sharepoint

PROJECT EXPERIENCE

Jul 2017 – Till Date

IT Business Data Analyst / Project Manager, Johnson Controls International, Milwaukee, WI

Project: JCI Tyco Integration – Site Network & Voice Standardization and Decommission

Tyco and Johnson Controls are undergoing a merger that became effective on September 1, 2016. This project will bring over 500 legacy Tyco locations into compliance with the merged company’s network reference architecture and ensure both legacy network & voice equipment and circuits are decommissioned following the site standardization.

The network and voice standardization will ensure all end of life network equipment is replaced, leverage lower cost internet WAN model where possible, standardize the IP addresses at legacy Tyco locations, eliminate IP conflict between the two companies and place the new network equipment under managed service model. The decommission phase concentrates on removing legacy network hardware from inventory, quantifying circuit and equipment synergies and dis-synergies, closing vendor contracts and ensuring billing has stopped.

Responsibilities

Interview the business community to determine requirements and document those for mapping and validating data as part of the data collection, transformation and building centralized repositories

Create Business Requirement Documents (BRD) and Functional Requirement Documents (FRD)

Interpret data from multiple sources and research with business to determine various data points for implementation based on the requirements

Identifies and documents gaps across data sets

Gather, refine and document business/functional requirements for the assigned project(s)

Assist in Data Management and augmentation by adding value to base data by adding information derived from internal and external source

Mange the information lifecycle and ensure data quality

Manage the data lifecycle from key databases to the Site Provisioning Portal (SPP) and SPP updates back to key databases

Compliance with corporate standards and policies for data management including Data Release Forms aligning to Foreign Ownership Control or Influence (FOCI) requirements

Own and manage the SPP SDLC by creating, maintaining and publishing a data dictionary

Create process and method for intake and prioritization of enhancement requests including escalation of sites which need to be promoted for various reasons

Agile and Sprint for Application Development

Act as Subject Matter Expert for individual business processes and various assigned areas

Document gaps identified for detailed coverage analysis and co-relations across various datasets

Perform analysis on datasets to determine their quality, coverage, complexity

Communicate business concepts and expected functional behavior to developers

Assist with Global ID creation process and SPP site provisioning

Manage the full decommission process globally which includes ITSM requests to cancel legacy technology Monthly Recurring Costs (MRCs)

Track and report synergies/dis-synergies created as a result of decommissioning legacy circuits and other MRCs from global network and voice standardization projects

Ensure decommission activities are reflected in the monthly and annual financial planning and reporting process

Ensure effective and timely communication to IT and integration Executives, business owners and finance stakeholders at a project and program levels such as network and voice standardization

Apr 2016 – Jun 2017

Lead Data Analyst. Infogroup, Ames, IA

Project: Infogroup Database Solutions

Infogroup is a big data, analytics and marketing services provider that delivers best in class data-driven customer-centric technology solutions. Its data and software-as-a-service (DaaS & SaaS) offerings help clients of all sizes, from small companies to FORTUNE 100TM enterprises, increase their sales and customer loyalty. Infogroup provides both digital and traditional marketing channel expertise that is enhanced by access to our proprietary data on 245MM individuals and 25MM businesses, which is distributed real-time to our clients.

Responsibilities

Review Business Requirements to identify ETL requirements and utilize Talend to develop ETL processes that support the creation of databases, table spaces, tables, indexes, triggers, procedures, and other database objects

Experience with data warehouse tasks supporting requirements management, architecture design, analysis, mapping, modeling, integrity checking, impact analysis and regression testing

Understanding of data warehouse and master data management approaches, industry standards and industry best practices.

Analyzing source system data, existing data models, and profiling data (using SQL)

Consult with clients and Implementation team to identify current processes, clarify business objectives, and to establish technology requirements

Conduct initial data analysis on input files to verify content. Be able to standardize data for processing

Participate in system/database design or enhancement and communicate results effectively. Collaborate with Technical Lead on data model

Documentation will include: Technical Specs, Business Requirements, Process Flows, Change Requests, Status Reports, Data Reports etc.

Prepare high-level system flow for the proposed solution and review with the Implementation Team and client if necessary

Prepare detailed process flows required for IT and Process development

Guide clients in business rule development. Implement business rules in database

Test, maintain, and monitor data and list prep processes for building and maintaining the client database

Perform Quality Assurance on: software builds, data processing, data loads, reports etc.

Perform and coordinate both unit testing as well as end to end testing with client and vendors

Assist Project Manager to develop initial project plan and subsequent updates

Work with clients, Implementation team and all related IT departments to achieve solution-oriented results

Analyze client issues

For stabilized customer database implementation, responsible for ongoing minor change requests.

Jan 2016 – Mar 2016

Sr Data/Business Analyst, QBE North America, Sun Prairie, WI

Project: MLS Divestiture – Claim Conversion

This project’s objective is to transition Mortgage and Lenders Services (MLS) applications and associated data from QBE to National General as per the terms of the sales agreement. Convert claims processing for homeowners, renters and auto claims from AC, ISCS and Siebel to Guidewire Claim Center including full history of claims. Scope also includes converting policy and claim documents from DocuVue and Documentum to ImageRight as DocuVue and Documentum will be transferred to National General.

Responsibilities

Integrating new data sources for structured/semi-structured and unstructured data from various sources in support of the MLS Divestiture efforts

Developing solution by preparing and evaluating alternative workflow solutions

Providing documentation for all developed ETL processes, including process flow and data mapping

Assess, document and communicate impact of change to business and individuals by collaborating with internal and external key stakeholders

Interact with local/remote development teams and other regional BI teams for production support

Providing leadership involving conceptualization, initiation, specification and testing of the data and reporting solutions

Coordinating with domain experts to develop and refine data management best practices, policies, and procedures

Working with ETL developers and project teams to understand analysis and reporting requirements; ensuring work product meets users’ needs

Oct 2014 – Dec 2015

Senior Data Analyst/ Business, American Family Insurance, Madison, WI

Project: Enterprise Data Management

Enterprise Data Management (EDM) group was setup with a vision to define an enterprise wide Data Management program that thoughtfully manages both operational and analytic data as an enterprise asset. The EDM group ensures that the capture and use of data assets are carefully controlled, and investments in these assets are effectively leveraged to achieve enterprise objectives.

The Business Intelligence Center (BIC) is a logical grouping of data components across multiple environments right from its raw format to an analytical view ready format. The primary purpose of the BIC is to house the data that is then used by business for generating insights through business intelligence applications at American Family Insurance.

Responsibilities

Performed source target mapping in support of report and warehouse technical designs

Identified sources of information for a wide variety of problems and needs

Design data warehouse development and enhancement projects including data modeling, end to end solutions

Coordinate with offshore team regarding strategies and developing roadmaps for BI projects end to end

Provide support to end users of BI Applications from system analysis to BI/ETL development and support

Troubleshoot data warehouse and BI issues using SQL development and querying tools (e.g. Toad), provide production support and help resolve nightly ETL data & Cube refresh issues

Worked with all divisions across the enterprise to capture business requirements related to data and reporting solutions to support corporate strategies, goals and objectives

Design and develop various Enterprise Business Intelligence Solutions including interfacing and integration with ERP systems of records, ETL design, Data modeling and database design, reporting and analytics solutions

Identified drivers of business results and recognize appropriate measures, and translate that information to business analytics

Developed data management and reporting requirements and managed data quality in collaboration with business systems and data department

Developed effective methods to improve the quality of information gathering, resulting in improved content and value

Produced various functional, data load and validation specifications, workflow and process documentation

Created documentation, extracted and analyzed data, managed requirement changes, performed UAT

Handled multiple projects and assignments with changing priorities while still meeting deadlines

Studied complex data models and process flows, their inter-dependencies and relationship to Credit Risk

Served as a liaison between technology, operations, product management and the Data Analytics team

Oct 2013 – Sep 2014

Sr. Data/Business Systems Analyst, Travelers Insurance Company, Hartford, CT

Project: Personal Insurance Management Systems

The Management Information area provides Travelers executives and Personal Insurance decision makers with the information, tools and applications required to make timely and informed strategic and tactical business decisions. The Technical Data Management team provides analytical support for the data capture into, and use of data out of, the strategic data warehouse for multiple subject areas including auto and property quote activity, issued auto and property policy activity, and claim, billing, BRS, Direct Mail and Web Marketing, and customer web navigation activity.

Systems analysts interpret business requirements and translate them into technical requirements, which determine how the data will be stored in the warehouse, how it will be transformed in order to support reporting and analytics (data marts/publishing layer), and ultimately how it is mapped to extracts and to business intelligence tools to deliver information to the business community.

Responsibilities

Created System Requirement Document (SRS), Detailed Requirements Document (DRD), Source to Target mapping document (STTM) and Traceability matrix

Involved in different levels of data profiling, data mining activities

Participated in Joint application requirement sessions to gather requirements and documentation

Actively participated in program planning and project planning for the year 2013/2014

Served as a liaison between the business specialists and the technical team

Contributed to the definition of scope, preparation of work plans and definition of business requirements.

Assisted ETL development done using Informatica and universe development using business objects

Performed the reverse engineering in Informatica to understand the ETL logic

Participated in the review of Test Strategy and Test plan documents

Assisted the function lead in creating of estimate and defining the roles/responsibilities in the project

Documented business process flow charts; business requirements; data sources and attributes; dimensions, facts, metrics, filters, etc.,

Jul 2011 – Sep 2013

Sr. Data Analyst, Business Systems Analyst, Travelers Insurance Company, Hartford, CT

Project: Select FlowMart

Flow is a key business driver for Select. Proactively monitoring and acting upon flow metrics like hit ratio and pass through keeps Select ahead of the competition. Over the systems developed to support flow analysis have evolved to require many manual processes to understand basic flow measures.

The objective of the this program will provide a flow data mart that consolidates flow related data onto a single database, provide standard flow date capture across all lines, furnish a suite of information delivery methods including predefined reporting, self-service reporting, analytic applications, executive dashboard enablement and furnish a scalable foundation to expand upon.

Responsibilities

Create DA work package that included Analysis Tree, SQL Vision and SQL Results

Responsible for data analysis and data mapping for MS SQL Server and Teradata

Mentored team members and provided adequate training to new DA’s in the project

Served as a liaison between the business specialists and the technical team

Contributed to the definition of scope, preparation of work plans and definition of business requirements.

Facilitated and managed meeting sessions with committee of Subject Matter Expert from various business areas

Responsible for gathering user requirements that are specific to our scope of work

Participated in JAD sessions for requirements gathering

Performed Risk Analysis of the requirements to identify the project critical success factors and prioritize functional requirement

Created Functional Requirement, reviewed with stakeholders and received sign-offs

Created Requirements Traceability Matrix document reviewed with stakeholders and received sign-offs

Participated in Required Data Elements sessions and identifying the sources

Participated in creating test strategies, test plan for QA testing. Also involved in identifying the test scenarios for UAT

Apr 2010 – Jun 2011

Business Systems Analyst, Travelers Insurance Company, Hartford, CT

Role: Role: Risk Assessment Report

This project will build the foundation needed to gain much needed operational efficiencies around the reporting and analytics created with Risk Control data. It will encompass the automation of extracting, cleansing, scrubbing and loading this data. Overall it will significantly reduce the amount of time it takes to get the Risk Control data in a useable format.

Responsibilities

Data Profiling, writing scrub rules, providing input to data modelers that include Data type and length

Dealt with more than 5000+ data attributes, data mapping and modeling

Involve in the data profiling activities for the column assessment and natural key study

Assisted the project manager in setting up the direction for business analysis team

Allocate the work to DA team members and oversee their daily work and perform quality check

Forward to the PM any other matters requiring substantive or time-consuming issue resolution (i.e. resource response time, communications, project workflow, etc.

Schedule and facilitate the daily stand meetings, weekly touch point meeting with Dev and QA team

Scheduled, Facilitated & managed meeting sessions with business team members from various biz areas

Responsible for gathering user requirements that are specific to our scope of work

Closely worked with Data Modelers with support and clarification on the requirements

Responsible for data analysis and data mapping via MS SQL Server

Performed Risk Analysis of the requirements to identify the project critical success factors and prioritize functional requirement

Developed the Functional Requirement documents, reviewed with stakeholders and received sign-offs.

Created Requirements Traceability Matrix document reviewed with stakeholders and received sign-offs.

Participated in Required Data Elements sessions and identifying the sources

Participated in creating test strategies, test plan for Quality Assurance testing and involved in identifying the test scenarios for UAT

Jun 2009 – Feb 2010

Sr Data Systems Analyst & Onsite Coordinator, Travelers Insurance Company, Hartford, CT

Project: Loss Database MICI

The project involved the extraction of data from different source systems and loading the data into data warehouse. Data marts were then developed for specialized areas within the company that extracted the data from the central data warehouse repository.

The major job involved the cleansing and normalization of the data in the staging area then loading data to the data marts. The data mart enabled an insight into the current and future service needs, based upon the various reports generated by the client.

Responsibilities

Documented business process flows; business requirements; data sources and attributes; dimensions, facts, metrics, filters, etc., Inventory Control Reporting

Worked with data modeler to design table structure(s) for DW

Worked with IT to populate table structure(s) and perform UAT of data

Developed Micro Strategy report(s) and/or dashboard per documented business document

Provided weekly status report of progress and hours worked

Worked with SQL, Micro Strategy Platform – Web Professional v9.4.1, Query Building tool

Knowledgeable in data discovery and data profiling

Documented business reports and/or dashboards in Micro Strategy

Prepared operational BI Reporting

Presented dimensional models and BI concepts like attributes, facts, and metrics

Documented business process flows

Prepared UML diagrams to develop a pictorial representation of the requirements

Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping

Collected information about different entities and attributes identified primary keys and foreign keys for the entities. Mapped surrogate key tables to the required dimensions

Jan 2008 – Apr 2009

Tech Lead & Onsite Coordinator, Travelers Insurance Company, Hartford, CT

Project: Personal Insurance - CDE/Atlas3

Travelers offer a wide variety of insurance and surety products, as well as risk management services, to numerous types of businesses, organizations and individuals. The company’s products are distributed primarily through U.S. independent insurance agents and brokers.

The Common Data Entry (CDE) system is an Internet based data capture front end system used to quote and issue Auto and Homeowners business used by Travelers independent agents. Atlas3 supports external Independent Agents and Gateway Comparative Raters (Gateway Comparative Raters is a system for giving customers quotes from several companies). CDE supports internal Travelers Service Centers and GEICO (GEICO is a car insurance company that doesn't have their own Homeowners insurance so they sell Travelers Homeowners, which makes them CDE’s biggest customer).

Responsibilities

Ensure compliance with Travelers Architecture standards

Assess impact of project requirements on application architecture

Review architectural changes and provide optimum cost-effective solutions

Provide estimates for projects in demand queue

Provide technical guidance to the team

Responsible of design documents

Participate in request prioritization activities

Participate in status review meeting

Approve Endevor packages

Partner with DevOps and Release Manager to Ensure Deployment

Apr 2006 – Dec 2007

Team Lead/Sr Data Analyst, Travelers Insurance Company, Hartford, CT

Project: PLTS AES – LOB System Building

This engagement includes building and setting up the test environments for Application team to test their code changes at right time. The scope diversifies for preparing the sync up plans for production version of code and data. This includes loading the production data to test regions, technical checkout of all the regions – Excalibur and Atlas3/CDE, staging libraries for table base tables, freezing the databases, copying the KBMS files to IMS files, adding and removing the private and frozen libraries, Recycling the CICS regions and FLIP the IMS regions, informing Pegasus team about the technical checkout, updating the frozen load libraries in the CARS CLIST for IDEAS application and Incident management for the environments.

Responsibilities

Point of contact for test environment set up and maintenance

DB2 database maintenance and DBA activities

Provide off hour Support to the applications And Automated regular activities

Offshore communication to give tech. updates, review offshore activities and resolve technical queries

Development of Quality Procedures related to the project and Metrics Collection

Maintenance of Knowledge Repository

Sep 2004 – Feb 2006

Mainframe Programmer, Travelers Insurance Company, Hartford, CT

Project: Delta – The New Compensation Plan

VALIC is a member company of American International Group (AIG) with line of business in Annuities. V-system is an in-house developed system which acts as a core for their business. A new compensation system was designed to align the AIG VALIC advisor’s behavior and income with the goals of acquiring new business and servicing clients. The compensation plan motivates advisors to enroll new clients, increase periodic contributions, service both flowing and non-flowing clients, and secure rollover dollars. The new compensation system has 3 primary components. 1. Flow commissions compensate advisors for enrolling and servicing clients that remit periodic contributions; 2. Asset based commissions compensate advisors for servicing clients and retaining assets for non-flowing clients; and 3. A tiered rate commission compensates advisors for rollovers, transfers from other carriers, and non-periodic flex payments.

Responsibilities

Responsible for enhancements to the existing system based on the business and technical and requirement specifications

Involved coding, testing, and debugging both online and batch programs

Preparing Test Strategies, Unit and Integration Test Plans, troubleshooting and supporting the developed code on mainframes

Support for batch schedule and resolving the abends

24 x 7 On-call support for the V-System application

Preparation of delivery documents and checklists

Work Allocation and monitoring

Getting reviews done as per schedule

Ensuring timely and defect free delivery

EDUCATION & CERTIFICATIONS

Bachelor of Engineering (B.E) in Electronics & Communications Engineering from Andhra University, Vishakhapatnam, Andhra Pradesh, India

Diploma in Electronics & Communication Engineering (D.E.C.E) from State Board of Technical Education & Training, Andhra Pradesh, Hyderabad, India

Certified Scrum Master professional (SMC) from SCRUM study - Accreditation Body for Scrum and Agile

Certified Project Management Associate (IPMA D) from International Project Management Association

Certified Associate in General Insurance (AINS) from American Institute for CPCU [AICPCU]

***

Contact this candidate