Sql Server Life Cycle
Resume:
Ravindra Pulaparty
MicroStrategy Consultant
Email : ************@*****.***
Phone: 410-***-****
PROFESSIONAL SUMMARY
Extensive IT experience in Database Design, Requirement Analysis, Application Development, Decision Support Systems (DSS) and Software design and development.
Over 12 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 2021/2020 AWS/11.x/10.x/ 9.x/8.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, DataMart, 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, Netezza 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.
MicroStrategy provides an extension to the Intelligence Server called Multi-Source Option.
Accessing multiple relational data sources in a single project can provide many benefits and reporting solutions.
Knowledge of Tableau 2021.2 and Business Objects.
Worked on Jira Agile methodology
TECHNICAL SKILLS
Business Intelligence/OLAP/DSS Tools
MicroStrategy 2021/ 2020 AWS/11.x/10.x/9.x/8.x (MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Agent, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Administrator, Microsoft OLAP Manager, Microsoft SQL Server Analysis Services, Business Objects, Tableau 2021.2,Microsoft Excel.
RDBMS
Oracle 12g/11g/ 10g/9i/8i/8.0/7.0,Teradata13 V2 R5/V2 R4, MS SQL Server 2019/7.0/6.5, IBM DB2 UDB, MS Access 2000/97/7.0,Netezza7.0/7.1
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
QVC(Quality Value Convenience),West Chester, PA March’22 to Current
Sr. MicroStrategy Developer/Architect
Duties:
Working on Integration Project
Conversion from Business objects to Microstrategy
Created Documents to replicate to Business Objects
Created Custom Subtotals
Created Groping logics for subtotals and Grand Totals
Created Inventory Management Dashboard
Used Microstrategy Desktop to build schema objects Logical Views, 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, Metrics, Consolidation and Custom Groups.
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 11.3.8, Microstrategy Desktop, Microstrategy Web, Microsft SQL Server, Windows XP, Windows 10,Netezza 7.0/7.1
WellsFargo Charlotte, NC Oct’21 to March’22
Sr. MicroStrategy Developer
Duties:
Working on Issue Managment Project in Wellsfargo
Created Cubes based on the Monthly,Weekly and Quarterly Data
Created Issue Management Dashboard-All
Created International Issue Management Dashboard
Created Closed Issues/CA Reporting Dossier
Created Issue Management Dashboard-All Quantitative Timing
Created Issue Management Dashboard-All Adherence
Created Issue Management Dashboard- All Data Quality
Created Issue Management Dashboard-All Scorecard
Used Microstrategy Desktop to build schema objects Logical Views,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.
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 11.2, Microstrategy Desktop, Microstrategy Web, Microsft SQL Server, Windows XP, Windows 10.
Centers for Medicare and Medicaid Services (CMS), Baltimore, MD Jan’20 to Sep’21
Sr. MicroStrategy Developer/Architect and Tableau Developer
Duties:
Working on Electronic Submissions of Medical Document for Federal Client project.
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.
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.
Tableau Development:
Working on CBR Pepper program for Federal Client project.
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
Created US map visualization in Tableau
Designed bar graphs and pie charts in Tableau
Environment: Microstrategy 2020 AWS,Microstrategy 11.1, Microstrategy 11.0, Microstrategy Desktop, Microstrategy Web, Tableau 2021.2,Oracle12g, Oracle SQL Server, Windows XP, Windows 7.
Centers for Medicare and Medicaid Services (CMS), Baltimore, MD Sep’17 to Dec’19
Sr. MicroStrategy Developer/Architect
Duties:
Working on Electronic Submissions of Medical Document for Federal Client project.
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 Active Organization report for different lone of business.
Developed Aging report for number of submissions from Recipient.
Developed reports for line of Business submissions report
Developed report for Reconciliation for different pilot programs.
Developed report for Audit event lifecycle of Transactions
Developed Cumulative Medical Record Counts report for the Specified reporting Period
Developed Total, in progress, completed and invalid submissions volume by HIH’s and RC’s
Designed reports, RSD’s and dashboards to Recipient and Senders information using different lines of business programs.
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 10.4, Microstrategy Desktop, Microstrategy Web, Oracle12g, Oracle SQL Server, Informatica8.6, Windows XP, Windows 7.
Corporate Executive Board (CEB), Arlington, VA Dec’14 to Sep’17
Sr. MicroStrategy Developer/Architect
Duties:
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,10.2,10.3,10.4 and 9.4.1, Microstrategy Desktop, Microstrategy Web, Object Manager, Command Manager, SQL Server 2008 and 2012, Informatica8.6, Windows XP, Windows
Centers for Medicare and Medicaid Services (CMS), Baltimore, MD Aug’14 to Nov’14
Sr. MicroStrategy Developer/Architect
Duties:
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 providers 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.
Centers for Medicare and Medicaid Services(CMS),Baltimore,MD Sep’12 to July'14
Sr. MicroStrategy Developer/Architect
Duties:
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 comparison 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
Centers for Medicare and Medicaid Services (CMS), Baltimore,MD Feb’12 to Aug’12
MicroStrategy Developer
Duties:
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.
Developed 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.
Department of Education(DoED), Washington, DC May’11 to January’12
MicroStrategy Developer
Duties:
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 Visa 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 Dashboards with Multiple 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.
EDUCATION
Bachelors in Electronics and Communication Engineering, Gulbarga University, Raichur, Karnataka, India.
Contact this candidate