SUMMARY

• Around 9 years of IT experience working with Big - Data, Business Intelligence and ETL solutions.
• Professional experience in designing, developing - load, Transformation, Analytics and Reporting solutions.
• As an application architect collaborated and designed Big-Data solutions in compliance with software systems and applications.
• Experience in Designing, Developing Ad-hoc and detailed Reports, Bursting Reports and Scheduling.
• Proficient in developing reporting solutions in Tableau, QlikView, Crystal Reports, WEBI Rich Client, Live Office and Xcelsius.
• Designed and implemented SDLC model for BI environment.
• Proficient in user communication, training and documentation.

Big-Data & Analytics: Cloudera Hadoop, Apache Spark, Impala, Tableau.

Business Intelligence Tools: Business Objects 3.x, 4.x, CCM, CMS, CMC, Information Design Tool, Business Intelligence Consumer Services (BICS), Universe Designer, Web Intelligence, BI Launchpad, Live Office, Promotion Management, LCM, QaaWS, Live office, Xcelsius, Crystal Reports 2008 2011, Crystal Enterprise, Bex Query Analyzer, SAP Lumira, Tableau, Qlik, Cognos, Esri Maps.

ETL Tools: Informatica, ERWIN.

Data Modeling: Dimensional data modeling, Physical logical data modeling, Visio, Star Schema Modeling, Snowflake Modeling.

Databases: Oracle Exadata, 10g,11g,12g, SQL server, IBM DB2, MS Access, Redshift, Teradata.

Languages: C++, Java (J2EE), SQL, PL SQL

Operating Systems: AWS, Windows Server, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, CO

Sr. Programmer Analyst / Tech Lead

Responsibilities:

• Design, Develop and manage complex business logic, software systems and application functionality related to Business intelligence and analytics.
• Work closely with tech specialists, system leaders and business leaders in architecting technical solutions, and resolve application issues.
• Scope, Design, develop, Unit-test and document complex BI solutions.
• Act as an internal evangelist to business units in offering innovative BI solutions.
• As an architect lead Analytics & Bi projects across functional teams within systems. Designed and
• implemented federated universe model (BO)for financial reporting.
• Identify skill-gaps in teh team and mentor / train in closing teh gaps.
• Developed Tableau Data Extracts (TDE).
• Build Tableau visual analytics and POCs.
• Designed, developed and executed stress testing on tableau data extracts..
• Designed and developed custom row-level security model for tableau visualizations.
• Drive project Planning, daily stand-up meetings, reviews, sprint and release planning.
• Instrumental in defining and establishing off-shore technology strategy for business intelligence.
• Incorporate industry best practices and developments into products developed.

Environment: AWS, Cloudera Hadoop, Apache SPARK, Impala, Qlikview, Tableau, Business Objects 4.0, 4.1, Oracle 11,Redshift, Infoview, Crystal Reports 2011, Crystal Enterprise, WebI, Linux.

Confidential County, CO

Sr. Programmer Analyst - BI

Responsibilities:

• Interact with business users and business analysts to gather and document requirements and translate to technical specifications for designing Universes.
• Design and update universes in Information design tool of SAP BO based on teh requirements gathered from client.
• Develop Web Intelligence reports according to teh report design specifications using BI launch pad and Web Intelligence
• Create Ad-hoc reports using web intelligence functionalities like Variables, Formulas, Conditional formatting, input controls for business specific requirements for Human Services department which helped them analyze their clients and services offered to better understand their state mandated metric.
• Develop Dashboards and Interactive visualizations in Dashboard designer and Esri Maps for Sheriff’s Office, so they can get real time call data.
• Migrate universes and reports from Dev to Test, and Production environments using Promotion Management.
• Business Objects Administration including installation, configuration of BO tools, set up and maintenance
• Responsible for client side installations and server upgrades.
• Responsible for user security. User setup, and resolve security / permission issues.
• Attended training for Lumira for a new partnership between Confidential county and SAP.
• Evaluated Tableau for a potential analytics tool.

Environment: Business Objects 4.0, 4.1, Oracle 11, Infoview, Crystal Reports 2011, Crystal Enterprise, Web Intelligence, Xcelsius, QaaWS, Esri Maps, Lumira, Tableau.

Confidential, McLean, VA

Business intelligence Specialist

Responsibilities/Deliverables:

• Design, build, and test Cognos Impromptu reports.
• Interact with Business Users and Business Analysts to gather and document requirements and translate to Technical specifications for Designing Universes.
• Design universes in Information design tool/Universe Designer based on teh requirements gathered from client.
• Create / modify Hierarchies in teh universes to meet Drill Analysis of users reporting needs.
• Develop Web Intelligence reports according to teh report design specifications using BI launch pad and Web Intelligence.
• Create Ad-hoc reports using web intelligence functionalities like Crosstab, Master Detail, Slice Dice and Drill Down for business specific requirements like Loss, loss item, loss party, coverage, exposure and allocation.
• Created and modified teh Webi reports for various financial clients.
• Create Master Detail, Cross Tab and Chart (for trend analysis) reports. Create alerts.
• Modified BW queries to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Develop Dashboards and Interactive visualizations in Dashboard designer for Financial Claims.
• Migrate universes and reports from Dev to Test, UAT and Production environments using LiveCycle Manager.
• Create graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Dashboard Designer.

Environment: Business Objects, BW, Bex, Oracle 10, Infoview, Crystal Reports, Web Intelligence, Xcelsius, SAP Integration Kit, Cognos, QaaWS, Visio.

Confidential, Chevy Chase MD

Business Intelligence Specialist

Responsibilities/Deliverables:

• Identify business reporting requirements; transform those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, and Variables in Query Designer.
• Experience in creating universes and also connecting to multiple data sources.
• Involved in developing, designing and maintaining new and existing universes.
• Created Aliases and Contexts to resolve teh Loops and Traps (fan traps and chasm traps).
• Modified BW queries to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.
• Created monthly and summary reports in WEBI for teh different domains like Finance, Marketing and HR-domains.
• Used Variables, formulas, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Developed WEBI reports, Universes, and Dashboards.
• Work with ETL team to design ETL solutions that best met teh business logic that needed to be applied in teh Universe for reporting.

Environment: SAP BO, SAP BW, BEx, Universe Designer, Informatica, Xcelsius.