SANTHOSH KARNEWAR

510-***-****

acf8oh@r.postjobfree.com

www.linkedin.com/in/santhoshkarnewar/

CAREER SUMMARY

• 13+ years of total professional IT experience in years with a thorough understanding of SDLC

methodology.

• 8 + years of Business Intelligence (Business Objects/Crystal Reports and data warehouse)

planning, engineering, and development expertise delivering best in class reporting solutions and

actionable insights for CARGIL, Britesmile, Verizon Wireless, Verizon Data Services & BlueShield of

CA. Architected, designed, built, implemented and managed warehouses with >20TB of data, 3MM

+customers and 2k users.

• Expertise of implementing Business Objects, OBIEE, Informatica & MDM solutions in one or multiple

areas such as Health Care/Sales/Finance/Marketing/HR/Services.

• Recognized for driving the adoption of technologies, standards, and best practices that have increased

visibility of critical data for enhanced decision making

• Defined and outlined the BI Reporting strategic planning including roadmap, context diagrams, and

process maps. Presented findings to the BI Executive Board (company Presidents / Vice Presidents).

• Comprehensive understanding of PM methodologies like PMI PMBOK, SDLC, Waterfall, Agile.

• Solid understanding of Data Warehouse methodology, dimensional modeling including Ralph

Kimball's methodology.

• Capacity to use data to tell a compelling story, has ability to quickly translate requirements to prototype

and get business buy in.

• Proficient in documenting project plans, budget, requirements, timelines and coordination across

various departments and different line of business

• Strong database development and query knowledge including proficiency in SQL coding across

standard relational environment (e.g., Oracle, Teradata, etc.). Expertise in writing and implementation of

the SQL, PL/SQL Packages, SSIS, SSRS reporting, Triggers, Stored Procedures, Functions, views,

Materialized Views and indexes at Database level.

• Creative problem solver/engineer that excels in conceptualizing, analysis, and rapid development of

Pre sales, Proof of Concepts, and prototyping of industry and company specific data/information

solutions.

• Working / reporting directly to / with the CIO, CFO, and Director of Operations, initiated,

conceptualized, personally developed, and customized an EIS / Dashboard program / approach for

President level reporting.

P a g e 1

• Expertise in implementation, migration, security management and administrating Business Objects

4.0/BO XI R 3.1/R2.

• Broad industry familiarity with implementation experience of popular BI packages such as Business

Objects, SAS, Crystal Reports, OBIEE, SAP HANA or other BI tools.

• Self motivated with strong leadership and presence. Possess critical thinking, problem solving,

interpersonal and collaborative skills, and decision making skills.

• Experienced and strong understanding of process in one or more business areas such as Finance,

Sales, HR & Marketing.

• In depth expertise in RDBMS tools ORACLE 10g/9.2/8.x/7.x, SQL Server 2000/2005 and application

development tools VB.net, Visual Basic, HTML, etc.

EDUCATION / CERTIFICATIONS

• Masters in Computer Science

• Microsoft® Certified Professional in Vb.Net

• Certified Project Manager by PMI

TECHNICAL SKILLS

OLAP Business Objects 4.0/ XI R 3.1/XI R2/6.5.1/6.1/5x

Reporting Tools Crystal Reports 2008/XI R2/10/9.0/8.5, Xcelsious Engage

2008, Tableau 8.1 (32 bit)

ETL Informatica PC 9.5.1, MS DTS, MDM

Data Modeling Tools ER Win

Operating Systems Windows 2003/2000/XP/NT/98/95, UNIX (Sun Solaris 10/9)

RDBMS/Databases Oracle 11g/10g, SQL Server 2008/2005/2000, MS Access

Appliances SAP HANA, Teradata

GUI Tools Visual Basic 6.0/5.0, Visual Studio .Net 2008 (Vb.Net,ASP.Net),

TOAD, SQL Tool

Version Control Tools Visual Source Safe, PVCS, Subversion, BO LCM, Tortoise

Applications/Web Servers IIS 6/5, Tomcat, Web Logic, FACETS 4.8.1\4.6.1,

Tidal Batch Scheduler

Web Technologies HTML, Java Script, ASP.Net

Packages /PM Tools MS Office 2007/2000/97 (MS Excel, MS Word),

Visio, Microsoft Project,

Defect Tracking MERANT, JIRA

PROFESSIONAL EXPERIENCE

Client: Pharmacyclics

Title: BI/DW consultant

April 2014 Till date

P a g e 2

As BI Consultant at Pharmacyclics, my responsibilities are to support EDW (COMMERCIALS) & Finance.

Support data validation & DW design.

• Designed & Developed Match ( Exact & Fuzzy) & Trust rules for mastering customer data based

First Name, Last Name, Middle Name, Zip Code & NPI number in MDM

• Developed solution for JBI & PCYC prescriber call data exchange integration

• Integrated EDW with Veeva(Salesforce.com) data mart for call, account & customer data

• Integrated EDW (SPP & SD) inventory & Dispense data with third party sales data providers

( Pharmacy companies, associated vendors) where data will be transmitted via flat files and EDI

• Designed & planned Data load & reload strategies.

• Implemented Audit, Balance & Control frame work (ABC).

• Designed & Reviewed ETL work flow designs, mentored vendor and developers in Data mart

development.

• Provided guide lines & best practices for data accuracy & completeness, articulated data

validation check points.

• Created Source to target mapping documents, managed Informatica workflows, mappings &

maplets and batch jobs for data loads.

• Provided solution for data integration between Microsoft Dynamics(SQL Server) & EDW

( ORACLE)

• Created materialized views for Sales data & Account Order History Data in ORACLE

• Developed YTD, 13 Weeks rolling executive dash boards, and Investor relations dash boards

using Tableau & BO 4.1

• Experienced with Power Center and B2B components.

• Posses experience with HIPAA EDI X12. Worked 834 Claims payment processing

Tools: Informatica 9.5.1(Power Center /Work Flow Manager) EDI X 12, BO 4.1, ORACLE 11g, MDM

9.5,VEEVA, BO 4.1, Tableaue 8.1

Client: BlueShield Of California – San Francisco, CA

Title: SR Business Intelligence Lead

Feb 2010 to April 2014

As Business Intelligence Lead at BlueShield of CA, my responsibilities are but not limited to, support

providing solutions for corporate initiative data analysis projects such as developing executive

dashboards, developing reports, data analysis. Supported report remediation project by providing detailed

corporation wise reports Meta data & impacted reports details, which intern helped company to reduce

the remediation budget from $4 Mn to $938K.Developed more than 121 Business Objects reports, led

offshore team of 10 during FACETS Application implementation. Supported FACETS upgrade program to

validate pre & post upgrade impacts by providing impact analysis, provided remediation solutions for

impacted reports and programs.

Involved in Data warehouse & EDW design. As day to day operations, supported extensive

data analysis for Actuarial, Medical Informatics, Finance & other statistical departments.

Responsibilities:

P a g e 3

• Worked with the business analyst team to interview the business users and capture simple,

moderate and complex business requirements.

• Collaborated with business technicians to research existing business and system processes.

• Responsible for analyzing business requirements and developing queries and reports using BO

full client and info view to provide Web enabled data analysis solutions to business clients.

• Involved in building and Aligning Business Intelligence Organizations, Models, Tools, and

Standards with Evolving Business Goals.

• Leading the Adoption of Data Governance / Quality, Solutions Design & Delivery, and Self

Service Reporting Frameworks.

• Lead team of 9 in analyzing, designing, developing, and delivering business intelligence solutions

to business units.

• Worked with Vendors, negotiating contracts, acquiring resources, developing & managing them.

Worked on On Site, Offshore model.

• Handled projects with more than $500K in budget.

• Set up the foundation and automation to enable business units to produce 30+ reports and

dashboards.

• Developed POC project in SAP HANA Platform, Tablue, Created Info spaces, and Analytical,

attribute& calculation views.

• Evaluated various BI tools such as Tableau, Qlikview & SAP VI.

• Hands on experience in On Site – OFF Shore development model. Handled projects as On Site

lead.

• Anticipated and played collaborative roles in proposing technology capabilities in support of

business strategic roadmaps and creating supporting technology strategies.

• Implement security policies with Object Centric access restriction.

• Developed 121 complex and medium reports (such as Commissions, Account receivable, Clear

Check, Provider & Member ship reports) against FACETS 4.6.1 /4.8.1data source.

• Installed & Migrated BO XI R 3.1 system to BO 4.0 SP 02 using Upgrade Management tool.

Implemented linear migration mechanism.

• Used stand alone BIAR file method instead of Live Live migration to have minimum down time.

Converted Desktop intelligence reports to Webi, converted universes with UNV to UNX to avoid

pain in future.

• Migrated total of 841 BO XI R 3.1 Users to BI 4.0.

• Communicated data nuances and insights to all levels of the company in a clear and concise

manner, provided leadership in defining business critical metrics and analyses that drives the

business forward.

• Developed analytic standards for measuring performance within the business unit, leading teams

to consensus around analytic approaches and development of reporting priorities across key

initiatives. Ensured a consistent and efficient set of information and metrics permeates all levels of

the supported business unit across the enterprise

• Instilled best practices using Business Intelligence tools and philosophies from front line

employee to executive leadership. Ensured that the Business Intelligence architecture evolves for

continued fact based decision making and sophisticated ad hoc capabilities.

P a g e 4

Environment: BI 4.0 SP2/ BOXI R 3.1, Crystal Reports 2008, SAS EG 4.3, SAP HANA,ORACLE 11g,

Windows 2003 Server, FACETS 4.8.1/4.6.1, Teradata 12, Merant, Subversion.

Client: Verizon DATA Services – VSO, Irving, TX

Title: Business Objects Lead

May 2009 to Feb 2010

As Business Objects Administrator & Developer, Support Verizon VSO real estate Business Objects

Reporting system which includes installation, Upgrade, and migration. Verizon Real estate report

enterprise system supports & provides extensive webi, crystal & dash board reports to real estate

analytical team and executive team such as VP, Executive Directors, and Directors. Led team of 4 and

also as Hand on solution provider.

Responsibilities:

• Worked with the business analyst team to interview the business users and capture simple,

moderate and complex business requirements.

• Collaborated with business technicians to research existing business and system processes.

• Responsible for analyzing business requirements and developing queries and reports using BO

full client and info view to provide Web enabled data analysis solutions to business clients.

• Installed & configure BO XI 3.1 Enterprise Premium edition on Windows 2003 server.

• Configured IIS 6 according with BOXI R3.1/XI R2 Application Server in ASP .net Framework.

• Implement security policies with Object Centric access restriction. Implement data segregation

policies.

• Upgrade and migrate BO XI R2 to BO XI R3.1 using Import Wizard. Configure & fine tune Web

Intelligence Server, CMS.

• Set up single sign on authentication (SSO) using LDAP, Windows AD authentication for Business

Objects users.

• Create, Design & maintain Universes. Optimize universes by creating contexts, views, resolving

loops, fan traps and chasm traps. Create derived and aggregate tables, joins and set cardinalities

for various universes.

• Create user groups, server groups, report folders, universe folders, calendars, events and

categories using CMC.

• Created different types of reports like Master/Detail, Cross Tab and Chart Using WEBI XI and

Crystal Reports XI. Used Slice and Dice and Drill down. As a part of report development created

the reports using universes as a main data provider and using the Powerful business objects

functionality's like @ functions, user response and formulae's.

• Used Prompts in reports to create more interactive reports for the Users.

• Used Prompts in the reports as well as the Universe to create more interactive reports for the

users.

• Created complex reports using cascading prompts, decode objects and etc.

• Created Metadata Universe & custom view on CMS Data Base for Audit reports such as Failure,

Daily run Reports and Success Fully run reports.

P a g e 5

• Developed Custom Search engine for reports schedule to destination (email or unmanaged or ftp)

with report name or recipient name using Business Objects SDK. Configured/customized Infoview

for user friendly look.

Environment: Bo XI R3.1/R2, Crystal Reports 2008/XI/10, Web I, WIN 2003, Clear Case

Client: Verizon Wireless Walnut Creek, CA

Business Objects Lead Administrator /Developer

February 2006 – April 2009

Install and administrate Business Objects and Crystal Enterprise. Develop reporting solution to work

effectively against Remedy data source (Oracle db) which includes data warehouse development, Web I /

Crystal Reports.

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members

to analyze business requirements and outline the proposed solution.

• Installation and configuration of XI R2 (CMC, CCM, Info View) using IIS 6 application server on

Windows 2003 platform.

• Design and develop Crystal Reports using the cross tab, sub reports, charts and Top N reports for

highlighting significant data, summary reports with drill down capabilities.

• Design various charts and graphs such as bar chart (side by side, stacked), line graphs, pie charts

etc by using Chart Expert of Crystal Reports.

• Design Crystal Reports using Dynamic Parameters, LOV and Business Views.

• Expertise in designing complex Crystal Reports using repository functions, formulae and arrays.

• Designed reports to support multi export formats such as exporting to pdf, Excel and Word without

losing format of fields.

• Develop standalone dash boards using Xcelsius exporting to .pdf via Live Office and QAWS using

panel containers, accordion menu and tab set components.

• Created what if reports/dash boards using Slider component.

• Created dash boards with dynamic visibility.

• Created management reports, audit summaries and KPI statement reports using Xcelsius.

• Upgrade and migrate BO XI R2 using Import Wizard and also from Crystal Enterprise 10 to BOXI R2.

• Set up single sign on authentication (SSO) using LDAP, Windows AD authentication for Business

Objects users.

• Develop custom search engine with capability to search scheduled reports by report name or recipient

name using Business Objects SDK. Develop custom Info view using BOXI R2 .Net SDK. Develop multi

reporting bursting manager using .Net SDK.

• Implementation of BO XI R2 in cluster environment. Implementation of disaster recovery process.

• Configured BOXI R2 and Crystal Reports for Java bean based data sources or Java Bean based

reports. Wrote scripts to debug or trouble shoot RMI connection issues /Java Bean report issues.

• Create user groups, server groups, report folders, universe folders, calendars, events and categories

using CMC.

P a g e 6

• Implement and practice data security and Business Objects security disciplines.

• Developed complex ETL (Extract/Transform/Load) procedures using PL/SQL packages, stored

procedures, views and cursors.

• Design and develop auditor views from CMS audit tables to track failed and daily ran reports.

Environment: Bo XI R3.1/R2, Crystal Reports 2008/XI/10, Web I, Xcelsius Engage 2008, Windows

2003,Business Objects 6.5, Oracle 10g/9i, Db2, Remedy 6.0, SQL Tool 4.0, ASP, IIS 6, Visual Source

Safe, Java Script, VERITAS Storage Replicator, BO LCM, Sub Version (Tortoise SVN), JDK 1.5(J2EE),

HTML, CSP, VM Ware ESX, Live Office, MS Excel 2003

Client: Britesmile, Inc Walnut Creek, CA

BO XI / Crystal Enterprise Administrator /Report Developer

April 2005 – February 2006

Project involves implementation of Crystal Enterprise, which includes installation, configuration,

administration and report development against Mas 90/Mas 200 financial systems, campaign

management systems. Responsibilities are not limited to above but also include maintaining Mas 90 /

Mas 200, design and develop DTS on SQL Server 2005.

Responsibilities:

• Worked with the business analyst team to interview the business users and capture simple, moderate

and complex business requirements.

• Installation and administration of BO XI R2. Upgrade and migrate BO 6.5 to BO XI R2. Upgrade and

migrate Crystal Enterprise 10 to BO XI R2.

• Design and develop complex financial and marketing reports using cross tab, charts, sub reports,

custom repository functions and complex formulae using Crystal Reports 10

• A responsibility also includes integration of data quality tools Melissa Data with Crystal Reports

development and maintaining financial systems Mas 90/ Mas 200.

• Used stored procedures and views for accurate data representation in reports. Designed Ad Hoc and

Drill Down Crystal Reports as per requirement in design.

• Create custom Crystal Reports repository common functions. Design reports using Business Views

and LOV .

• Develop custom eportfolio using Crystal Enterprise / BO XI R2 SDK in .net frame work.

• Develop custom scheduler to burst published report using BO XI R2/ Crystal Enterprise SDK.

• Develop custom audit page to tack user access, failure and daily ran reports using SDK.

• Created various types of reports of type standard, cross tab, drill down, sub reports, form type, letter

and label type etc using Crystal Reports.

• Designed and analyzed reports using Crystal Report reporting tool.

• Regularly synchronized the QA and development environments with production reports.

• Deployment of reports in BO Enterprise Server and provide solutions to distribute reports to corporate

executives and other key members of decision making teams via email, ftp and un managed disk

using CMC.

P a g e 7

• Extensively used CCM and CMC for Business Objects Server management. Expanded BO

environment by adding new CMS as cluster members to existing CMS.

• Provided security in the universe by updating the SQL to recognize and authenticate the BO user while

querying.

• Implement security features of Business Objects like objects level, folder level and report level to make

the data secure. Provide the security access management by creating users/groups.

• Analyzed existing database and created universe. Detected cardinalities and checked for integrity of

universes. Optimized universes by creating context, views and resolving loops.

• Implement Active Active CMS DB replication and file repository replication using VERITAS Storage

Replicator for file system back up.

• Develop DTS package, stored procedure and cursors using T SQL in SQL Server 2000.

Environment: BO XI R2/ Crystal Enterprise 10/9.0, Windows 2003/ XP, IIS 6/5, SQL Server 2000, Mas

200/90

Client: Cargill INC Minneapolis, MN

Crystal Enterprise Administrator/ Data Intelligence Support

December 2004 – April 2005

Conversion Project (My Eureka Reports to Crystal Reports 10) It's a conversion project, migrating

MyEureka Reports to Crystal Reports10.

Responsibilities:

• Involved in migration of MyEureka Reports to Crystal Reports 10.

• Headed and helped the decision making team to finalize the Crystal products after analyzing their

MyEureka reports.

• Played key role in developing, implementing and demonstrating the successful pilot project using

Crystal.

• Designed and analyzed reports using Crystal Reports reporting tool.

• Designed custom reports, setting up parameters, sub reports, and drilldown reports, using Crystal

Reports.

• Installation and administration of Crystal Enterprise.

• Set up NT authentication as well as Enterprise authentication for all users.

• Installed and configured Crystal Enterprise server in cluster environment.

• Designed and implemented ad hoc reports, extracting data from an Oracle database.

• Implemented Crystal Enterprise development environment by installing Crystal Enterprise on IIS 5.0

web server.

• Performed technical analysis and design of platform and user interface.

• Deployed and tested the Crystal Reports on Crystal Enterprise 10 environment.

• Created several complex cross tab reports using Crystal Reports.

• Designed financial reports using Crystal Reports with Oracle 9.i.

• Designed Crystal Reports using formatting function in files.

P a g e 8

• Installed report application server and upgraded RAS reporting environment to Crystal Enterprise.

• Designed and modified the database tables and wrote complex SQL queries, stored procedures,

triggers and data modeling in Oracle 9.i and Teradata.

• Involved in integration with Visual Basic 6.

Environment: Win 2000, Windows XP, Crystal Reports 10.0; Crystal Enterprise 10.0, Crystal RAS,

Crystal Reports Designer, Oracle 9i, Oracle 9i, My Eureka Reports and Vb 6

Client: SAPHRAN INC Ann Arbor, MI

T SQL Programmer/Application Developer /Report Developer

July 2004 – December 2004

The Saphran Part Base Forecast Manager powered by CSM is a unique software solution that enables

automotive suppliers to optimize profitability by improving the process of planning and forecasting through

out the entire life cycle of a supplier's product portfolio.

This allows you to quickly and seamlessly merge external market forecast data with internal part and

vehicle base information into one comprehensive reporting tool and simulator, producing a living and

dynamic forecast that stays viable and current.

• Provides current and accurate reports to make strategic decisions about quoting, cost planning,

outsourcing, capital investments, product mix, profit planning, target customers and target markets.

• Enables account managers to track and report on all revenue and margin assumptions for current and

future programs including $ per vehicle.

• Create multiple "what if" simulations based on cost, price and volume relationships.

• Create trending reports to constantly improve the quality of your forecast assumptions.

• Up to date reports within minutes, especially if linked to an automated costing and quoting system

such as Saphran's Costing and Quoting solution.

• Output data into Excel, Access or other comparable software if desired.

Responsibilities:

• Involved in software requirement analysis and design.

• Designed the schema MS SQL Server 2000.

• Involved in SQL Server administration, database back up, installing and configuring and managing

databases.

• Involved in Forecast Management Engine development, Report / Filter Engine development and GUI

design.

• Designed Crystal Reports using stored procedure and views. Used sub reports and formulae for

accurate data representation in reports. Used Crystal Reports formula editor for writing formulae as

per requirement in design.

• Designed and developed reports using cross tab, mail label and charts.

• Developed and customized the base canned reports like direct, group summary and performance

rating distribution for the compensation planning module.

P a g e 9

• Integrated and published the reports with Crystal Enterprise, RAS and ASP. Net.

• Dynamic, multiple selection and sort based reports are developed by using Crystal Reports 10.

• Produced discrete, multi and range parameter based reports and formula based group reports.

• Integrated and mapped the similar reports with different data sources and databases.

• Depend upon the requirement and functionality sub reports and on demand sub reports were created

for compensation planner application module.

• Wrote data base connection classes, transactions classes for update, delete and insertion.

• Wrote store procedures, triggers and user defined functions.

• Used MS Data Grid control for displaying transaction history of web form. Also used pagination and

grid events. Used ADO.Net for database transactions.

• Used XML adapter to import and export data from XML documents.

• Designed and developed web forms using ASP.Net on VS.Net IDE and used nUnit framework for unit

testing and automated testing using Win Runner as per requirement.

• Used .Net Inter Op features in development of reporting and filter engine.

• Wrote client side functions in JavaScript.

• Developed result set export function to various formats such as Excel, Word, etc.

Environment: VB. Net, Asp. Net, MS SQL Server 2000, XML, Windows 2003 Server, Crystal Reports 10,

Crystal Enterprise 10.0/9.0, IIS 6, Visual Source Safe, Java Script

Client: Engineered Sintered Components Inc, NC

Application Developer / Report Developer

March 2004 – July 2004

eProMM Adv. Server 1.10(Web Enabled) is advance version of eProMM basic system. eProMM

Adv.Server collects real time data of production floor. Stores data for monitoring, management analysis

and reports and alerts the subscribed user about the exceptional variations in production information.

Various servers like data processing server, control server, alerts server, and report server working in

tandem to enhance system performance and capabilities.

Responsibilities:

• Involved in user requirement analysis and system design.

• Designed and developed web forms (for Web Top Application), win forms (Client /Server Data

Processing Module) as per requirement using VB. Net, implemented MS data grid control for

displaying respected data before and after each transaction done in corresponding page and also

provided paging and other data grid events.

• Production and managerial reports were designed and developed using Crystal Reports features like

sub reports, formulae and various report templates.

• Designed graphical reports using Crystal Reports chart feature. Designed customized report

templates.

• Integrated Crystal Reports with VB.Net.

• Developed sob scheduler using VB.Net.

• Used Sax Comm. control to communicate with serial ports via Vb.Net win application using Inter Op

features.

P a g e 10

• Developed GMTS (Global Management Tracking System) to escalate alerts or page messages in

hierarchical manner in department until it receives response.

• Designed integrator module for integration with third party applications like ERP (JD Edwards, Karen

soft), MRP by exporting data in to XML or fat files via .Net and at the same time loading data from

XML and fat files or text files.

• Written common validating functions using JavaScript for client side validations and Vb.net for server

side validations.

• Used nUnit framework for unit testing and automated testing using Win Runner as per requirement.

• Developed data access utility, which connects to SQL Server database, retrieves data into datasets

and also updates database with datasets. Provide transactional support. Wrote stored procedures,

triggers, user defined functions and views.

Environment: VB. Net, Asp. Net, MS SQL Server 2000, Crystal Repots 10/9.0, Java Script, Windows

2003 .Net Server, Win Runner 7.0

eProMM (Electronic Production Monitoring Management System) is a real time production management

system. eProMM is designed for large scale, small and medium scale industries for their production

monitoring. It collects real time information/data of production floor, and stores data for analysis,

monitoring and reports. Data processing module, job scheduling / master data maintenance module and

reports wizard works in cycle to enhance system capabilities and performance. When variation in

production occurs alerts were displayed in graphical way.

Responsibilities:

• Involved in software requirement analysis and design.

• Designed the schema MS SQL Server 2000.

• Designed various reports using Crystal Reports 8.5. Used charts for graphical representation of data.

• Designed Crystal Reports using stored procedure and views. Used sub reports and formulae for

accurate data representation in reports. Used Crystal Reports Formula Editor for writing formulae as

per requirement in design.

• Designed and developed Win forms using Vb.Net on VS.Net IDE, and used nUnit framework for unit

testing and automated testing using Win Runner.

• Used MS Comm. control to communicate with serial port using .Net Inter Op features.

• Developed an interface to integrate with third party applications by extract, transform and loading

concept either from XML or from text files via .Net.

• Stored meta data in SQL Server 2000 using ADO.Net.

• Used MS Data grid and Fly Tree control for displaying of data.

• Wrote data base connection classes, transactions classes for update, delete and insertion.

• Used MS Project and Visio for system design and project planning.

• Created dimensions and facts in physical data model using Erwin tool.

• Used Informatica Designer to create complex mappings using different transformations to move data

to a data warehouse.

P a g e 11

• Developed mappings in Informatica to load the data from various sources into the data warehouse,

using different transformations like Source Qualifier, Look up, Aggregator, Stored Procedure, Update

Strategy, Joiner and Filter.

• Created repository and set up groups and users for different departments; and also managed user

profiles using Informatica Repository Manager.

Environment: VB.Net, MS SQL Server 2000, Crystal Repots 8.5, Informatica Power Center 7, Basic Data

Collector

Contact this candidate