SUMMARY

• Experienced professional with 10 years of experience in the field of Information Technology.
• 7 years of experience in major Business Intelligence technologies like MicroStrategy, Tableau, and Microsoft SQL Server Reporting Services (SSRS).
• 5 years of extensive experience in MicroStrategy Suite (Intelligence Server, Administration, Desktop, Web, Office, Narrowcast Server, Distribution Services, Enterprise Manager, Integrity Manager).
• 5 years of experience as a Tableau Developer.
• Cloudera Certified Administrator for Apache Hadoop.
• Excellent analytical, inter - personal, and communication skills with clear understanding of business process flow.
• Ability to work independently as well as in a team environment.
• Experience working with Big Data systems like Aster, Hortonworks Hadoop, and Amazon EMR.
• Experience in Object Oriented programming with C#, Visual Basic, C++, Java.

TECHNICAL SKILLS

Database Technologies: MS SQL Server, Oracle, MS Access, MySQL, ADO.NET, Teradata, Aster, Hive.

Operating Systems: UNIX, LINUX, Solaris, Windows, Mac OS.

OLAP Tools: MicroStrategy, Tableau, Microsoft SQL Server Reporting Services (SSRS), Microsoft Power View

Languages: C, C++, C#, VB, Java, MATLAB, Lua, SQL, Perl, Aster SQL-MapReduce, Hive, Pig.

Web Technologies: Classic ASP, ASP.NET, HTML, XML, JavaScript, CSS, PHP, MySQL, JBoss, IIS, WebSphere.

ERP: PeopleSoft Time and Labor, SAP HR, Oracle Time and Labor.

Software and Tools: Toad, SQL Management Studio, Oracle SQL Developer, MS .NET, J2EE, Microsoft Office, NetBeans, Eclipse, Visio, FrontPage, Subversion, Joomla, WordPress, Adobe Photoshop, Adobe Dreamweaver, Teradata SQL Assistant, Teradata Studio, Cloudera Hadoop, Hortonworks Hadoop, Amazon Redshift.

PROFESSIONAL EXPERIENCE

Confidential, IL

Sr. Programmer Analyst - Business Intelligence

Responsibilities:

• Designed, developed, and published highly interactive visualizations and dashboards using Tableau to analyze and understand the effectiveness of newly implemented Mobile Offers Program.
• Automated report generation and distribution in Tableau using tabmcd.
• Used Data Blending in tableau to develop reports using multiple data sources.
• Published Tableau workbooks by creating user filters so that only appropriate market teams can view it.
• Developed strong understanding of advanced Tableau features including calculated fields, level of detail calculations, table calculations, groups, sets, parameters, data blending, and dashboard actions.
• Acted as Subject Matter Expert for designing and developing Business Intelligence Projects.
• Worked with Microsoft reporting technologies like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (DQS); wrote complex SQL queries and stored procedures; used SQL Server jobs and Microsoft task scheduler in design and development of a reporting project.
• Participated in the development and implementation of complex Reports and Documents using MicroStrategy Product suite.
• Provided critical care support for newly implemented reporting projects. Also, assisted with escalated production support issues.
• This includes: identification and resolution of data discrepancies and availability; explanation of functionality; escalation to development teams for database and ETL related issues.
• Gained hands on experience with Report development life cycle; beginning from requirements gathering to development, testing, moving to production, and support turnover.
• Participated in tuning high complexity SQL for better performance.
• Involved in troubleshooting MicroStrategy Reports, optimizing SQL using VLDB properties.
• Created MicroStrategy Schema Objects like Facts, Attributes, Hierarchies, Transformations and Public Objects like Filters, Prompts, Metrics, Custom groups and Consolidations, and Documents.
• Created Derived metrics, and Compound metrics for complex MicroStrategy reports.
• Used MicroStrategy Pass-through functions like ApplySimple and ApplyComparision to develop complex filters.
• Created transformations in MicroStrategy to do time series analysis, and to compare the values at different times such as sales for current year versus last year, year-to-date, month-to-date, etc.
• Configured Data Mart reports to perform write-backs in order to create user defined custom groups in MicroStrategy.
• Used MicroStrategy narrowcast services tool to deliver report service documents in PDF and Excel via email and subscription portals.
• Designed and developed an automated process using MicroStrategy Narrow Cast server to deliver daily emails based on a threshold; used presql and postsql logic to check and control the trigger condition in the database.
• Involved in upgrade process of MicroStrategy from version 9.2 to 9.3 to 10 documenting the whole upgrade process.
• Utilized MicroStrategy’s SDK to develop and customize Web Portal application using classic asp and JavaScript.
• Provided developmental support in maintaining existing VBA macros as well as designed and implemented new VBA macros to work in conjunction with MicroStrategy generated excel reports.
• Performed analysis for fraud detection using Teradata Aster’s Analytics and SQL-MapReduce framework to query the Aster database.
• Created and scheduled Linux cron jobs and scripts to: connect to Aster database, run queries to extract data, and deliver reports to end users.
• Used HIVE to query and analyze data stored in Hadoop.

Confidential, NY

Sr. Business Analyst

Responsibilities:

• Designed, and Developed MicroStrategy Reports and Documents.
• Tuned and Optimized report SQL for better performance.
• Designed, developed, tested and documented applications based on system and user requirements.
• Utilized Microsoft .Net technology to design and develop a Time and Attendance Software for an embedded Windows CE based touch screen data collection device (time clocks) for workforce management.
• Utilized C# .NET working closely with the development team to analyze, design, and develop functional and technical components of the application.
• Used SQL Server Compact 3.5 Database to store transaction and configuration data.
• Established bi-directional communication between the device and the application server using Web services in order to send transaction data, and download validation files and fingerprint templates.
• Integrated external readers like fingerprint, proximity, and barcode with data collection devices.
• Created Test plans and performed Quality Analysis to ensure seamless functionality of all the software and hardware components.

Confidential, Dayton, Ohio

Software Intern, Engineering Analyst

Responsibilities:

• Performed real-time as well as historical search, reporting, and statistical analysis of machine generated data.
• Programmed a GUI based tool using Visual C++ for recording CAN (Controlled Area Network) data.
• Developed scripts using Lua and Perl scripting language for analysis and reporting of CAN based sensor data.
• Worked with Excel/VBA macro to achieve auto generation of Embedded C++ programs involving different language strings.
• Learned about Active Sync, Subversion, and RAPI (Remote API) tools while working on an application install program for an embedded system based Windows CE device.
• Created technical specification documents for new products, and developed installation and configuration procedures for training product technicians.

Confidential, Dayton, Ohio

Graduate Teaching Assistant, Graduate Research Assistant

Responsibilities:

• Provided Graduate Teaching assistance for courses such as Embedded Systems, Microprocessor Based System Design, C and Advanced C Programming for Engineers.
• Integrated hardware tools and software APIs provided by Alien Technology with my algorithm using C# .NET to develop the RFID localization software.
• Utilized Microsoft SQL server 2005 to log data and perform queries for statistical analysis.
• Gained extensive experience in C#, .NET platform, GUI programming, SQL, MATLAB and RFID infrastructure, and greatly improved my documentation skills.