Manpreet Kaur 262-***-**** /adg7wb@r.postjobfree.com

Idea Generator and Innovator, Defining and Implementing Technology Solutions to Meet

Business Needs

OVERVIEW

●Comprehensive IT experience managing software design, development, implementation, and testing of business application systems spanning health insurances, retail, and financial industries.

●Lead large programs and projects, including building and influencing high-performance teams and individuals.

●Expert in building new systems and identifying root cause of issues and translating complex ideas in actionable steps.

●Collaborative problem solver, leveraging process improvements, project management, new technologies, and leadership strengths to turnaround troubled operations.

●Extensive experience in data warehousing, using ETL processes and iColud platform.

●Create complex BI reports, using IBM Cognos Reports, Business Objects, Discoverer 4, Spotfire, and Power BI.

●Database development experience, using Oracle, MS SQL, DB2, SQL Loader, Azure SQL, No SQL Mango DB, and Teradata.

TECHNICAL SKILLS

DW Methodologies:

Kimball, Inmon, 3NF, dimensional modeling, DAMA-DMBOK, Erwin, ER Studio Embarcadero, Visio, Six Sigma, NoSQL, MangoDB, Informatica PowerCenter10.4 / 9.1.0 / 8.5.1

Computer Languages:

SQL, PL/SQL, SAS, Visual Basic 4.0 - 6.0, VBScript, HTML, C++, VC++, Prolog

RDBMS:

Microsoft SQL Server 2019/2018, Oracle 12c/11, DB2, MS Access, Sybase, Azure, AWS(RD,Redshift)

Project Methodologies:

Waterfall, Agile ( Scrum and Kanban )

Reporting Tools:

Business Objects XI / 5.1, Discoverer 4.0 User / Admin, Crystal Reports 9.0 / 8.5 / 8.0, Spotfire, IBM Cognos Framework, Cognos Analytics 11

Operating Systems:

Microsoft Windows XP, Windows 2000 / NT, Windows 95 / 98, UNIX (HP-UX, Sun Solaris, AIX),iCloud

PROFESSIONAL EXPERIENCE

Associated Bank

Sr Data Architect Jan 2018- Current

I have managed all the data related entities (project\scope\people\governance) related to line of business Benefits Risk and Consulting

Responsibilities:

●Analyzing, planning, organizing, and leading teams in support of financial, insurance and salesforce applications

●Worked on creating the detailed plan for the projects

●Worked on data governance(DAMA-DMBOK) aspect of process development security and privacy, integrity, usability, integration, compliance, availability, roles and responsibilities, content, metadata and overall management of the internal and external data flows within an organization

●Defined accountability and responsibility for data and processes that ensure effective control and use of data assets.

●Created the enterprise data warehouse and data marts

●Designed consumer layer in Cognos for business intelligence and analytic use cases

●Analyzing the business requirements and translated them to functional and technical requirements

●Designed Data Models,Data marts, load strategies, communication plan etc

●Mentored teams to work towards the organizational goals effectively

Environment: Informatica Power center 9.1, ILM, E\R Studio, DB2, Salesforce, MS Office, Visio, Window 2007, PL\SQL developer 8.0, Rapid SQL, SQL Server, Cognos, Power BI, SSIS, SSAS, SSRS, Cognos 10, Azure database, Snowflake

Sr. Independent Consultant April 2016- Jan 2018

Kohls, Assisting Hands

Responsibilities:

●Analyzing, planning, organizing, and leading teams in support of production applications while managing risk, workload, scope, capacity, schedule, and budget.

●Worked with different stakeholders like project sponsors, business and technical partners, subject matter experts, end users etc.

●Worked on continuous improvement solution towards the goals of an organization

●Involved in following the processes defined by six sigma and DAMA-DMBOK

●Managed service level agreements; ensure compliance to mitigate risk, increase service/business impact and reduce costs.

●Identify potential risks associated with the Application & Integrations portfolio. Prioritize and create mitigation and risk retirement strategies. Lead risk retirement projects per priorities.

●Mentored teams to work towards the organizational goals effectively

Environment: Informatica Power center 9.1, ILM, E\R Studio, DB2, MS Office, Visio, Window 2007, PL\SQL developer 8.0, Rapid SQL, SQL Server, Spotfire, Power BI, SSIS, SSAS, SSRS

Kohl’s, WI, Brookfield, WI (Wipro) September 2013 -April 2016

Sr. TDM Architect

Kohl's needs to generate the bulk data for all the integrated applications in Merchandising. In merchandising line of business planning, allocation, distribution, product management, customer management, markdowns and project analysis, etc. are done.

Responsibilities:

●Provided the process to capture the data requirements.

●Provided the project plans, architecture, process, data-mining standards.

●Worked with cross functional teams

●Gathered all the data models related to planning, allocation, projection analysis and followed DAMA-DMBOK process defined by organization etc.

●Participated in decoding Informatica, XML, and messaging queue.

●Involved extensively with SOA, WOA,Distributed Computing Architecture, Cloud Computing Architecture

●Coordinated and created the logical and physical designs.

●Coordinated the effort to create BI reports for leadership team

●Created project ROI, resource, time and risk planning.

●Coordinated the development, testing, and deployment of the process components of the project solution.

●Mitigation plans for known risk and analyzing unknow risk

●Mentored different team members with DM architecture and process flow.

Environment: Informatica Power center 9.1, ILM, E\R Studio, DB2, MS Office, Visio, Window 2007, PL\SQL developer 8.0, Rapid SQL, SQL Server, Spotfire, SSIS,SSAS,SSRS,AWS

Vedicsoft Solutions Inc May 2004 – Aug 2013

Project Manager/Datawarehouse specialist

Advised multiple clients in Wisconsin, such as Department of Transportation, American Family, WeaTrust, Dean Health Services, APS Health System, and Wells Fargo.

Responsibilities:

Determined the scope of the project (Data mart implementation and upgrades).

Designed the project using MS project.

Controlled the work breakdown structure (WBS) (for both IT and business).

Involved in doing strategic planning.

Determined the risk involved in the project from historical information.

Developed the business requirements and business rules for IS Team.

Worked with the marketing management to develop requirements for Business-Objects reports.

Coordinated test team activities to meet UAT, production release deadlines, and testing of BO reports.

Oversaw the development effort of internal metrics and IS data warehouse team (Informatica and data modelers).

Managed identification and resolution of problem.

Documented all the procedures to be followed in the project (communication plan, roles and responsibilities, project phase achievements and accomplishments).

●Provided the process to capture the business requirements to technical requirements.

●Provided the guidelines, naming standards, and best practices for building the data warehouse.

●Worked extensively on Salesforce and Onyx data, MQ series, and XML.

●Created the logical and physical designs.

●Coordinated the development, testing, and deployment of the process components of the project solution.

●Designed and built ETL strategies and prototyping.

●Extensively used ETL for data movement, data migration, etc.

●Created the mapping to migrate the Salesforce data into existing warehouse.

●Mentored different team members with data warehouse and Informatica concepts.

Environment: Informatica Power center 9.1, Salesforce,Sales-force connect, Datastage7.5.1, AutoSys, MS office, Visio,Window 2007, Erwin 7.2.5, PL\SQL developer 8.0, Rapid SQL 7.6.4, Razor SQL (Sybase and SQL server),Informatica, Erwin, E/R studio

EDUCATION

Master in Computer Sciences (UMES, MD)

Diploma in Software Development (National Institute of Information Technology, India)

Kerzner Best practices in Project Management (program # 100*******)

Certified Data Modeler (Brainbench #4253402)

Certified in Data Warehousing Concepts (Brainbench #4253402)

Contact this candidate