Sr Developer & Analyst

I am Available for Corp to Corp projects ANY WHERE in the US WITH your Direct clients ONLY.

Call 630-***-****

******.**.********@*****.***

Objective

To fulfill Business Intelligence needs of Customers as an Independent Contractor that can assist large and small customers with all of their BI needs. Services offered include on-site and off-site on hourly or fixed bid basis

Professional Summary:

Over 12 years of IT experience in Software Application Design, Development, Testing, Documentation and implementation of data warehousing applications and experience in OLAP tools, with a focus on multi-dimensional database star schema modeling.

Established the BI division for the company. Contribution covered all aspects of the BI division from BI product evaluation, and recommendation through installation, administration, maintenance of Cognos, implementation of various BI systems for the company and also hiring, and training of team members.

Worked on Planning, Evolution and selection of BI software with Business Sponsors and Stakeholders to fulfill the growing needs of Strategic, Middle and Operational Management.

Installed, Configured and Administered of Cognos series 8 / 10 Suite.

Installed, Configured and Upgraded Cognos under Windows and Linux environments. Employed Windows Server 2008/R2 and Red Hat Linux ver 5.0

Installed, Administered and Supported Cognos for multiple environments such as Production, Development, QA and Staging environment, and Corporate Training environments.

Architect the BI Cognos environment of the Cognos software versions 8.3, 8.4 and 10.1 in both Linux and Windows environments.

Expertise with Cognos tools such as Cognos 10.1/8.4.1/8.4/8.3 Business Intelligence, ReportNet 1.1 (Framework Manager, Report Studio, Query Studio, Analysis, Event Studio, Data Manager) Cognos Series 7.3 (Impromptu, Power Play; Impromptu Web Reports (IWR), Access Manager, and Server Administration on Enterprise, Upfront and IWR Servers).

Designed and analyzed Business and Technical BI Models

Well-versed in developing reporting applications using Cognos 8 Business Intelligence components like Framework Manager, Report Studio, Query Studio, Analysis Studio, Metrics Studio, event studio, and Cognos Connection.

Deliver advanced / complex reporting solutions such as Dashboards and Standardized Reporting (including the bursting of reports globally) using Cognos. Created complex Dashboards with Area charts, Pie charts, Cross tabs and Multi prompts in Report Studio.

Developed Framework Manager models against relational model and dimensional models – (layers, star schema, cardinality, relationships, query subjects), create and publishing packages.

Extensive experience in developing multidimensional OLAP cubes in power play transformer using various data sources and published in Cognos connection.

Experience in Report Authoring using cascading prompts, conditional formatting, drill-through reports, bursting and HTML Scripting.

Responsible for designing and developing Schemas using Entity Relationships, Data Modeling, Normalization, creating Tables, Views, Indexes, Sequences and coding.

Extensive knowledge in various Internet related platforms with specialization in SQL, PL/SQL, VB, HTML, DHTML, and XML.

Working knowledge on ETL tools like Informatics, SSIS, Data stage in designing data warehousing. Good knowledge in Business insight and Cognos 10. Knowledge in Cognos planning Application (TM1).

Provided Training on BI to new team members and end users alike.

Strong Inter personal communication skills, Ability to provide appropriate attention to details and effective troubleshooting skills, and ability to work in a team.

BI Architect Summary

As a senior member of the BI team at Client Site, I was involved in all aspects of providing BI needs of the company. As a BI manager, my responsibility was to deliver a function BI system to the company and that involved in integration of BI tools, expertise, software, practices, along with project management.

I was responsible for evaluation and selection of BI software and tools for the company. As an architect, I completely designed and built the data warehouse system that fulfilled the needs of the company. The total BI team consisted of 3 members including myself. The company’s needs were fulfilled in little over two years timeframe.

First, at team of subject matter experts were assembled to conduct a company wide preliminary survey of BI needs by all of the major departments of the company. Simultaneously my team and I analyzed the various pieces of information that came into the company and also the elements that left the company. This information was organized and through a series of meetings and negotiations, a final data warehouse model was prepared and approved for implementation.

Our team embarked on the next task of reviewing the processes of each department with a view to streamline the process of data accumulation and redesigning of major IT application systems to better suit the needs of the data warehouse and BI teams. This contributed significantly to the performance of the data warehouse. The major IT applications that were modified were (1) Sales and Marketing, (2) CRM – Customer Relationship Management system, (3) Finance (4) Inventory and Warehouse Management systems, (5) Risk management systems (6) Other names of departments where this occurred.

Thereafter the data modeling was undertaken incorporating all the key elements of the business. Initially our team used Erwin (Entity Relationship Diagramming tool) for establishing the base normalized structure of data and later it was converted to a physical model used in dimensional modeling/OLAP modeling. Once the framework was completely designed, the team moved over to the task of designing meta data for each individual department’s needs.

The next task our team handled was the design of the meta data model This model was designed in consultation, negotiation and the requirements as dictated by the Business Managers of various departments.

The next task was the transformer modeling which designed the cubes for aggregation of information as desired /required by the business units.

Our team heavily relied on Cognos ETL process using Cognos Data Manager. Our Data warehouse captured data from (flat files, excel work sheets, I-Series – DB2, and Ms-Access DB, Oracle DB, Sql-Server 2008)

Finally, the data warehouse was designed and built to provide a single unified repository of data for the needs of Sales and Marketing and Distribution Units of the company. Our team relied heavily on Cognos ETL process using Cognos data manager.

Upon finalizing the design of the data warehouse, our team developed multiple data marts to cover the needs of each of the company’s departments, namely Corporate Finance and HR,, Sales and Marketing, DME – Durable Medical Equipment, and Individual business units distributed across the country.

My ETL teams efforts covered the extraction of data from multiple sources, cleansed and validated and applied the transformation rules and finally publish to the data warehouse storage systems. I also designed and built the processes and scripts to handle the procedures of ETL. Our team used DB2 9.5 for the Data Store.

Towards the operations efforts, our team created several processes to completely processes the ETL and generation of the cubes is totally automated. Also designed the handling of error and failures mechanisms and processes.

On performance aspect our data warehouse model is designed in a fashion to keep data load time low. multi partitioning, aggregation of information, multi file cubes, materialized query and indexing.

Our data warehouse captured data from number of sources, hat grew from nothing to over 4.5 Terra bytes the period of three years. At this time our data warehouse size is and growing 4 % every quarter.

Contact this candidate