Business analyst - Information Technology Resume Search
Business analyst - Information Technology Resume Search
My Spider Scam Awareness Contacting Us F. A. Q.
Job Seekers
Search Jobs
Browse Jobs
Post a Resume
Job Alerts
Search Resumes
Browse Resumes
Post a Job

Business analyst Resume

Desired Industry: Information Technology SpiderID: 82305
Desired Job Location: Milwaukee, Wisconsin Date Posted: 11/21/2019
Type of Position: Contractor Availability Date:
Desired Wage:
U.S. Work Authorization: Yes
Job Level: Experienced with over 2 years experience Willing to Travel:
Highest Degree Attained: Bachelors Willing to Relocate: No

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

• 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

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.

• 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.


• 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.


• 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.


• 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

• 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]

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

Candidate Contact Information: has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.


© 2020 Job Spider
Privacy Policy | CC Marketing Sites | Site Map | Links