SUMMARY

• Highly skilled professional with 8+ years of IT experience in various roles as a Business Intelligence Consultant and Technology Analyst
• Over 8+ years of experience using MicroStrategy, DataStage, Oracle PL/SQL, Netezza, Redshift, MS BI, Power BI, Tableau, UNIX
• Certified in CPD, CRD, CDMD, CPA and CES in MicroStrategy 9.4.x.
• Experience leading and managing teams in development, architecture and maintaining migrating environments
• Experience working with both Agile and Waterfall methodologies
• Extensively worked in creating and integrating MicroStrategy Reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse
• Experience in development of polished Dossiers, Dashboard, Report Service Document and Scorecard Reports according to user requirements and scheduled them in different delivery modes like Excel and PDF to email or FTP locations.
• System Optimization, performance monitoring and tuning experience in MicroStrategy Business Intelligence environment
• Expertise in using Pass - Through functions like ApplySimple and ApplyComparison to develop complex Filters and Transformations
• Optimizing report generation with respect to very large databases and experience in working with a variety of Databases like Netezza, Oracle, SQL Server, Amazon Redshift
• Excellent experience configuring VLDB properties to fine-tune reports
• Expertise in building Cubes for supporting reports and dashboards as well as developing ad-hoc reports
• In-depth understanding of fundamental data warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Data marts, Security and deployment, FACT and Dimensional tables, Logical and Physical data modeling.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Created DataStage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Good experience in using Talend Data Integration/Big Data Integration / Talend Data Quality.
• Experience in ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed data conversions from wide variety of source systems including Netezza, Oracle, DB2, SQL server and non-relational sources like flat files, XML and Mainframe files.
• Experience in creating mappings in TALEND using tMap, tJoin, tReplicate, tParallelize, tConvertType, tflowtoIterate, tAggregate, tSortRow, tFlowMeter, tLogCatcher, tRowGenerator, tNormalize, tDenormalize, tSetGlobalVar, tHashInput, tHashOutput, tJava, tJavarow, tAggregateRow, tWarn, tLogCatcher, tMysqlScd, tFilter, tGlobalmap, tDie etc.
• Strong knowledge and understanding of SQL and experience in writing SQL queries.
• Problem solver with a passion for technology; skilled in grasping the big picture and applying appropriate, practical technology / mix of technologies that meet business needs while minimizing risks:
• Excellent skills in writing Business requirements specification, System requirements specifications, Systems design specification, Requirement traceability matrix (RTM), Test specifications
• Proficient in analyzing and creating Use Cases, Business Processes, Business workflow Diagrams, and Data Flow Diagrams
• Experience in conducting GAP analysis, ROI analysis, SWOT analysis and Cost benefit analysis
• Capable of rapidly learning new technologies and processes, and successfully applying them to projects and operations.
• Excellent verbal and written communication skills with interpersonal and analytical skills
• Well-Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.
• Directed cross-functional & cultural teams using interactive & motivational leadership; acknowledged for leading, coaching & mentoring 5-8 team members to achieve resource wise productivity
• A forward-thinking person with strong communication, analytical & organizational skills

TECHNICAL SKILLS

BI Tools: MicroStrategy 2019 Update2,10.x,9.x/8.x, Tableau Suite, SSIS, SSRS, SSAS, POWER BI, Qlikview

Databases: Oracle 11g,12c, Netezza, SQL Server 2008/2012, DB2, Redshift

Programming Languages: PL/SQL, UNIX Shell Script, R, Python

Methodologies: SDLC/ Waterfall, Agile Model

Other Tools: Informatica, DataStage, Pentaho 7.1, ETL Tools, MS Suite, Visual Studio, SQL Plus, Toad, WebSphere, Apache Tomcat, Microsoft IIS

PROFESSIONAL EXPERIENCE

Confidential

MicroStrategy Consultant/ Lead

Responsibilities:

• Architect the data model in MicroStrategy from scratch based.
• Migrate OBIEE reports into MicroStrategy
• Participated in establishing processes and best practices around development standards, version control, quality control, deployment, maintenance and change management
• Coordinated with Clients in the installation, troubleshooting and adoption of reports
• Requirement analysis and detailed functional design for various developments in the MicroStrategy applications
• Worked with data warehouse and ETL teams on designing flexible and scalable data models for ROLAP across all enterprise data assets
• Designed and developed Dashboards and Dossiers with MicroStrategy for various products and services
• Worked on localizing the MicroStrategy project to different languages using Repository Translation Wizard
• Worked with MicroStrategy technical support as technical Liaison to propose enhancements and troubleshoot for MicroStrategy releases
• Developed MicroStrategy Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, reports) for
• Created metric combinations for enabling the end users to generate their own customized reports from the given datasets and objects
• Resolved reporting issues and increase the performance by optimizing VLDB properties and using OLAP services at different levels
• Maintained MicroStrategy Intelligence Server, Web and Administrator. Performed various administration tasks - User Management, Cache Management, Scheduling, OLAP Cube Refresh, Security roles, Access Control Lists ACLs
• Involved in implementing security layers and Single sign on feature for MicroStrategy with other applications
• Created project definitions for various I-Server’s using MicroStrategy configuration wizard and automation file
• Used command manager for creating scripts to modify user permissions, cache, projects, database instances and several configurations
• Used Object Manager to migrate objects from various environments

Environment: MicroStrategy v 2019 Update2, Oracle, Windows Server 2008/2012, AIX, Oracle Data Integrator, OBIEE

Confidential

Business Intelligence Consultant

Responsibilities:

• Re engineered the deployment process of MicroStrategy to clients
• Participated in establishing processes and best practices around development standards, version control, quality control, deployment, maintenance and change management
• Coordinated with Clients in the installation, troubleshooting and adoption of reports
• Requirement analysis and detailed functional design for various developments in the MicroStrategy applications
• Worked with data warehouse and ETL teams on designing flexible and scalable data models for ROLAP across all enterprise data assets
• Designed and developed Dashboards with MicroStrategy for various products and services
• Worked on localizing the MicroStrategy project to different languages using Repository Translation Wizard
• Worked with MicroStrategy technical support as technical Liaison to propose enhancements and troubleshoot for MicroStrategy releases
• Developed MicroStrategy Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, reports) for
• Created metric combinations for enabling the end users to generate their own customized reports from the given datasets and objects
• Resolved reporting issues and increase the performance by optimizing VLDB properties and using OLAP services at different levels
• Maintained MicroStrategy Intelligence Server, Web and Administrator. Performed various administration tasks - User Management, Cache Management, Scheduling, OLAP Cube Refresh, Security roles, Access Control Lists ACLs
• Involved in implementing security layers and Single sign on feature for MicroStrategy with other applications
• Created project definitions for various I-Server’s using MicroStrategy configuration wizard and automation file
• Used command manager for creating scripts to modify user permissions, cache, projects, database instances and several configurations
• Used Object Manager to migrate objects from various environments
• Created Tableau dashboards using LOD’s, Parameters, Context filters, groups and derived fields within the tool.
• Applied row level security for Tableau dashboards.
• Created ETL jobs for data model required for MicroStrategy development using Informatica components

Environment: MicroStrategy v 2019 Update2 on AWS, Tableau, Red Shift, Microsoft SQL Server 2012, Atlassian, Windows Server 2008/2012, AIX, Informatica

Confidential

MicroStrategy and DataStage Lead

Responsibilities:

• Coordinated with Offshore team in understanding requirements and responsible for product deliveries to the user groups
• Collaborated with Business Analyst and driven power and non-power user adoption with best design practices which include building reports, documents and dashboards for delivery to end users
• Partnered with BI Development, Production Support, & Power Users to resolve issues or problems
• Implemented MicroStrategy security model supporting enterprise reporting
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect
• Created best practices for BI delivery life cycle, including customer roll out and user adoption monitoring
• Provided direction and support and assisted in the training of less experienced staff to orient them and increase their understanding of more complex MicroStrategy development
• Created new training content, forum, quick tips, discussion group feedback & FAQs; is the single point of contact to Customer Power User groups
• Security implementation
• Developed and Supported different ETL jobs in DataStage using different components like transformation, lookup, XML parser, source and target connector stages etc.
• Developed and maintained Unix scripts that are used in DataStage jobs.
• Developed Talend ETL jobs to migrate the data from flat files to database. Created ETL/Talend jobs both design and code to process data to target databases.
• Created Talend Mappings to populate the data into dimensions and fact tables.
• Involved in migration of jobs from DataStage to Talend.

Environment: MicroStrategy v 9.4,10.3, DataStage 11.x, Netezza, DB2, UNIX, Mainframe, SharePoint, Talend