SUMMARY

• A self - motivated and result oriented professional wif 12+ yrs of experience in various Industry vertical such as Finance, Manufacturing, and Insurance Brokerage Health Care & Software Development using latest technologies.
• Worked in teh areas of BI-DW Solution Architect, ETL Architect, Tech Lead, Data Architecture and Business Intelligence SME and successful wif proven records of achievements.
• Significant contribution towards teh IT organization’s vision and mission.
• End to End BI-DW Solution Architecture & Delivery
• Data Architecture
• MDM
• Onsite-Off shore mode of execution
• CAHPS(Consumer Assessment of Health Care Providers) reporting
• HIPAA(Health Information portability & Accountability Act)
• Integrated Analytics for various verticals.
• Hands on experience wif Cognos, MSBI, Power BI & Tableau
• Hands on experience wif ETL tools like SSIS, Data Manager
• Architectural experience of various ETL & BI tools
• Architectural experience of various no SQL databases.
• Post Production support & stabilization.
• Leading onsite & off shore teams.
• Exposure to Big Data Stack.

TECHNICAL SKILLS

DWBI Tools: Cognos 10.x, 8.x, Series 7 BI - Report Studio, Analysis Studio, Business Insight, Business Insight Advanced, Event Studio, Query Studio, Framework Manager, Report Net, Power play Transformer, Access Manager, Metrics Studio, Impromptu, Cognos Workspace Advanced, Motio CM, MSBI, Power BI, Tableau, Information Builders

Database: Oracle, SQL, PL/SQL, RDBMS, Toad/Oracle SQL Developer, T-SQL, DB2, Postgre, Neo4j

Data Modelling: ER Studio, Erwin

Operation Systems: Linux, Windows 95/98/2000/XP/Vista/2003/Windows 7

Languages: C, C++, Java, JavaScript, HTML and XML, Python & R

NLP/Text Analytics: Clarabridge

Project Management: MS Office Excel/Word/PowerPoint/Access/Visio, SharePoint, Clarity

CASE Tools: Confidential, Rational Rose, Clear Case

Quality Standards: CMMi, ITIL

Methodologies: Agile & Water fall

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Solutions Architect - Information Management

Responsibilities:

• Responsible for working on Solutions & technology aspect of Information Management(BI&DWH)
• Responsible for assessing teh data across teh board(various external & internal source system) and provide insights on data, define and implement data models for various subject areas like patient experience, engagement, Clinical Quality, Normgens/Bench marks & health care analytics
• Responsible for building EDW foundation which includes defining & building data architecture (dimensional model), building Prod, Dev. & QA environments to support various projects across Patient experience, Engagement, Clinical Quality & Health care analytics.
• Responsible for ETL architecture
• Work wif Decision Analysis & Research (DAR, typically Ph.D.’s in data sciences & statistics) to enrich teh data model to support various analytical methodologies being developed to meet teh needs of health care analytics especially in teh areas of patient suffering, patient experience, patient demographics & population health.
• Socialize teh data model wif various business users, Institute of Innovation for patient experience and top 10 external clients using various BI tools (via Tableau, Power BI )
• Responsible for consolidating various BI tools into a single solution
• Responsible to develop various regression models to support integrated analytics and bridge teh gap wif teh data model by incorporating various qualitative & quantitative data points to evolve wif a prediction model
• Participate in joint architectural/technical sessions wif teams representing various functions namely IT, information Management, Product development, Business Analysis & QA
• Worked hands on, on demand wif SSIS, Tableau, Information builders & Cognos to meet teh time lines and halp teh team to overcome wif hurdles.
• Responsible for assessing teh current Sentiment Analysis solution in place and proposed new solution in line to teh customer needs which also involved in working wif various Natural Language Processing tools(NLP)
• Lead POC’s of Various BI tools in order to land wif right match of tool suites inline to teh vision of technology road map.
• Work wif Data Governance team
• Work on MDM initiatives.
• Work wif Institute of Innovation to equip EDW data models & data to support various research initiates that focus on reducing patient suffering.

Environment: Windows 2008, windows 2012, Linux, SQL server 2012, SQL Server 2014, DB2, MSBI, Power BI, Information Builders, Cognos 10.X, Tableau 9.X, SPSS, SAS, SSAS, SFDC, Billian’s, NDNQI, Clara bridge, ER Studio,Neo4j

Confidential

BI Solution Architect

Responsibilities:

• Understanding Lafarge’s business processes
• Understanding teh source systems
• Work wif business users, functional lead to understand and document teh Business requirements.
• Responsible for technical oversight.
• Responsible for Data Architecture.
• Data profiling, identifying teh glod elements and creating BI bus Matrix.
• Identifying teh candidates for Master Data Management(MDM)
• Identifying Conformed Dimensions
• Design & Develop BI strategy (Solution delivery using Cognos BI )
• Developed dimensional models using Frame work Manager
• Created metadata models using heterogeneous data sources
• Reviewed teh existing FM models for fixes and performance tuning
• Created and published several packages to meet teh BI needs various user groups
• Planned and Created dashboards/Advanced Workspaces and professional reports in Report Studio and ad hoc reports in Query Studio Generating various List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Distributed Reports through Bursting, E-mail and uploading to folders.
• Designed complex testing framework to address teh data quality issues and delegated to teh QA team for execution
• Responsible for teh change management(Version Control & production deployment)
• Used different transformation in SSIS like aggregation, conditional split, multicast, raw sampling etc. for meeting teh needs of teh Data Marts for data feed.
• Designed Type 1 & Type 2 slowly changing dimensions using SCD controls
• Responsible for assigning teh work to teh teams viz BI, ETL & QA at different geographical locations
• Responsible for Phase wise rollout across various geographic locations.
• Responsible for post-production/go-live support
• Responsible for End User Training.

Environment: Windows 2003 server, SSIS (SQL Server Integration Services 2008/2012), Cognos Framework Manager, Report Studio, Oracle R12, SQL Server 2008/2012, DQM, Advanced WorkSpace, Active Reports, ER studio

Confidential, Chicago

Solution Architect

Responsibilities:

• Understanding AJG’s business processes
• Understanding teh source systems including semi-Structured & Unstructured sources
• Worked wif business users, functional lead to understand and document teh Business requirements.
• Responsible for technical oversight.
• Responsible for Data Architecture.
• Data profiling, identifying teh glod elements and creating BI bus Matrix.
• Identifying teh candidates for Master Data Management(MDM)
• Identifying Conformed Dimensions
• Design &Develop BI strategy(Solution delivery using Cognos BI & Power BI )
• Reviewed teh existing BI Architecture and proposed teh changes to meet teh new business requirements and for long-term planning
• Developed dimensional models using Frame work Manager
• Created metadata models using heterogeneous data sources
• Reviewed teh existing FM models for fixes and performance tuning
• Created and published several packages to meet teh BI needs various user groups
• Planned and Created dashboards and professional reports in Report Studio and ad hoc reports in Query Studio Generating various List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Distributed Reports through Bursting, E-mail and uploading to folders.
• Designed complex testing framework to address teh data quality issues and delegated to teh QA team for execution
• Responsible for teh change management(Version Control & production deployment)
• Used different transformation in SSIS like aggregation, conditional split, multicast, raw sampling etc. for meeting teh needs of teh Data Marts for data feed.
• Designed & developed Type 1 & Type 2 slowly changing dimensions using SCD controls
• Designed & Created Tables, Views and stored Procedures using T-SQL
• Designed & developed SQL Server job Script in order to execute SSIS packages at regular intervals
• Integrated D&B(Dun & Bradstreet) data for better understanding of customers
• Designed separate SSIS flows for teh MDM elements (Product & Markets) in line to teh business requirements.
• Generated XML configuration files for teh database connections
• Created SSIS log files for trouble shooting in an occurrence of failure
• Responsible for assigning teh work to teh teams viz BI, ETL & QA at different geographical locations
• Responsible for Phase wise rollout across various geographic locations.
• Responsible for post-production/go-live support
• Responsible for End User Training.

Environment: windows 2003 server, SSIS (SQL Server Integration Services 2008/2012), Cognos Framework Manager, Report Studio, TM1 & CAFÉ, Oracle R12, SQL Server 2008/2012, WorkSpace, SSRS, PowerPivot & PowerView, ER Studio

Confidential, Chicago

Cognos BI Lead

Responsibilities:

• Served as a liaison between Business & BICC team
• Effectively communicated wif Business to resolve design action items. Involved in providing both business and technical expertise in teh requirements gathering, report design, report development by performing analysis of an underlying data source/schema, and support of all client/server layers and components of teh data warehouse.
• Created requirement design documents used by teh development team in Illinois & Bangalore that addresses teh business needs and teh proposed reporting solutions.
• Created and worked wif complex database schemas and large volumes of data (up to hundreds of millions of rows), leveraged teh data to create solutions that present data through Cognos BI Dashboards and KPI's.
• Migrated Objects (reports, Framework Packages) from Cognos 8.4 to Cognos 10.1 environments.
• Validated teh migrated metadata models and reports in Cognos 10.1 environment.
• Designed Cognos reports using MDX and Analysis Services as a data source, Passing Parameters (MDX and regular) to drill down reports, etc.
• Supplemented regular prompts, cascading prompts, filters, Conditional style, static headers, Drill Through, sub queries to add interactivity for users in Report Studio
• Created HTML Scripts to default teh values in teh Prompts and also to default teh search options for teh prompts in Prompt page.
• Scheduled and Distributed Reports through Schedule Management and Bursting in Cognos Connection.
• Performed post-development peer review & coordinated migration/deployment of packages, reports and cube between environments.
• Assisted other developers in design and implementation of high availability/high performance SSAS solutions ensuring best practices are followed.
• Articulated and implemented OLAP solutions that drive strong return on investment and provide robust high availability and performance.
• Worked wif BMC Remedy and Service Desk to handle teh Service calls, problem records and work orders to resolve teh issues for teh Business partners.
• Presented demos to teh business users to expose teh proficiency of upgraded versions of Cognos tools.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.
• Good understanding of systems engineering (to ensure high performance BI architecture using CPU, memory, storage, caching).
• Instrumental in orchestration of Financial close(Monthly, Quarterly, Half Year & Year End) w.r.t BI
• Implemented Data level security and Audit Framework adhering to SOX (Sarbanes-Oxley Act) compliance.
• Cognos Portal Administration & Maintenance.
• Involved in design & development of Board Report Cube.
• Involved in design & development of GL Analysis Cube using TM1 for management reporting
• Building validation procedures for full build, monthly & Year End Close

Environment: J.D. Edwards, Concur, Cognos 10.1/8.4/8.3 (Cognos Connection, Framework Manager, Report Studio, Analysis Studio, CAFÉ, Query Studio),SSIS, SSAS, SSRS, Power play Transformer, Data Manager 13.1,SQL Server 2005/2008, MS Visio, TM1

Confidential, UK

Lead Developer

Responsibilities:

• Understanding teh revenue recognition process in teh financial system.
• Identifying teh financial data points that capture revenues and costs.
• Identifying teh facts required to calculate teh product profitability.
• Identifying conformed dimensions
• Design & Development of Cognos Framework Meta Data Models
• Development of reports using Cognos report studio
• Arriving ETL Design Strategy
• Fixing teh bugs identified during teh testing phase.
• Training teh business Users.

Environment: windows 2000 server, SSIS (SQL Server Integration Services 2008), Cognos Framework Manager, Report Studio & CAFÉ

Confidential

Lead Developer

Responsibilities:

• Requirements Gathering
• Design & Development of OLAP Cube using Power Play Transformer
• Design & Development of Framework Meta Data Models
• Developing Reports Using teh Cognos Report Studio.
• Design of ETL Strategy
• Fixing teh bugs identified during teh testing phase.
• Post Production Support.
• Training teh business users.

Environment: windows 2000 server, SSIS (SQL Server Integration Services 2008), Cognos Framework Manager & Report Studio, Power Play Transformer

Confidential, UK

Sr. Developer

Responsibilities:

• Understanding teh financial structure of teh business in concurrence wif teh domain consultant
• Development of Meta Data Packages using teh Cognos frame work manager and deploying teh same on to teh Cognos portal
• Development of Reports Using teh Cognos Report Studio.
• Tailoring teh design
• Fix teh bugs identified during testing
• Involved in post-production support till teh system got stabilized

Environment: Windows 2000 server, SSIS (SQL Server Integration Services 2005), Cognos Framework Manager, & Report Studio.

Confidential, UK

Responsibilities:

• Understanding teh requirements
• Developing SQL Scripts.
• Development of teh reports using Actuate
• Involved in post-production support.

Environment: windows 2000 server, SQL Server 2005, Actuate. Clarity

Confidential, Praxair, USA

Developer

Responsibilities:

• Development of teh Data Model
• Fix teh issues identified during teh testing phase.
• Involved in validating teh change request raised by teh project stake holder along wif teh CCB
• Base lining on achieving a milestone as defined in teh PMP
• Develop SQL Scripts & stored procedures.

Environment: XP, SQL Server 2005, C#.net

Confidential

Developer

Responsibilities:

• Implementing start schema for reporting data Mart using SSIS and generating teh reports
• Creating and administering teh process life cycles for change and defect tracking.
• Attribute creation wif different valid sets and rules according to teh life cycle.
• CM (Configuration Management) Rules authorization for Items and Change documents.
• Creating individual workspaces
• Defining access levels for teh shared data
• Configuring Multi-site for Parallel Development wif Branching and Merging facility.
• Creation of Baseline and Release templates.
• Providing customized mail facility wifin Dimensions for intimating users wif their pending jobs.
• Troubleshooting Dimensions.
• Conducting Training on demand.
• Coordinating wif Software Configuration Control Board
• Coordinating wif Software Engineering Process Group in identifying best practices of SCM
• Integrating Dimensions wif other CASE tools in order to achieve Application Life Cycle Management (ALM) Framework.

Environment: windows 2000 server, SQL Server 2005, Oracle 9i, Serena Change Dimensions

Confidential

Developer

Responsibilities:

• Involved in collecting teh requirements and also developed teh same using Perl and Visual basic along wif CAL.
• I has also tested and implemented this application, teh same was supplied as a sample snippet to teh customers so that they can further enhance in order to meet their requirements.

Environment: Perl, V.B. 6.0, CAL (Clear Case Automation Library)