| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Contact Number: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEWork Authorization: Green CardCity and State : Ellicott city, MDPublic trust Clearance(SF Street Address P) : YesSummary12 years of experience in the data warehouse applications using MicroStrategy, Tableau, Qlik, Cognos, SAP Business Objects, AWS Redshift, Snowflake, Oracle, Sql Server, Netezza, Teradata, DB2 on Windows/Linux platforms.Expertise in using MicroStrategy 11/10/9/8.x product suites including MicroStrategy Desktop, Web, Architect, OLAP Services, Object Manager, Command Manager and Integrity Manager, System Monitor, User Manager and Enterprise Manager.Three plus years of experience with Development of Dashboards in Power BI, Tableau and Qlik sense.Expertise in migrating Business Objects, Cognos Reports to MicroStrategy.Experience in ETL tools Informatica and Oracle Warehouse Builder.Expertise in Hands on training to End users to develop Attributes, Metrics, Filters, Prompts, Datasets and Dossier.9 years experience working with Social Security Administration (SSA) and Health care (CMS) IT Projects.Expertise in Data Migration, Data Integration, Data Mapping, Data Cleaning, Data Mining and Data Validation.Experience working in agile projects and Certified safe Agile Professional.Two years of working experience with offshore development team.Expertise in MicroStrategy platform upgrades. Have worked on project planning and implementation of MicroStrategy platform upgrades starting with V8 to v2020.Expertise in working with AWS components EC2, VPC, IAM, S3, Cloud Front, Cloud Watch, Glacier, RDS Config, Route 53, Elastic Cache and Load Balancer.Expertise in Cloud based Database & Storage implementation on AWS S3, EBS, EFS, Redshift and Snowflake data warehouse.Proficient in AWS, Azure services, including S3 buckets, EC2, SNS, ADF, Azure Data Bricks, Data Lake, and Data Storage.Experience in developing test cases and test plans for system testing, unit testing and UAT extensively.Experience in code optimization and performance tuning of database queries.Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL.Strong presentation, analytical, multi-tasking, decision making, problem solving and excellent inter-personal skillsStrong communication skills (written, reading comprehension, listening, verbal, training and presentation.CERTIFICATIONSCertified Professional in Microstrategy (MCD, MCE and MCEP).Certified Professional in 508 Testing.Certified AWS Solution Architect Associate.Certified Agile SAFe4 and Scrum Master.Technical ProficiencyBI/OLAP ToolsMicrostrategy 2021/11.1/10.4/9.4.1/9.3.1/9.2.1/9.0.2/8.1.2/8.1.1/8.0.2 (Microstrategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Object Manager, Integrity Manager, Command Manager, Business Objects XIR2, R3/6.5(Universe, Xcelsius, Web Intelligence),Cognos 8.4.1, Framework Manager, Query Studio, Report Studio, Tableau 10.5 (Desktop, Public, Reader) and Qlik View 12 (Desktop and Server), SSIS 2010, SSRS 2010, SSAS 2010.AWS ToolsEC2, S3, ELB, Auto scaling Groups, Glacier, EBS, Elastic, Beanstalk, Cloud front, RDS, Redshift, VPC, Route 53, Cloud Watch, Cloud Trail, IAM, Dynamo db, Elasticache and LambdaETL ToolsInformatica 8.6.1/8.1/7.x/ 6.x, Oracle warehouse Builder 10.2.Data Modeling ToolsErwin 4.0/3.5.2, MS-VisioDatabasesOracle 19c/18c/11g/10g/9i/8i, MS SQL Server 2000/2005, Netezza 5.0, DB2 7.0, Teradata 12, Bigdata Hive, ImpalaDatabase UtilitiesToad, SQL developer, SQL*Loader, Oracle Developer 2000 (Forms 6i & Reports)508 ToolsJaws 2020, Jaws 12, 14, MAGic, Dragon.LanguagesC, C++, JAVA, Visual Basic, Unix, SQL, PL/SQL, XMLConfiguration ToolsClarcase, VSS, GITOperating SystemsWindows 10/2000/XP/NT, HP-UX, Unix, IBM AIX 4.3/4.2 and Sun SolarisEducation:Masters from West Virginia University in Computer Science.BE from JNT University in Computer Science.Project ExperienceClient: Peraton (CMS), MD Jul 21 to Till dateSR Microstrategy Architect/AdminProject: MEPBSDomain: HealthcareResponsibilities:Gather Business requirements and Transform business requirements into sustainable BI solutions through the construction of MicroStrategy reports and dossiers.Prepare High level design, technical design documents and MicroStrategy object mapping sheet.Expertise in create microstrategy user guide to train CMS end users to develop Objects Attributes, Metrics, Filters, Prompts, Datasets and Dossier.Created MicroStrategy Hyperintelligence Cards to display information.Created and Modify MicroStrategy Dossiers, Libraries,Users and User Groups from Workstation.Created Dossier in MicroStrategy desktop and shared to other users.Responsible for conversion of Reports from Microstrategy to power BI.Responsible for design, develop, publish and scheduling the Power BI Reports & Dashboards as per the requirement.Responsible for define joins between tables in Power BI Model and Transformation of data in Data View.Responsible for development of Mapping document for conversion of reports from Microstratgy to Power BI.Administered the MicroStrategy environment, managing user access, security settings, and project configurations.Collaborated with cross-functional teams to gather requirements and develop custom reports and dashboards that met business needs.Conducted troubleshooting and issue resolution for complex reporting and dashboard problems, ensuring minimal downtime and user satisfaction.Led the migration of an on-prem data warehouse from SQL Server to Google BigQuery, ensuring a seamless transition and data integrity.Work with the admins to promote the MicroStrategy object packages from Dev to UAT & PROD.Responsible for testing reports, dash boards for 508 compliances by using Jaws 14.0, Magic 11.0 and Dragon 11.0.Responsible for upgradation of MicroStrategy in Windows and Unix environment from 10.x to 11.Involved in unit testing the SQL and ETL Logic and perform data validations.Responsible for writing unit test cases for Validation of Reports.Environment: Power BI, Microstrategy 2021/11, Oracle 18c/19c, MS SQL Server, Jenkin, GitHub, AWS, Snowflake, Python, Big data, Hive, Impala, Big Query, Jaws 2020, Magic, Dragon, Azure Data factory, Azure Data Bricks.Client: Truist Bank, NC Aug19 to Jul21SR BI/Microstrategy AnalystProjct: Commercial Lending ProjectDomain: Financial/BankingProject Responsibilities:Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema), Business and Data Analysis.Responsible for Design and Development of Schema Objects Attributes, Facts, Hierarchies and Transformations for New NDW ReportsResponsible in developing of public objects Filters, Prompts, Metrics, Drill Maps, Consolidations, Custom Groups, Templates and Reports for New NDW Report requests raised by CMS users.Responsible for setting of VLDB properties to optimize the query generated Microstrategy.Responsible for developing highly interactive MicroStrategy dashboards by using Visual Insights/Dossier that replaced legacy reports.Responsible for creating and executing scripts by using Command manager to list Properties of attributes, Metrics and Filters.Responsible for Categorize Reports based on prompts present to execute Reports from integrity manager.Responsible for designed and development of complex data models in Power BI, including relationships, hierarchies, and calculated columns.Responsible for development Power BI DAX(Data analysis expressions) for creations of Columns.Responsible for Design, develop, publish and scheduling the Power BI Reports and Dashboards as per the requirement.Responsible for testing reports, dash boards for 508 compliance by using Jaws 14.0, Magic 11.0 and Dragon 11.0.Expertise in Hands on training to CMS End users for three days to develop Attributes Metrics, Filters and Dossier.Developed ETL pipelines, by using Azure Data factory by extracting and cleaning data from Azure Blob Storage, Azure Sql database and Azure Data lake.Developed Microstrategy reports, dossiers on Azure data bricksResponsible for validate Reports after migrate to AWS environment using integrity manager.Responsible for Performance and Unit Testing of Developed Dashboards.Involved in working with DBAs to improve performance reports by checking explain plan of query and create Indexes on database columns to improve performance of Reports.Environment: Microstrategy 11.1, Power BI, Architect, Web Intellegence, Oracle 18c/19c, Azure, Big data, Hive, Impala, Jaws 2020, Magic, Dragon, AWS Glue, AWS quasiClient: ManTech, MD Jun 16 to Jul 19BI/Microstrategy Architect/AdminProject: BI ReportingDomain: HealthcareResponsibilities:Worked as a MicroStrategy Architect, Developer and AdministratorWorked with client to gather requirements and prepared technical specifications documents.Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports.Involved in discussion with data modelers to understand data modeling of existing schema.Responsible for development of Dynamic Dashboards by Using Multiple Panels and Selectors.Responsible for development of Visual Insight Dashboards to analyze data for Users.Responsible for setting of VLDB properties to optimize the query generated Microstrategy.Responsible in development of reports against Intelligent Cubes which involves faster execution of query compare to the data warehouse.Responsible for Send Requests to Microstrategy Admin Group to Usage Report from Enterprise Manager.Responsible for Send Requests to Microstratgey Admin Group to Migrate Objects from Development to QA and QA to Prodution.Responsible for testing reports, dash boards for 508 compliances by using Jaws 14.0, Magic 11.0 and Dragon 11.0Responsible for writing Logical Views in Desktop to Develop Reports.Responsible for working with Users to trouble shoot Reports and Guide users to Apply Job Codes in order to get appropriate User access privileges in the Project.Responsible for attending IDR Bi weekly meeting and Modify Reports and Update Data structures if any Changes happen in IDR Database.Responsible for Creation of Worksheet, Dash board by using Tableau Desktop and Public.Responsible for Replication Reports from Pear Projects to IDR Building Block Project which are points to Different VDMs.Responsible for Run Integrity Manager to take base line before Upgrade and Compare Report Results after Upgradation Process.Environment: Microstrategy 10.4/10.2/9.4.1, Architect, Web Intellegence, Informatica 9X, Tera data, DB2 8.x/9.1, SQL Server 2016, SQL, PL/SQL, Windows NT and UNIX, Jaws 14, Magic, Dragon, Tableau Desktop, Tableau Public, Bigdata, Hive, ImpalaClient: Social Security Administration (Leidos), MD Feb14 to May16MicroStrategy Administrator/DeveloperProject: DCPS MI Reporting SystemDomain: Federal GovResponsibilities:Worked as a MicroStrategy Architect, Developer and Administrator.Co-ordinated meetings with clients and business users to discuss and understand requirements.Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis.Involved in discussion with data modelers to understand data modeling of schema.Work with SSA to gather requirements and prepared technical specifications documents.Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports.Reconfigured 50+ reports in MicroStrategy, adapting them to the new data warehouse structure and optimizing performance.Designed and upgraded dashboards to provide enhanced data visualization and insights, resulting in improved decision-making for business users.Involved in development of reports against Intelligent Cubes which involves faster execution of query compare to the data warehouse.Responsible for installation of Microstrategy 9.2.1/9.3.1 on new boxes and hot fixes on already existing boxes.Expertise in using User Manager Window to create Users and assign them appropriate UserGroup privileges.Expertise in activation of license key through License ManagerDuplication of projects In VM Environment for Developers by using Object Manager Window.Involved creating and executing scripts by using Command manager to list Reports and attributes, Metrics in the Project as well as its Properties.Use Enterprise manager to list to see statics of Reports like Table and Column was accessed by reports and top 10 reports accessed by users and longest execution Reports.Involved in implementing data level at DDS, Region and State level security by using Security Filters.Involved in creation of detail reports by drilling on metrics.Involved in Upgradaton of projects from 9.0.2 to 9.2.1 and 9.3.1 to 9.4.1 in Development, Validation, Integration and Production servers.Responsible for testing reports, dash boards for 508 compliances by using Jaws 13.0, Magic 11.0 and Dragon 11.0Involved in using Scan Md to Repair the Meta data.Improve Performance of reports By Using Fine Tuning of Sql Quiries of Logical Views BY analyse Execution Plan of Queries.Environment: Microstrategy 9.4.1, Architect, Desktop Reports, Web Intelligence Reports, Report Services, Administration, Dashboards, Scan MD, Enterprise Manager, Object Manager, Informatica 8.1, Toad, Oracle 10GR2,Jaws 12, MAGic and Dragon,UnixFreddimac, Herndon, Virginia Jul13 Jan14BI/MicroStrategy ConsultantProject: Single Family Transaction Accounting (SFTA)Domain: FinancialResponsibilities:Worked as a MicroStrategy Architect and Developer.Involved in the meetings with business users to discuss and finalize the requirements and design of the reports.Involved in dimensional data modeling (Snow-Flake Schema) Data Architecture, Business and Data AnalysisInvolved in creation of canned reports and adhoc reports from the schema objects and public objects.Involved in setting of VLDB properties at report, metric and database instance levels to manage join, metric calculations and query optimizations.Involved in creation of logical views to defined Sql query against Data Warehouse.Involved in developing reports by using Freeform SQL in Microstrategy Desktop.Involved in creation of aggregate tables, datamart reports to improve performance of reports.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 creation of services using subscription sets, schedules, device, locale and information objects.Involved in upgradation of schema objects (facts, attributes, hierarchies and transformations), application objects (filters, prompts, metrics, consolidation and custom groups), and user groups from 8.1.1 to 9.Involved in development of reports against Intelligent Cubes which involves faster execution of query compare to the data warehouse.Involved in creation of Users/User Groups and assigning privileges them through Command ManagerCreating dashboard reports to view personalized reports based on user requirements.Involved in using SDK to customize web home pages.Involved in migration of reports from cognos 8 to Microstrategy.Involved in development of schema objects and Application Objects in Microstrategy Corresponding Objects Exists in Cognos Reports.Involved in partitioning the tables, indexes and management of the schema objects.Involved in optimization of code and tuning queries for performance.Involved in tuning the application queries using Explain Plan.Involved In testing of reports and queries by test cases and test plans.Environment: Microstrategy 9/8.1.1,Desktop Reports, Web Intelligence Reports, OLAP Services, Architect, Narrowcast Server, Administration, Dashboards, Cognos 8, Clear Case 7.1, Toad, Rapid Sql, VBA, DB2, Windows 2005.State of New Jersey Office of Information Technology (NJOIT), NewJersey Jun 12 Jun 13BI ConsultantProject: Dot Crash Reporting SystemDomain: State GovResponsibilities:Worked with client to gather requirements and prepared technical specifications documents.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.Involved in creating schema objects and application objects necessary for the deliverable.Maintain the performance tuning of large reports by changing VLDB settings.Involved in defining logical views to get data through queries from self joined tables.Architected the projects and created all the necessary schema, application and configuration objects.Created transformational metrics (Bicylists Involved, Bicyclists Killed, Pedestrians Involved, PedestriansInjured, Pedestrians Killed and Vehicles Involved) to compare monthly, quarterly and annual accidents.Created ad-hoc reports by drilling up, down, within and across hierarchies.Used Apply Simple and Apply Comparison functions to create complex filters and transformations.Involved in migration of Business Objects reports into Microstrategy Reports.Involved in developing reports by using Free Form SQL Queries in Microstrategy Desktop.Create a test plan, perform unit testing and send the test plan along with the files generated for QA.Training the users as per Industry standards, how to use Microstrategy for their business analysis.Environment: Microstrategy 9.4.1, Desktop Reports, Web Intelligence Reports, OLAP Services, Architect, Narrowcast Server, Dashboards, Business Objects Xir2, Crystal Reports, Datastage 7.5.2, Toad, VBA, Oracle 10g, Windows 2000.Merck & CO., Inc. Whitehouse Station (Cognizant), New Jersey Jun11 May12BI DeveloperProject: Corner StoneDomain: PharmaceuticalResponsibilites:Worked with client to gather requirements and prepared technical specifications documents.Involved in design of proto type of reports based on requirements.Communicate offshore working team to explain client requirements and develop reports.Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, business and data analysisActively involved in walkthroughs and meetings with business team to discuss related issues and review of the objects and reports.Responsible as a team lead for keeping team members on track toward completing the terms of goals.Involved in installation and configuration of Microstrategy 8.1.1.Creating schema objects (facts, attributes, hierarchies and transformations) and application objects (filters, prompts, metrics, reports) needed to create the Microstrategy objects necessary for the deliverable.Architected the projects and created all the necessary schema, application and configuration objects.Creating advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.Creating dashboard reports to view personalized reports based on user requirements.Involved in the creation document from multiple datasets like Map Application Diagram, Grid and Graph.Involved in developing reports by using Freeform SQL Queries in Microstrategy Desktop.Involved in using Netezza data warehouse system for terabytes of dynamic, detailed data to dramatically simplify.Involved in optimization of code and tuning queries for performance.Involved in tuning the application queries using Explain Plan.Provided post production support to end-users.Environment: Microstrategy 8.0.2/8.1.1,Desktop Reports, Web Intelligence Reports, Architect, Narrowcast Server, Dash Boards, Administration, Informatica 7x,Unix, Toad, VBA, SDK, Excel, Oracle 10g, Netezza, Windows 2000 |
