SUMMARY:

• Fourteen years of experience in Information Management with focus on DW/BI. Have worked in Banking, FMCG, Healthcare and Consumer Durable industry domains.
• Deep experience in full development life cycle e.g. Business Analysis, Requirement Gathering and Analysis, Solution Designing and Technical Designing, Development, QA testing and Project management.
• During 14 years of tenure, undertook various roles and responsibilities at different point of time like Data Analyst, Data modeler, Information Architect, Developer, Business Analyst and Project manager.
• Over 11 years of experience in Information delivery and Architecture with ( ETL ), Analytics and Business Intelligence from disparate data sources like Multiple Relational Databases (Oracle and SQL Server) and hybrid ( HDFS ).
• Experience in Design and Developments of Conceptual, Logical and Physical Data models.Creating data standards, processes and technology management for data, master data, and metadata; and, data security e.g. Data masking etc.
• Demonstrated extensive ability to develop a business vision and lead implementation efforts with complex project management.
• Recommended and participated in activites related to design, Development and maintenance of Enterprise Architecture,design and implementation of IT service management standards, tools and methodologies.
• Managed and delivered components of client engagements that identify, design, and implement technology and creative business solutions for large companies. Responsibilities include, identification of business requirements, process design (including scenario design, flow mapping), prototyping, testing, training, defining support procedures.
• Managed all aspects of Project Management activities Like: initiating, planning, execution and closure. actively participated in defining scope, tasks, timelines and objectives.
• Lead team of 10 - 18 individuals across geographies to deliver projects. Prioritized and assigned day to day tasks, gathering status updates, peer reviews, technical & functional assistance in resolving the assigned tasks and achieving the deliverables meeting the SLA/KPIs. Additionaly, Anticipate and identify risks, and esclate issues as appropriate.
• Architected, designed, developed, and implement intelligent platforms using qualitative and quantitative methods, advanced and predictive analytics. Experienced in building and validating risk management models; Have succssfully defined the Predictive modeling process, articulated the underlying business assumptions, and documented the model development process
• Involved in Business Development and Account management, by maintaining contact with top decision makers at key clients; Organized and lead pursuit teams ; Participated and developed many proposals, RFP and pricing strategies as well as sales presentations to potential clients.
• Engaged in many organization development activities like talent management, recruitment, learning & development, counseling and coaching . Created Automation Tools for developement and project management in Confidential .Drove operational effeciencies on projects and internal initiatives and has consistently drove projects to sucessful completion and ensure work is of high quality. Published project summary reports, news snippets and articles in Confidential in-house Technical magazine.

TECHNICAL SKILLS:

Tools: Hue, version control(SVN, GIT), Datastage, service management/ticketing(Remedy), Matlab, Cognos, RevR, Python3.4, ALM QC, Pig, Rally, Toad, HP-Q life cycle, Informatica Power center, Sybase power designer, Perl, Shell, MS Tools, MS project server, Spark, Visio, Erwin, SAS/BASE/STAT/GRAPH/ACCESS/CONNECT/ODS SAS/MACROS/DI/EG/EG/WRS/ECM Information Map Studio/ Enterprise Miner/ Forecasting Studio

Languages: SAS 9.4, SQL, HTML, XML, C++, STRATA, Python, R, C/C++, Java, Scala, etc.

Databases: Teradata, Oracle and SQL Server, Hadoop/Hive/Hbase

Operating Systems: Windows, DOS, UNIX/Linux.

Secondary Skills (Trained): Trained in Cognos, Crystal Reports, Oracle administration and Datastage tools.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• create data mappings, support to development, testing and Business functional teams.
• Governing implementation projects by scoring their conformance to standards and roadmaps.
• Confirms and Identifies Non-Functional Requirements.
• Support Data Mapping Phases with proper technical analysis.
• Redesigned and developed existing/new Enterprise Analytics reports and integrate with Hadoop using SAS and tableau.
• Identified business opportunities to increase usability and profitability.
• Automation of Architect support as SAS SME of various projects and integration/design of QA applications for Automation .
• Design and development of Data Mart ( Confidential ) Solution from scratch.
• Design included ETL system and Automated Reporting applications for Auto and home module and Ad-hoc Analysis.
• Project also included supporting of existing applications and Data Analysis.
• Designed automated processes using Python, Perl, Shell, and batch scripting.
• Project was about architecting and developing Enterprise Case Management solution as part of SAS Customer intelligence solution for application from scratch.
• Designed and architected Data mart, ETL system and Reporting applications.
• Created Risk Rating Engine, Letter Generation and email Functionalities of SAS ECM using SAS base/Macros/Stored processes, user Interface and sasserverpages for Client Risk Analysts.
• Project was to architect and create Demand Forecasting Application and Data mart .
• Project was to create Predictive models and Claims Reporting application using SAS. Providing solution and support on SAS Admin Activities and Data warehousing issues .
• Designed and created multiple BI Reports e.g. Balanced sheet in SAS portal, Cubes using MDX queries, Semantic layer from Information Map Studio. Designed reports and cubes

Confidential, Glen Allen

Responsibilities:

• Project was to Provide the 24x7 support on SAS servers for daily/monthly and weekly data refresh operations.
• Worked very closely with Developers, Business users for any data, access and infrastructure related issues.

Confidential, New Jersey

Responsibilities:

• Excelled in multiple projects related to Data Analysis, Data modeling, Data base Design and Data Architecture. Working closely development and admin team for Architecture designs and admin issues.
• Created stored procedures, functions, triggers and database design.
• Developed and Reviewed volume and value of sales targets, measuring promotional effectiveness and to create BI reports for presentation to Senior management.
• To Assist the Product Manager with assessing cross product and operational impacts of proposed development projects.

Confidential

Responsibilities:

• Designed Business intelligence and Customer intelligence solution using SAS macros.
• Managed and analyzed primary and secondary research data.
• Analyzed Marketing/promotional/Advertising data to create predictive model for sales forecast, profitability, effects of new product launch on bottom line.
• Responsible for translating the client’s business requirements into specific systems, applications or process designs for very large complex IT solutions and integrating architecture. Acts as an ultimate authority on the architecture designed to address client business problems. Provides direction for design activities.

Confidential

Responsibilities:

• Worked on multiple projects varied from Analysis of Financial, Marketing, Sales, Production and operational data, Supply chain and commercial function management for availability of material
• Collection management and analysis of data and presentation of results to senior management.
• Subject matter expert on Data mart and BI Reporting.