SUMMARY

• 10+ years of IT experience in Software Development, Designing and Implementing with major focus on Business Intelligence tools and Database Applications.
• Extensive experience in Data ware housing technologies with hands on Experience in Microstrategy, Tableau, Crystal Reports, Informatica, Oracle, SAP BW & SQL Server.
• Exposure to Big Data applications such as HDFS, Hive etc
• Involved in statistical programming R - Analytics using R-studio tool
• Experience in Design, Developing, Testing, Distributing, Maintaining and Performance Tuning of Reports.
• Extensively worked on Dimensional modeling and have developed interactive Dashboards.
• Have worked on MicroStrategy Administration tools such as Command Manager, Object Manager, License Manager, Integrity Manager, Narrowcast, Enterprise manager and Distribution Services.
• Expertise in configuring Distribution Services to enable Subscriptions to be delivered to file/e-mail.
• Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouse using Informatica.
• Hand on experience in developing stored procedures/packages, Database Triggers, Cursors using SQL.
• In-depth understanding of Data Warehousing Concepts.
• Possess Excellent Communication and Interpersonal skills.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

Business Intelligence: Microstrategy,Tableau & Crystal Reports, SAP BW

Analytical Tool: R Analytics

Big Data: Hive, HDFS & Cassandra

ETL Tools: Informatica

RDBMS: Oracle, SQL Server

Operating Systems: Windows 2003/2008 Server and UNIX.

Programming Languages: VB 6.0, Visual Basic .Net (C# & VB)

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles CA

Sr. Microstrategy Developer

Responsibilities:

• Working as an Architect in building new schema objects for new Venues & Attractions within the Universal Theme Parks.
• Extensively using Narrowcast services in delivering reports to multiple users
• Create reports & dashboards extracting data from multiple data sources such as Teradata & Sql Server
• Responsible for complete administration tasks using Object Manager, Command manager, Enterprise manager etc.
• Apply technical skills using Microtrategy and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests.
• Involved in the documentation of technical specifications of the Universal Parks & Resorts
• Involved in a POC in developing reports and dashboards using Tableau reporting tool.

Environment: Microstrategy, Tableau, Teradata & Sql Server.

Confidential, Cupertino CA

Microstrategy Architect

Responsibilities:

• Study the Confidential ’s advertising business process and gather the requirements interacting with Users and Business Analysts to know their Business views in developing Reports, Documents and Dashboards
• Created reports & dashboards extracting data from multiple data sources such as Hive & Oracle DB
• Extensively worked on OLAP cubes for various reporting needs
• Used VLDB properties in fine tuning the sql intensive reports using Hive
• Performed complex ad-hoc Sql queries in creating microstrategy reports from Hive & Oracle DB
• Contributed to build business dashboards to conduct trend analysis on retail metrics, especially relating to driving sales revenue and profit margin
• Worked on R-code enhancements using R-Analytics tool
• Good experience in creating visualizations using different types of widgets & graphs
• Involved in CoE by creating visual insight report pulling data from No Sql DB’s such as Cassandra DB
• Have good understanding of Microstrategy Architect & Administration.
• Extensively used Object Manager in migrating ojects from different environments.
• Good understanding in using Command Manager scripts for automating MicroStrategy admin tasks
• Worked on Enterprise Manager Reports for providing User/Report /Project etc statistics

Environment: Microstrategy,OLAP, Tableau, Hive, Oracle, Unix.

Confidential

Sr. BI Developer

Responsibilities:

• Managed a team of IT professionals in the areas of gathering, analysis and documentation of business requirements using ALM tool
• Responsible for designing the data model schema working with DBA.
• Responsible for creation of reports, Metrics with Public and Schema Objects
• Worked on Narrowcast Server especially using Scheduling, Subscription and Event Base Alert Services.
• Join in daily standup meetings with project manager, business analyst, ETL team, data modelers, testing team to discuss the user requirements and status updates.
• Supporting the project team in SIT and UAT testing.
• Worked in a Agile process with two week iterations delivering documents/report at each iteration.
• Working closely with ETL team for collecting data and testing team for resolving defects.
• Created Freeform Reports for complex reporting scenarios.
• Involved in Query optimizations using VLDB properties.
• Troubleshoot and Debugging Reports and Documents for the web users.
• Working with MicroStrategy technical support for critical issue resolution.

Environment: Microstrategy 9.3.1, Sql Server 2005 & Unix

Confidential

MicroStrategy Developer

Responsibilities:

• Report/Dashboard development
• Object Migration as well as MDX cubes migration using packages using Object Manager Tool
• Applied MSTR Patches/HotFixes to the Dev/Test/Prod environments
• Involved in complete MicroStrategy Installations on UNIX and Linux environments
• Good understanding in using Command Manager scripts for automating MicroStrategy admin tasks
• Worked on Enterprise Manager Reports for providing User/Report /Project etc statistics
• Use License Manager for activating/updating licenses for Client and at the Unix level
• Good understanding of Integrity Manager and Distribution Services
• User and User Group creations
• Enabling Traces/logs at the I-server for reproducing the errors to fix the MSTR issues
• Making project/Server configuration changes
• Ability to work on VLDB settings
• Weekly meetings with MicroStrategy consultants and work on MSTR Cases to resolve core issues
• Discussions with MSTR consultants on applying the Settings at Project/I-Server level for performance improvement of the projects.

Environment: MicroStrategy 9.2.1, Oracle 10g, Unix

Confidential

ETL & Reporting

Responsibilities:

• Provide Production support/ Development using Informatica powercenter tool 8.6.1.
• Involved in modifying mappings, analyzing the transformations, monitoring the workflows etc.
• Involved in monitoring, fixing invalid mapping data validation errors as well as removing the logical errors using session logs.
• Monitoring and triggering the workflows or Tasks.
• Was involved in creating MicroStrategy Public objects such as Metrics, filters, reports and dashboards.
• Created user and user groups using Microstrategy Developer tool.
• Used Actuate Reports to check the feeds, server statuses, schedule and generate reports, bringing down/up the applications servers etc.
• Support the Middle Office/Front Office; deliver the Risk and PNL to the teams adhering to SLA's.
• Monitoring autosys UNIX jobs so that client reports/feeds are generated and sent across within the given SLA.

Environment: Informatica, Microstrategy, Actuate, UNIX, Oracle, Sql Server

Confidential

Senior Software Programmer

Responsibilities:

• Analysis of the specifications provided by the client
• Develop web-based applications using HTML, ASP.Net, and C #. Net.
• Create stored procedures, functions and several other queries in Sql Server 2000 for reporting purposes
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Selection Criteria, grouping,sub reports etc
• Design and development of Data Base tables, Stored Procedures and Functions using Sql Server 2000
• Analysis, Design, Coding, Testing phases of Software Development
• Independently recognize, isolate, and resolve technical problems while minimizing customer stress levels.

Environment: Visual Studio.Net, Sql Server and Crystal reports 10

Confidential

Junior Programmer

Responsibilities:

• Developed and maintained applications such as Sales, Inventory, Finance and Payroll.
• Create stored procedures, functions and several other queries in Sql server 2000 for reporting purposes.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, Drill Down, SQL, Selection
• Criteria, grouping, sub reports etc.
• Create Crystal Reports using formulas, parameters, selection criteria, sub reports etc.
• Scheduling the reports to run on daily/weekly/monthly basis and email the results to the users

Environment: VB6.0, Sql Server 2000 and Crystal reports 8.0