SUMMARY:

• Extensive IT experience in Database Design, Requirement Analysis, Application Development, Decision Support Systems (DSS) and Software design and development.
• 10 years of professional experience in developing and implementing Data Warehouses and Business Intelligence applications for Retail, Financial, Consumer products and Health Care sectors using market leading ETL and OLAP tools.
• 9 years of comprehensive experience using MicroStrategy 10.x/ 9.x/8.x/7.x product suites including MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Narrowcast Server, MicroStrategy Architect, MicroStrategy Web.
• 3 years of Expertise in providing Business Intelligence Solutions using Ascential Data Stage (Manager, Designer, Administrator, and Director), Parallel Extender and Informatica.
• 2 years of Experience of MicroStrategy Administrator in Object Manager, Command Manager, Enterprise Manager and Integrity Manger
• Participated in the Full life Cycle Development (FLCD) of the data warehousing project; project planning, business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users.
• Extensive experience in modeling and developing logical/physical data models using entity - relationship modeling tools like ERwin. Strong understanding of basic concepts of data warehousing such as dimensional modeling, snowflake and starflake schemas, datamarts, fact and dimension tables identification.
• Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, security and scalability issues suited for Oracle, Teradata, DB2 and SQL Server.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. Self-motivated and enjoy working in a technically Challenging environment. Quick learner and excellent team player with ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS:

Business Intelligence/OLAP/DSS Tools: MicroStrategy 10.x/9.x/8.x/7.x (MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Agent, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Administrator, Microsoft OLAP Manager, Microsoft SQL Server Analysis Services, Business Objects, Microsoft Excel.

RDBMS: Oracle 12g/11g/ 10g/9i/8i/8.0/7.0,Teradata13 V2 R5/V2 R4, MS SQL Server 2000/7.0/6.5, IBM DB2 UDB, MS Access 2000/97/7.0

ETL Tools: Ascential DataStage 8.x/7.x/6.x, Informatica 7.x/8.x

Data Modeling: ERwin 4.0, System Architect, Microsoft Visio 2002

Programming: C, C++, VC++, Visual Basic 6.0/5.0, SQL, PL/SQL, PHP, Transact SQL, SQL*Plus 3.3/8.0, ASP, JAVA, Unix Shell Scripting.

Operating Systems: Windows XP/2000/NT4.0/98/95/3.x,windows7, Windows 2000 Advanced Server, Sun Solaris 2.8/2.7/2.6, UNIX

Scheduling Tools: Control-M (BMC)

PROFESSIONAL EXPERIENCE:

Confidential,Arlington,VA

Sr. MicroStrategy Developer/Architect

• Involved in the meetings with business users to discuss and finalize the requirements of the reports and dashboards.
• Documented to identify the various Attributes, Metrics and Reports needed from Business.
• Implemented full SDLC life cycle of report development from requirement gathering to testing
• Involved in meetings to review reports,RSD’s and dashboards in Testing and Tuning of Reports and Objects.
• Used Microstrategy Desktop to build schema objects Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model.
• Used Microstrategy Desktop objects like Drill maps to meet the report requirements.
• Extensive Experience on creating all types of Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups
• Used Pass through Functions like Apply Simple & Apply Comparison to meet the report requirements wherever necessary.
• Worked on TalentCentral and TalentAnalytics projects.
• Coordinate with India and Uk teams
• Created Transactional Reports
• Implemented several documents and dashboards using different models data in talent analytics project
• Developed reports for Manager Plus Report
• Developed dashboard for Manger Plus Report (OPQ)
• Coordinate with offshore Team
• Developed and provided entry-level Microstrategy training classes for internal developers business users of the products
• Tested report layouts, validated the SQL query, prompt ordering prompt defaults, security filters, export/print functionality and drilling options..
• Co-ordinated test plans and provided feature/functionality/usage scenarios for the Managers.

Environment: Microstrategy10.1 and 9.4.1, Microstrategy Desktop, Microstrategy Web, Object Manager, Command Manager,SQL Server 2008 and 2012, Informatica8.6, Windows XP, Windows

Confidential,Baltimore, MD

Sr. MicroStrategy Developer/Architect

• Involved in the meetings with business users to discuss and finalize the requirements of the reports and dashboards.
• Documented to identify the various Attributes, Metrics and Reports needed from Business.
• Implemented full SDLC life cycle of report development from requirement gathering to testing
• Involved in meetings to review reports,RSD’s and dashboards in Testing and Tuning of Reports and Objects.
• Used Microstrategy Desktop to build schema objects Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model.
• Used Microstrategy Desktop objects like Drill maps to meet the report requirements.
• Extensive Experience on creating all types of Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups.
• Created Comprehensive Primary Care (CPC) reports for the analysis of providres and practice names.
• Developed RSD’s to see the benefit years data for current and previous years.
• Developed reports for Providers report
• Developed report for practice report .
• Developed report for Contact information report
• Designed reports, RSD’s and dashboards to predict lag analysis of PDE submission by Insurance companies.
• Tested report layouts, validated the SQL query, prompt ordering prompt defaults, security filters, export/print functionality and drilling options..Co-ordinated test plans and provided feature/functionality/usage scenarios for the Managers.

Environment: Microstrategy 9.4.1, Microstrategy Desktop, Microstrategy Web, Oracle12g, Oracle SQL Server, Informatica8.6, Windows XP, Windows 7.

Confidential,Baltimore,MD

Sr. MicroStrategy Developer/Architect

• Involved in the meetings with business users to discuss and finalize the requirements of the reports and dashboards.
• Performed Customer Requirements Gathering, Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post Production support.
• Took part in full data warehousing application lifecycle starting from creating logical and physical data model, to implement and test ETL processes in Oracle environment.
• Created Schema Objects and Application Objects using MicroStrategy Desktop and Architect.
• Designed and Developed Reports and Dynamic Dashboards with challenging requirements.
• Used Pass through Functions like Apply Simple & Apply Comparison to meet the report requirements wherever necessary.
• Extensive Experience on creating all types of Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups.
• Created dashboards in Interactive/Flash Mode by using multiple Panels, Selectors and dynamically passed multiple values from the selectors to the reports linked in Dashboard.
• Used several Widgets and controls to Design and Develop Dashboards in Flash like all graph types, Heat maps, Gauge, Time slider, Image layout and Bubble chart etc.
• Used different types of selectors/controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Worked extensively with the End Users to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Created logical views in MicroStrategy for complex report creations situations.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Performing all the administration tasks like Monitoring and Analyzing the system usage and managing the projects. And using the Command Manager to purge the caches on database loads.
• Excellent experience configuring VLDB properties to fine-tune reports.
• Extensively involved in troubleshooting support and resolving all outstanding issues.
• Resolved attribute and metric setup issues that resulted in cross joins, ignored filters, joining wrong tables and subsequent wrong results from the database.
• Troubleshoot and tune MicroStrategy reports by analyzing the Microstrategy generated SQL to determine data issues such as double counting, hitting incorrect fact tables, incorrect joins and insufficient data.
• Involved in managing Migration of MicroStrategy projects and objects from Dev to Testing and to Prod.
• Performed Design & Code reviews Unit testing and data validation of MicroStrategy reports.
• Created “Affordable Care Act” dashboard for the analysis of Applications, Enrollment,Eligibility,Premiums,Financial assistance,Health Plan choices and Consumer Assistance.
• Created Demogrphics dashboard for the analysis of Age,Gender,FPL,Ethnicity and Race with each state.
• Created Public facing dashboard for the Demographics,Time analysis and comparision with states data
• Created Federal Marketplace Report dashboard for the State based marketplace and Federally fecilated marketplace Cumulative data with Enrollments and Special Enrollments data .

Environment: MicroStrategy 9.4.1/9.3.1/9.2.1, Desktop Reports, Web Intelligence Reports, Administration, Object Manager,Integrity manager, manager, Erwin, UNIX, Teradata 12.0, Oracle 11g,Toad, Windows 7 and Windows XP

Confidential,Baltimore,MD

MicroStrategy Developer

• Involved in the meetings with business users to discuss and finalize the requirements of the reports and dashboards.
• Documented to identify the various Attributes, Metrics and Reports needed from Business.
• Implemented full SDLC life cycle of report development from requirement gathering to testing
• Involved in meetings to review reports,RSD’s and dashboards in Testing and Tuning of Reports and Objects.
• Used Microstrategy Desktop to build schema objects Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model.
• Developed reports for the yearly activity of Contracts for Direct and In-Direct Remuneration (DIR).
• Developed RSD’s to see the benefit years data for current and previous years.
• Developed reports for DIR Summary Trends for selected time Periods.
• Developed reports for Changes in Expected Rebates Between Submissions.
• Develped reports for Totals of All Summary DIR Fields for Top 10 Parent Organizations.
• Designed reports, RSD’s and dashboards to predict lag analysis of PDE submission by Insurance companies.
• Developed and provided entry-level Microstrategy training classes for internal developers business users of the products
• Tested report layouts, validated the SQL query, prompt ordering prompt defaults, security filters, export/print functionality and drilling options..
• Co-ordinated test plans and provided feature/functionality/usage scenarios for the Managers.

Environment: Microstrategy 9.2.1, Microstrategy Desktop, Microstrategy Web, Teradata 13, Teradata SQL Assistant, Informatica8.6, Windows XP, Windows 7.

Confidential,Washington,DC

MicroStrategy Developer

• Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.
• Documented all the baseline projects based on Confidential Standards. Created baseline standard documents which directly helped organizations baseline group to improve their quality of service and It also helped to resolve the tickets faster and efficient way.
• Developed Schema Objects including Attributes, Facts, Hierarchies, Transformations.
• Extensively worked in developing Public objects including Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Created Consolidations, Custom Groups and Prompts for the reports.
• Designed report components, Templates and Filters to generate reports in grid and graph mode. Auto prompt filter to give end-user a choice of different filtering criteria each time they run the report.
• Created Security Filters to be assigned to restrict the access of the Users.
• Designed Dashboards in summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Worked on Dashboard design using different types of Datasets.
• Extensively worked on creating Report Service documents using multiple Grids and Graphs.
• Extensively worked on creation of Dynamic Dashboards.
• Created Dashbords with Mutiple Panels, Panel Selectors and Tabs.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data.
• Actively involved in deploying the Microstrategy Objects from the Development stage to QA and then to Production environment using Object Manager.
• Created Rank functions in metrics to enable functionality of sorting the data.

Environment: MicroStrategy 9.0.2/8.1.1, Desktop Reports, Web Intelligence Reports, Administration, Dash Boards, Erwin, Unix, DB2 v9.1, Oracle 10g, Windows 2000.

Confidential,Warren,NJ

MicroStrategy Consultant.

• Involved in the meetings with business users to discuss and finalize the requirements and design of the reports.
• Worked with the Data Modelers for creating the dimensional model based on the requirements.
• Designed, developed and maintained logical and physical enterprise data warehouse schemas using Erwin.
• Extensively created filters, facts, Consolidations, Transformations and Custom Groups.
• MicroStrategy Desktop to generate reports for the Business analysis.
• Created ad-hoc reports by drilling up, down, within and across dimensions.
• Involved in developing the Product Performance, Employee Recievables Analysis dashboards
• Created transformational metrics to compare monthly, quarterly and annual analysis.
• Created Metrics, Filters, Attribute-to-Attribute qualification, Metric-to-Metric qualification prompts using MicroStrategy for report development.
• Unit tested the reports developed by the report developers.
• Generate emails and distribute upon getting acceptance from the QA team.
• Used Enterprise Manager to see the performance of reports and how different objects were being used by various users
• Organized training classes for in-house associates.
• Provided post production support to end-users.

Environment: MicroStrategy 9/8.1.1,Desktop Reports, Web Intelligence Reports, Administration, Dash Boards, Erwin, Unix, Toad,Teradata V2R5, Oracle 10g, Windows 2000.

Confidential,Foster City,CA

MicroStrategy Consultant

• Work with the technical leads from Global Data Warehousing, from design through implementation into production environment.
• Experienced Working with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.
• Responsible for keeping team members on track towards completing the terms of goals.
• Created views for MicroStrategy view layer for dimensional modeling for the project
• Tuned the VLDB properties to enhance the performance of the reports at report level.
• Managing schema objects and application objects across the project by using Object Manager.
• Experienced in creating the canned reports, ad-hoc reports and service documents.
• Created Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the MicroStrategy objects necessary for the deliverable.
• Created derived metrics, compound metrics and filter in a metric for very complex reports.
• Created transformations (table based) for using in comparative reports like sales this year verses last Year.

Environment: MicroStrategy 8.1.1,Desktop Reports, Web Intelligence Reports, Administration, Dash Boards, Erwin, Unix, Toad, Oracle 10g, Windows 2000.

Confidential,NewJersey

MicroStrategy Consultant

• Involved in design of proto type of reports based on requirements.
• Involved in Dimensional Data Modeling (Star Schema, Snow flake Schema) Data Architecture, Business and Data Analysis.
• Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.
• Created transformational metrics (Bicylists Involved, Bicyclists Killed, Pedestrians Involved, Pedestrians Injured, Pedestrians Killed and Vehicles Involved) to compare monthly, quarterly and annual Accidents.
• Created Relation Ship tables to avoid Many-Many relation ship between parent and child attributes.
• Involved in up gradation of Schema Objects (facts, attributes, hierarchies, Transformations), Application Objects (filters, prompts, metrics, consolidation, and custom groups), user groups from 8.0.3 to 8.1
• Involved in moving the objects between two projects and two different environments by using Object Manager and merging the projects by using Project Merge Wizard.
• Involved in tuning the application Queries’ using Explain Plan.
• Training the users how to use Microstrategy for their business analysis.

Environment: MicroStrategy 8.1/8.0.3, Desktop Report, OLAP Services, Architect, Narrowcast Server, Administration, Erwin, Unix, Toad, VBA, Oracle 10g, and Windows 2000.

Confidential,Washington,DC

ETL Consultant.

• Familiar with DataStage Administrator, DataStage Designer, DataStage Manager, DataStage Director.
• Analyzed the functional spec and designed the technical design specification documents for different interfaces. Involved in design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Gather requirements and design of data warehouse and data mart entities.
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Build efficient Data Stage jobs for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Designed and developed various jobs for loading data from multiple sources oracle, UDB to ODS.
• Used DataStage Parallel Extender stages like Sequential file, Datasets, Copy, Oracle Enterprise, Join, Sequencer, Aggregator, Merge, Filter, Transformer, Lookup, Funnel, Compress stage.
• Developed Perl and UNIX shell scripts for FTP source files maintenance. Involved in modifying the existing scripts for new enhancements.
• Wrote Sql Code, using TOAD to handle complex business logic and to compare source data with the target data during the Unit and Functional Testing.
• Installation and Configuration of Ascential Quality Stage system for evaluation purposes. Designed, Documented and implemented various standards for the quality of data warehouse data
• Performed debugging, troubleshooting, monitoring and performance tuning using Data Stage.
• Oversaw unit and system tests and assisted users with acceptance testing and experienced in creating the test cases for each stages.
• Train and manage developers, advising other groups in organization on data warehouse development, and ETL development best practices.

Environment: Ascential DataStage 7.5.2, QualityStage, Oracle 10g/9i, FTP, SQL, PL/SQL, Toad 9.0, Erwin, UNIX, PERL, UDB DB2, Autosys and AIX 5.3.

Confidential, MI

DataStage Developer

• Experienced in writing the Technical Design Specification documents for different interfaces.
• Designed and developed jobs for loading data from Operational system Database to ReDS Database.
• Used DataStage Designer to develop jobs, DataStage Manager for importing and exporting jobs into different projects from one Environment to the other, DataStage Director for validating, executing, scheduling and monitoring jobs.
• Extensively involved in development of OVD Dash Board at Project level.
• Created scripts to perform validations and run jobs on different instances (Development, Model Office, Production Management and Production Environments).
• Involved in modifying the existing scripts for performance tuning.
• Wrote Sql Code, functions and packages using TOAD to handle complex business logic and to compare source data with the target data during the Unit and Functional Testing.
• Performed testing, debugging of the jobs and migrated different projects from one environment to the other..
• Developed several data stage jobs to improve performance by reducing runtime using different partitioning techniques. Developed user defined routines for several jobs.
• Extensively worked for Updated the test cases on based on the requirement changes and executed the test cases from end to end.

Environment: Ascential DataStage 7.5.2/Parallel Extender, Oracle 10g, FTP, SQL, PL/SQL, Toad, Erwin, Unix Shell Scripts, UDB DB2, Autosys Jil and AIX.

Confidential, CA

ETL Consultant

• Designed Mapping documents ETL architecture documents and specifications.
• Analyzed the Source Data and designed the source system documentation.
• Participated in discussions with Project Manager, Business Analysts and Team Members on any technical and/or Business Requirement issues.
• Designed Documents for performing unit testing and string testing of developed code.
• Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Analyzed COBOL Copybooks for Source Dictionary.
• Imported VSAM file Data structures using DataStage Manager.
• Developed PL/SQL scripts for ETL (Extraction, Transformation & Loading).
• Used surrogate key assignment and change data capture.
• Used Parallel Extender for Parallel Processing for improving performance when extracting the data from the sources and used various Parallel Extender partitioning and collecting methods.
• Followed Star Schema to develop data marts.
• Worked with Metadata Definitions, Import and Export of DataStage jobs using Data stage Manager.
• Implemented Quality Stage for data cleansing, data standardization and matching process.

Environment: DataStage 6.0, SQL, PL/SQL, SAPR/3, UNIX, SQL Server, Erwin 4.0, Stored Procedures, DB2 UDB, IBM AIX 4.2. SAPR/3 ECC6.0.