Senior Consultant
Company: nFolks Data Solutions
Location: Seattle
Posted on: January 27, 2023
|
|
Job Description:
INFORMATION MANAGEMENT CONSULTING SERVICESOne stop shop for all
Data Solutions and Information Management ProjectsOur global
clientele is a testament to our training servicesNeed of
high-caliber teams and/or IT professionals contact us we are best
at it.nFolks Data Solutions is an IBM Business Partner and renders
Information Management solutions, learningservices and staffing
services to clients globally, from offices located inNorth America,
Europe, and Asia. Comprehensive approach to provideindispensable
Data Solutions helps us deliver the best to our globalclientele. As
a market leader, we focus on Information Managementsolutions to
align measurable business goals and objectives withinformation
technology.Aware of the current market demands and requirements, we
work towardsutmost customer satisfaction. Our pragmatic outlook has
resulted inventuring into new markets and witness steady growth
over the years. Wehave unparalleled system of- services, support,
and development -whichhelped us in successfully completing several
end-to- end implementations ofIBM InfoSphere Information Management
projects.Our expertise is in Architecture, Analysis, Design,
Development,Administration, Training, Maintenance, and Support
using IBM InfoSphereapplications such as DataStage, QualityStage,
Information Analyzer,Metadata Workbench, Business Glossary, and
FastTrack. We top themarket in IBM InfoSphere solutions -conscious
of Quality, Price, andCertified IBM Solution Developers. To build
successful Data Solutions youneed the best talent in tech field;
consequently all our Architects, TeamLeads and Senior Developers
are IBM Certified Solution Developers. Our ITpersonnel participate
in company organized education and training classes along with real
time experience allows us to offer our clients an entire teamof
experts.Information Management Consulting ServicesOur certified
solution developers deliver successful Data Solutions and
specializein end to end implementation of Information Management
projects. We strivenot only to meet the client's requirements but
also exceed their expectationrecurrently.We are preferred partners
with training companies who provide learning servicesto global
clients. Our presence throughout North America, Europe, and Asia
aid usin achieving customer satisfaction.Conscious of the client's
demands; we aim to nurture their requirements with ourstaffing
services in order to provide high-caliber teams and IT
professionals.WE HELP OUR CLIENTS STAY AHEAD OF THE COMPETITIONWe
work with a wide range of clients, from top organizations to medium
and smallscale businesses. OUR PEOPLE MAKE US GREAT WHAT OUR
CUSTOMERS SAY format_quote ( Associate Vice President, FCS ) We
have hired nFolks to lead the DataStage oversight at an extremely
complicated and politically-charged Financial Analytics re-start.
Being brought in as a remediation team is always stressful but
nFolks team was always positive and able to identify design issues
and alternative designs. ( Global Director, FCS ) nFolks team has
provided us resources on one of our DataStage implementation and
did a great job with their resources who had a good technical
understanding. ( Manager Strategic Alliances, snapLogic ) nFolks
are very sharp thinkers and have great understanding of the
fundamentals of business integration and transformation. I would
not hesitate to recommend nFolks to any project - they will be a
great asset. format_quote Case 1: Louisiana Department of
Corrections Client: Louisiana Department of Corrections
Project: DB2 Migration from Legacy SystemsLouisiana Department of
Corrections implemented the DB2 migration by creating the DB2 Data
Store as their first IT enterprise modernization. The department
planned to extract the data from their existing Mainframe Mapper
and Notes legacy databases and move the data to DB2 database as the
basis for the enterprise "database of record" after going through
the compete cycle of profiling, cleansing and transforming the
legacy data for web-OLTP using IBM Information Server Suite of
products as well as query and reporting using IBM Cognos BI
tool.The issue for the client was extracting the data from legacy
hand written very old databases such as Mapper and Notes for
different database objects/tables & applying rules on top of it to
load data into DB2 Database. All this was targeted to be completed
in limited budget and fixed timeline. In addition, the Information
Server was deployed on Windows Operating system with limited
resources sitting on a VMWare for which support model from vendors
was not existing. As these were legacy databases parent/child
relationship between tables was also not present. As a result this
check needs had to be made in ETL code and records which did not
meet the requirement had to be captured and emailed to Data
Owners.nFolks Data Solutions took this as a challenge and used IBM
Information Server suite of tools provided by client by coming up
with different solutions such as using the correct ODBC drivers as
extracting data from legacy database was not easy with limited
drivers supporting it partially. nFolks used a combination of
Parallel and Server jobs as it was creating lot of processes on
windows server & parallel extract or huge extract would break the
connection with legacy databases Scripts were written to monitor
the hanged processes & clean them frequently as the no of resources
are limited. The data was also Unicode and special characters had
to be handled carefully so that data retains its original form and
loaded into DB2 database.Following the implementation, the
department made the process seamless. Programs & scripts written by
nFolks Data Solutions made the process seamless and in time
delivery of project within limited budget by addressing all issues
which made the migration of legacy databases to DB2 database
successful. Case 2: Wells Fargo Client: Major Financial Institution
in the US
Project: Upgrade of ProfitMax NextGen SolutionProfitMax NextGen
objective was to calculate Profit and Loss metrics for the
wholesale line of businesses at various levels like Customer,
Relationship, Officer, Accounting Unit (AU), and Organizational
Unit (OU) by building a Profitability Data Warehouse. The ProfitMAX
NextGen is a rewrite of current legacy application, which is a
customer and product profitability tool used by the Wholesale
Banking division of the client to view customer / product
profitability. 3000 users were estimated to access the solutions
and would enable them to view and measure profitability at an
officer, AU and product level.The issue for the client was that the
Data Warehouse modeling was done with very poor practices & no best
practices had been in place by previous implementation partner,
leading to large number of issues, resulting in inaccurate data
with missing relationships between target tables. The issues
resulted in an unstable code and the reporting results were
affected.nFolks Data Solutions, along with another implementation
partner, were requested to fix the issues caused by the previous
poor implementation. With best Solution Developers and Architects
being deployed with right strategy, we were able to fix the code
issues as well as the design issues & developed a solution which
resulted in generating reports at 20 levels down granular reports
across the whole sale line of Business Services and products for
the financial institution, thereby meeting the primary end-point
requirements. With the implementation, client was able to save lot
of money and got and effective solution, which resulted in
generating reports granular reports for 20 different at 20 levels,
thereby providing streamlined data for improved decision making.
Case 3: Gulf State Toyota Case 3: Automotive Distributor in the
US
Project: Migration from DataStage 7.0 to DataStage 8.7Client is a
distributor for a large Japanese automotive company in the US.
Client operates with 150+ dealerships in 5 states. Data Migration
project was one of the high priority projects for the client
wherein they were migrating their systems from IBM InfoSphere
DataStage 7.0 version to IBM InfoSphere 8.7.Client wanted to
migrate the code from DataStage 7.0 version to DataStage 8.7
version but most of the jobs were server jobs with few plug-ins
being used which were no longer available in DataStage 8.7 version
and these needed to be converted to parallel jobs. Overall
Architecture assessment was based on different factors such as
volume assessment, server assessment, topology design, resource
estimation, performance tuning before installing the DataStage 8.7
version and migrating the code from lower version to higher
version.nFolks Data Solutions performed server assessment and
upgraded the code from DataStage 7.0 version to DataStage 8.7
version by converting all the server jobs to parallel jobs whose
plugins were depreciated. The migration was successful with minimal
disruptions to the operations of the client. The implementation
helped the client achieve Business Continuity by staying abreast of
the latest data technologies. Case 4: American Airlines/US Airways
Case 4: Major Airline in the US
Project: Cleanroom Project for Sales Data AnalysisCleanroom project
was a sales merger project between two major US based airlines,
which were in the process of merging their operations, including
sales data. The target for the implementation was to generate
market shares of the two airlines with reference other airlines for
improving sales.To major airlines in the US decided to merge. Prior
to the completion of the merger, the airline companies were not
allowed to run combined sales reports, and the same was outsourced
to ZS Associates where nFolks Data Solutions was asked to help on
the ETL part for loading sales data across different routes,
sources, destinations, legs, seats and others compared to other
competing airlines.nFolks Data Solutions used various data tools to
assimilate data from the two airlines while adhering to legal
requirements for data privacy prior to the merger. Following the
solution provided y nFolks, client was able to seamlessly generate
market share reports for improved business planning for activities
such as route optimization and sales planning. Case 5: Southern
California Edison Case 5: Major Power Utility in the US
Project: Smart Connect Data Warehouse Project for Consumer
Generated DataSmart Connect Data Warehouse project is one of the
high priority projects for client connecting large number of data
points from their customer meters. The Metadata Warehouse
repository is one of the important modules of this project being
implemented to generate different reports related to impact
analysis, data lineage and Business lineage.The client, as part of
Smart Connect project, wanted to implement the Metadata Warehouse
repository across systems to find the impact analysis for any field
changes, find data lineage and business lineage using IBM Business
Glossary, Metadata workbench and other IBM foundation tools. The
challenge was to integrate the solution with the large number of
lot of end-to-end systems including vendor technologies such as SAP
Business Objects reports, Erwin data models, Teradata, Oracle,
DataStage code, stored procedures, extended mappings and
others.Representing IBM at client site, nFolks Data Solutions
implemented the project by importing all the metadata assets using
IMAM for Erwin data models, Teradata, Oracle, DataStage ETL jobs
and others. nFolks also created Business Categories, terms and
other Business assets using Business Glossary, and mapped the IT
assets to Business assets in Business Glossary to generate data
lineage, business lineage & impact analysis using Metadata
Workbench. Worked closely with IBM Israel Labs to address the
product issues, we offered help in including right features which
would provide more granular information for the client.Client was
able to find impact analysis if any IT asset such database column
or ETL jobs, generate end to end lineage from source system to SAP
BO reports, generate business lineage. In addition, both function &
technical teams are able to use Business Glossary. Case 6: VF Corp
Case 6: Major Retail Company in the US
Project: Data Migration from Disparate Systems to SAP ECC 6.5
SystemClient was a holding company for popular retails clothing and
accessories brands in the US, and was merging the brands under a
single entity for better business management and decision making.
The merger process was to be completed in two phases and all the
major brands under the portfolio were being migrated to upgraded
systems.Client wanted to merge all the 8 brands in the portfolio in
two phases by migrating data from different sources such as SAP R/3
4.7, files and DB2 to SAP ECC 6.5 so that these brands are managed
from one SAP ECC system of record.Representing IBM at client site,
nFolks Data Solutions implemented the project by creating the
DataStage jobs with best practices and performance tuning steps to
merge the data for different brands from SAP R/3 4.7 System to SAP
ECC 6.5 system. Following the implementation, client was able to
access all the brands data from one SAP ECC 6.5 system as opposed
to individual systems or different system of records for different
brands Case 7: City of New York HRA Case 7: City of New York
HRA
Project: DataStage Upgrade to DataStage 11.3City of New York HRA
was upgrading their infrastructure from older versions of DataStage
to DataStage 11.3 which was implemented by IBM and as a part of the
project, which was a very short engagement, worked closely with NYC
HRA to Install and configure IBM InfoSphere Information Server
11.3.City of New York HRA was upgrading their infrastructure from
older versions of DataStage to DataStage 11.3 which was implemented
by IBM and as a part of the project, which was a very short
engagement, worked closely with NYC HRA to Install and configure
IBM InfoSphere Information Server 11.3. Case 8: ANZ Bank Case 8:
Major Financial Institution in Australia
Project: Implementation of IBM MDM v11.6Implementation of IBM MDM
v11.6, DSC, RESTful, Bamboo, Maven & Oracle 12c, Kafka for major
financial institution in AustraliaThe implementation consisted of
two parts: The Global Registry (TGR) and Australian Operational
Customer Master (AOCM).The Global Registry (TGR) was a combination
of virtual MDM (Matching Hub - MH) and physical MDM (Operational
Hub - OH). MH provides matching entity link based on outcome of
algorithm defined with probabilistic matching, while OH persists
with the member data for enriching additional data such as
hierarchy and relationships. Data changes for every member are
notified to downstream systems by triggering notification messages.
nFolks designed and developed 'maintain party service', 'publish
derived record', 'data model' and 'algorithm' to accommodate entity
attributes. Configured Bamboo jobs for automating build, deploy and
test processes.Australian Operational Customer Master (AOCM):AOCM
is a master slave database to consolidate customer data from
multiple data sources and to serve the required data to downstream
applications or systems. Java Server Faces web framework-based Data
stewardship application is customized to integrate the new
attributes, and used for searching customers based on user-defined
criteria. AOCM is capable of emitting event notifications for
changes to 'party profile' and 'customer-to-account relationship'
to downstream systems.On behalf of IBM, nFolks designed and
developed standalone Java application - 'Missing Data Remediation'
for remediating missing data in AOCM or in source systems, and also
migrated source control repository to GIT and validated the
generated EAR works. In addition, nFolks also upgraded AOCM from
MDMv10.5 to MDMv11.5, and included Oracle migration from 11g to
12c. By ensuring that AOCM MDM migration did not affect
functionalities, customer data and web services, nFolks ensured
business continuity for the client with minimal disruptions. WORK
WITH US AND GROW YOUR CAREER add_circle_outline DataStage Admin
Salary No Constraint 1 positions Noida add_circle_outline PL/SQL
Developer INR 6.5 lacs 2 positions Hyderabad/Bangalore/Kolkata
add_circle_outline DB2 Admin Salary No Constraint 1 positions Noida
add_circle_outline Qlick View Developer Salary No Constraint 2
positions Pune add_circle_outline Informatica Developer INR 11 Lacs
6 positions Hyderabad add_circle_outline DataStage Developer INR 13
Lacs 6 positions Hyderabad add_circle_outline DB2 Developer INR 15
Lacs 6 positions Hyderabad add_circle_outline Java Developer 1
positions Grand Rapids, MI add_circle_outline SAP MDG Consultant 1
positions Baton Rouge, LA add_circle_outline Data Engineer with
Azure DOE 1 positions Remote/Philadelphia, PA add_circle_outline
Data Engineer (AWS, Snowflake, Batch ETL tool): DOE 1 positions San
Antonio TX email contact@nfolksdata.com phone (425)533-9681 2018
156th Ave NE
Suite 100 Building F
Bellevue, WA 98007
Keywords: nFolks Data Solutions, Seattle , Senior Consultant, Accounting, Auditing , Seattle, Washington
Click
here to apply!
|