SUMMARY:

• A self - motivated and result oriented professional with 12+ yrs of experience in various Industry vertical such as Finance, Manufacturing, and Insurance Brokerage Health Care & Software Development using latest technologies.
• Worked in the areas of BI-DW Solution Architect, ETL Architect, Tech Lead, Data Architecture and Business Intelligence SME and successful with proven records of achievements.
• Significant contribution towards the IT organization’s vision and mission.

CORE COMPETENCIES:

• 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 with Cognos, MSBI, Power BI & Tableau
• Hands on experience with 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.

SOLUTIONS DELIVERED:

Health Care: Patient experience, Patient demographics, Population health, Sentiment Analytics, CAHPS reporting & Analytics

Manufacturing: Supply chain, Order to Cash, Procure to Pay & Sales Order Management.

Finance: GL, AP, AR, expense reporting, Treasury Capital Markets reporting, regulatory reporting.

Insurance/Insurance Brokerage: Producer Profitability, Risk placements

HRIS: Work force performance, various head count reporting including HR regulatory

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: Serena Change Man Dimensions, 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 the data across the 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 with Decision Analysis & Research (DAR, typically Ph.D.’s in data sciences & statistics) to enrich the data model to support various analytical methodologies being developed to meet the needs of health care analytics especially in the areas of patient suffering, patient experience, patient demographics & population health.
• Socialize the data model with 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 the gap with the data model by incorporating various qualitative & quantitative data points to evolve with a prediction model
• Participate in joint architectural/technical sessions with teams representing various functions namely IT, information Management, Product development, Business Analysis & QA
• Worked hands on, on demand with SSIS, Tableau, Information builders & Cognos to meet the time lines and help the team to overcome with hurdles.
• Responsible for assessing the current Sentiment Analysis solution in place and proposed new solution in line to the customer needs which also involved in working with various Natural Language Processing tools(NLP)
• Lead POC’s of Various BI tools in order to land with right match of tool suites inline to the vision of technology road map.
• Work with Data Governance team
• Work on MDM initiatives.
• Work with 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 Confidential ’s business processes
• Understanding the source systems
• Work with business users, functional lead to understand and document the Business requirements.
• Responsible for technical oversight.
• Responsible for Data Architecture.
• Data profiling, identifying the gold elements and creating BI bus Matrix.
• Identifying the 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 the existing FM models for fixes and performance tuning
• Created and published several packages to meet the 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 the data quality issues and delegated to the QA team for execution
• Responsible for the change management(Version Control & production deployment)
• Used different transformation in SSIS like aggregation, conditional split, multicast, raw sampling etc. for meeting the needs of the Data Marts for data feed.
• Designed Type 1 & Type 2 slowly changing dimensions using SCD controls
• Responsible for assigning the work to the 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 the source systems including semi-Structured & Unstructured sources
• Worked with business users, functional lead to understand and document the Business requirements.
• Responsible for technical oversight.
• Responsible for Data Architecture.
• Data profiling, identifying the gold elements and creating BI bus Matrix.
• Identifying the candidates for Master Data Management(MDM)
• Identifying Conformed Dimensions
• Design &Develop BI strategy(Solution delivery using Cognos BI & Power BI )
• Reviewed the existing BI Architecture and proposed the changes to meet the new business requirements and for long-term planning
• Developed dimensional models using Frame work Manager
• Created metadata models using heterogeneous data sources
• Reviewed the existing FM models for fixes and performance tuning
• Created and published several packages to meet the 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 the data quality issues and delegated to the QA team for execution
• Responsible for the change management(Version Control & production deployment)
• Used different transformation in SSIS like aggregation, conditional split, multicast, raw sampling etc. for meeting the needs of the 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 the MDM elements (Product & Markets) in line to the business requirements.
• Generated XML configuration files for the database connections
• Created SSIS log files for trouble shooting in an occurrence of failure
• Responsible for assigning the work to the 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 with Business to resolve design action items. Involved in providing both business and technical expertise in the 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 the data warehouse.
• Created requirement design documents used by the development team in Illinois & Bangalore that addresses the business needs and the proposed reporting solutions.
• Created and worked with complex database schemas and large volumes of data (up to hundreds of millions of rows), leveraged the 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 the 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 the values in the Prompts and also to default the search options for the 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 with BMC Remedy and Service Desk to handle the Service calls, problem records and work orders to resolve the issues for the Business partners.
• Presented demos to the business users to expose the 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,

Lead Developer

Responsibilities:

• Understanding the revenue recognition process in the financial system.
• Identifying the financial data points that capture revenues and costs.
• Identifying the facts required to calculate the 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 the bugs identified during the testing phase.
• Training the 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 the Cognos Report Studio.
• Design of ETL Strategy
• Fixing the bugs identified during the testing phase.
• Post Production Support.
• Training the business users.

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

Confidential

Sr. Developer

Responsibilities:

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

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