Manager Sql Server
Resume:
VR
****@********.***
Summary:
Over 8+ years of progressive IT experience in executing Business Intelligence Solutions, ETL, BI Tools, Data Warehousing, Data Modeling and OLAP.
Around 5 years of experience in using MicroStrategy Suite (Intelligence Server, Administrator, Desktop, Web and Narrowcast Server).
Worked extensively on MicroStrategy Desktop, Administrator, Intelligence Server, and Web.
Worked closely with Business Analysts and Financial Analysts to know the requirements.
Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Data warehouse.
Extensive knowledge in Creating Data Mart Reports using Complex Filters and Compound Metrics.
Handled complex Reports in MicroStrategy Desktop using features like templates, custom groups and consolidations.
Experience delivering reports in Desktop, Web and via the Narrowcast server.
Experience in setting up the MicroStrategy system administration including installation and configuration, Metadata, configure the Intelligence server, creating users, user groups, security filters, roles, privileges, and security roles.
Experience in data extraction and transformation (ETL) using Informatica Power Center 6.x, Power Mart 6.x and Data Stage.
Analyzed and identified business rules for data migration and was able to handle modular designs independently and able to see through the modular issues using Data Stage.
Proficient in database programming using SQL, PL/SQL for writing Stored Procedures, Triggers, Packages.
Good knowledge and understanding of Software Development Life Cycle (SDLC).
Extensive knowledge on SQL/PLSQL and very proficient in working with very large databases in Oracle 10g /9i/8i/7.x, TERADATA, SQL Server 2005/7.0/6.5.
Excellent communication skills and the ability to work individually as well as in a team environment.
Technical Skills:
BI/DS Tools: MicroStrategy 9.2.1, 9.0, 8.1, 8.0.1 (Administrator, Agent,Narrowcast, Report Services).
ETL Tools: Informatica 8.0/7.0/6.2 (Power Center, Power Mart), SQL Server DTS, Data Stage.
Data model: Erwin 4.0/3.5.2, Star schema and Snowflake schema.
Databases: Oracle 7.x/8i/9.x/10g, DB2 UDB, SQL Server 6.5/7.0, Teradata V2R5/R4/R3/R2, Netezza.
Internet: HTML, DHTML, ASP and JavaScript.
Languages: C, C#, HTML, Java, Visual BASIC, Shell Scripting, XML, XSL and PL/SQL.
Operating Systems: UNIX, Linux, Microsoft Windows 95/98/00/NT/XP.
Work Experience:
Target Inc., MN Sep 14 – Till Date
MicroStrategy Developer
Design and creating the mockups for the dashboards using third Party tools.
Worked closely with Business Analyst, Business Users and testers and coordinate with the onshore team.
Providing the support to the existing projects in production.
Created and modified the schema objects like Attributes, Facts, Views and Logical tables.
Created Advanced Filters, Prompts and Complex Metrics for the reports in Microstrategy.
Created complex reports and dashboards using 9.4.1.
Creating the reports based on Intelligence Cubes.
Creating ad-hoc reporting and providing the basic functionality training to the users.
Worked on Performance tuning the reports.
Used functions in MicroStrategy like Apply Simple whenever necessary.
Done the unit testing for the reports developed.
Coordinated with UAT and Testers in fixing the defects.
Coordinated with DBA and ETL Developers in creating the semantic objects.
Object Migration using the object manager between different environments.
Environment: MicroStrategy 9.4.1 (Architect, Desktop, Dash Boards), SQL Server, Teradata, Teradata SQL Assistant.
Safeway Inc., AZ
July 12 – July 14
Sr MicroStrategy Developer
Involved in collecting the business requirements and documenting the specifications.
Designing the Report specification for the requirement.
Created Advanced Filters, Prompts and Complex Metrics for the reports in Microstrategy.
Implemented Schema objects like Attributes, Facts, Views and transformation tables.
Created Reports and done unit testing.
Created KPI Dashboards and Scorecards.
Migrated the objects from Dev to QA server by creating Packages using Object manager.
Tested all the reports by running queries against the warehouse-using SQL Server developer. Also compared those queries with the MicroStrategy SQL engine generated queries.
Created Templates and custom drill maps.
Linking between the reports.
Created Custom groups and Consolidations.
Used functions in MicroStrategy like Apply Simple & Apply Comparison whenever necessary.
Proficient in database programming using SQL, PL/SQL for writing Stored Procedures, Triggers, Packages.
Environment: MicroStrategy 9.2.1 (Architect, Desktop, Dash Boards, Object Manager, Enterprise Manager), SQL Server, Oracle 11g, Oracle SQL Developer, OLAP.
Digi-Key Corporation, MN
Oct 11 – Apr 12
Sr MicroStrategy Developer
Responsibilities:
Worked on SSRS Migration project.
Converted all existing SSRS reports to MSTR 9.2.1.
Designed Microstrategy Schema and Involved in creating application objects Facts and Attributes for the requirement.
Created Advanced Filters, Prompts and Complex Metrics for the reports in MSTR by gathering the information from the store Procedures of the existing SSRS reports.
Developed reports similar to the existing reports by using Microstrategy functionality with small enhancements.
Developed documents using the reports to get the feel of the existing reports and functionality.
Created Templates and custom drill maps.
Created Edit links for drilling from one document to another.
Involved in migrating the documents to Test and Production.
Provided test scenarios for the testing team and done Data validation.
Created formatting conditions for the MSTR documents.
Provided Demo for the users to use the Microstrategy reports and given training on the enhancements.
Environment: MicroStrategy 9.2.1 (Architect, Desktop, Dash Boards, Object Manager, Enterprise Manager), SQL Server, Oracle 10g, Oracle SQL Developer, OLAP.
Nationwide Insurance, OH
May 11 – Sep 11
MicroStrategy Consultant
Responsibilities:
Architected and performed the report development for the MicroStrategy projects by creating facts, attributes, hierarchies, reports, filters, metrics and templates.
Lead MicroStrategy technical resource on a large Windows server migration.
Upgraded Narrowcast Server from 8x to 9x.
Worked on integrity manager to create baselines for Projects in Microstrategy Development and Production Environment.
Used to run weekly and monthly reports in Microstrategy and deliver them to the users.
Used Object manager to migrate objects from development to production environment and duplication of objects.
Experience in Upgrading MSTR 8.1 to MSTR 9.0.1.
Implemented MicroStrategy Schema Objects and Application Objects like Attributes, Hierarchies, Filters, and Metrics using MicroStrategy Desktop to create new and rebuild the reports of the existing environment in the new environment.
Involved in gathering the requirements for the reports to be created and transitioned into the new environment from the existing one.
Extensively worked in delivering reports through MicroStrategy Office. Delivered ICRO formatted and conditional formatted reports through MicroStrategy Office.
Created views, triggers, stored procedure in SQL Server and assisted SQL server DBAs and SQL server Administrators in making changes in the Database as required for the Microstrategy Environment.
Designed MicroStrategy Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop and Architect.
Created different objects that define Narrowcast Server services, including content Information Objects, Documents, Publications, Subscription Sets, and Schedules and Implemented proactive, personalized information delivery services using MicroStrategy Narrowcast Server.
Designed Dynamic Dashboards and Scorecards as per the business requirements.
Created transformations for YTD (Year to date), MTD (Month to date) analysis.
Customized reports, Documents and deployed them to MicroStrategy web.
Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the MicroStrategy SQL engine generated queries.
Created complex filters with advanced qualification involving ‘ApplySimple’ and ‘ApplyComparison’ functions.
Used Enterprise Manager for logging statistics and reporting purposes.
Developed Report Service Documents and dynamic dashboards using new and existing data sets.
Built Prompted reports and dashboards for the Planning and Strategy team using Complex Metrics, Advanced filters and Prompt filters.
Environment: MicroStrategy 9.0.1/8.1(Administrator, Architect, Desktop, Narrowcast Server, Dash Boards, Object Manager, Enterprise Manager), Oracle 10g, Toad, OLAP.
J.D. Power and Associates, CA
Sep 10 – April 11
MicroStrategy Developer/Administrator
Responsibilities:
Worked closely with Business Analysts & Financial Analysts to know the requirements.
Gathered all the upgrade requirements and documented all the requirements.
Planning, requirements analysis, design and development of new MicroStrategy 8.1/9.0 projects or enhancements of existing projects.
Interacted with business users extensively in gathering the requirements and translated them into report specifications for the MicroStrategy platform.
Developed multiple reports (Grid, Graph & freeform) for multiple projects.
Installed and configured Microstrategy in both QA and Production environments.
Worked on Database design of highly complex data transformations including Slowly Changing Dimensions.
Experienced in designing dynamic dashboards using Microstrategy Report Services.
performed the report development for the MicroStrategy projects by creating facts, attributes, hierarchies, reports, filters, metrics and templates.
Created complex reports using Advanced Prompts, Non- Aggregatable Metrics, Conditional Metrics, Transformation Metrics and Level Metrics.
Written and created SQL views in Teradata database.
Designed ETL process to extract data from SQL server2000 to Teradata and performing data scrubbing, restructuring and consolidation for Web reporting.
Upgraded the MicroStrategy Platform from 8.1 to 9.0
Used Object Manager to promote objects from Microstrategy development to QA & production environment.
Created Microstrategy Schema objects and Application objects using MicroStrategy Desktop .
Used functions in MicroStrategy like Apply Simple & Apply Comparison whenever necessary.
Extensively worked on MicroStrategy Administration that includes Intelligence Server administration, configuration of Memory settings, and Performance monitoring.
Implemented Narrowcast services for scheduling reports to business users & analysts.
Experienced in Business Objects report testing & integrity check of universes and migrating reports to MSTR.
Customized reports, Documents and deployed them to MicroStrategy web.
Set up of Metadata Structure using MicroStrategy Configuration Wizard.
Executed testing of all reports for the final deployment.
Designed data feeds to load Teradata from Oracle and vice-versa, using SQLPlus, and SQLLoader. Designed physical data mart schema optimized for Teradata.
Environment: MicroStrategy 9.0/8.1( Agent, Object Manager, WEB, Administrator, Enterprise Manager), Narrowcast Server, Dash Boards, SQL Server, Teradata V2R6, Informatica, Windows NT, Windows 2000 Professional.
Prolifics Corporation, Hyderabad, India
Jan 09 – Aug 10
Project Management Office (McKesson):
Maintain Repository: All projects (Proposals, Work plans, Status reports etc.)
Ensure projects are conducted in compliance to the standards and improvements to the project and management process.
Provide project updates & status reporting process.
Preparing standard and ad-hoc reports to PM’s, when needed.
Publishing metrics with respect to Service Level Agreement
Working on pre & post production metrics, improvising the DRE by providing on time metrics to the team.
Working on the Process Compliance.
Worked on monthly and annual budget reports.
Prolifics Corporation, Hyderabad, India
Sep 07 – Dec 08
ITSM Phoenix Production support (McKesson)
QA Analyst
Project description: ITSM phoenix is an agile model with name scrum for production support which ensures quick deliveries of the components releasing to the production.
Responsibilities:
Creating test model for the change components of the Release
Conducting daily status meetings with onsite coordinator and offshore team
Capturing actual hrs. and assigning the change requests for the changes to the resources
Creating test artifacts, test procedures based on the requirements
Configuring for the change components which requires customization
Status updates
Education: Bachelor’s degree in Computer Application & Masters in Business Administration.
Contact this candidate