PROFESSIONAL SUMMARY:

• Over 12+ years of IT industry experience in leading, analysis, design, and development in Data warehousing and 7+ years ’ experience in IBM India Pvt. Ltd worked with different sectors like Insurance, Manufacturing, Logistics, Retail, Telecom.
• Migration SQL server database from on prim to AZURE Cloud
• From unstructured data to dashboard with Azure Data Factory and Data Lake
• Copying On - Premise SQL Server Data to Azure Data Lake
• Creating a Pipeline using Author-Tab
• Trained in Tableau10.1 and developed dashboard in Confidential
• Developed Dashboards in Power BI using DAX Queries using sum and Sumx functions
• Developed power apps canvas in Power apps 1.0.5 in services
• Worked on Service now and Remedy ticketing tool and developed high-level tickets dashboard from remedy in BI tool.
• Build jobs with help of Powershell/Shell scripting
• Build jobs with help of Powershell
• Recently trained in Docker and Kubernatees and MicroStrategy
• Power BI Dashboard link below end of my resume

TECHNICAL SKILLS:

Business Intelligence: Cognos 11.0.5/Cognos Tm1 10.1/10.2 BI Tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection),Framework Manager, PowerBI/ tableau10.1/BIG DATA/Hadoop/AWS/Data Analaysis Python for DAG

ETL: Cognos Data Manager 8.3,Dynamic Cubes/SAP HANA

RDBMS: My SQL, Oracle 8i/9i/10g, DB2

Operating System: Windows

Languages: C, C++, C#, Java, Visual Basic 6.0, VC ++, SQL, PL/SQL, XML

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Power BI Developer

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Worked with DAX Queries
• Developed star schema in relationship editor and saves file AS PBIX from excel source and publish the dashboard online
• Developed Power BI model used for financial reporting and Headcount.
• Designed and documented the entire Architecture of Power BI and tableau
• Build apps by using power APPS and Installed on Prem gateway connecting on prom datasource and cloud
• Published power bi reports and dashboards into Sharepoint
• Created and manager env and common data services databases
• Developed new apps from power bi market place in power bi Service
• Optimization, Database Maintenance Plans and Database Consistency Checking Database commands
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services cubes& Reporting Services.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed, monitored and deployed SSIS packages.
• Created document for Self-Service Deployment and Execution process for SSIS packages.
• Constructed OLTP and OLAP Databases.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.

Environment: POWER BI/Cognos11.0.7/TM1 10.2.2/AutoSys, Tableau10.5/Teradata/SAP/Snow Flake/Air Flow/S3/POWER BI/ Power apps 10.0.5

Confidential, Phoenix - AZ

Sr.BI Developer

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle DB, and SQL).
• Developed cubes in SSAS and power play transformer
• Performed Loading operation of historical data using full load and incremental load into enterprise Data Warehouse.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files,
• XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Used For each loop container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Design and develop dynamic advanced T-SQL, PL/SQL, MDX query, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in
• SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.

Environment: Cognos11&10.2/PowerplayTransformer/Control-M,Tableau/PowerBI/Cognos/ Report Studio, Framework Manager 10.2/ Oracle SQL Developer/cognos TM1 10.2.2/Windows server 2012 R2/Service Now

Confidential, Amelia - OH

Sr.BI Developer

• TM1 10.2.1 Installation in windows and env and Developed cubes Manually in TM1 Architect and also developed the cubes through TI process and developed subsets for dimesions and alias and picklist
• Involved in design of of reports based on requirements in congas BI Space and TM1
• Involved 24/7 support of TM1 PROCESS and scheduling through chores and developing rules and feeders in TM1
• Migrated reports from Cognos IQD to Cognos 10.2.1 Environment

Environment: Cognos Tm110.2/Cognos10.2, Cognos/Report Studio, Framework Manager 10.2/ Oracle SQL Developer/Remedy

Confidential, Los Angeles - CA

Sr. Cognos Developer

• Developed KPI dashboard for Confidential stake holders in cognos 10.2.2 by using report studio and active reports and Interacted with business Users and did enhancements
• Worked with different types charts and design as per requirement
• Implemented traffic lights into dash board

Environment: Cognos Express 10.2.2, Cognos/Report Studio, My SQL Frame Work Manager, Active Reports

Confidential, Los Ángeles

BI Developer

• It’s an migration project from inet soft to cognos. Developed 68 reports in cognos using report studio and framework manager model 10.2.
• Developed reports like list, cascading, burst, Drill Through in Report Studio
• Involved in Testing and improving Report Performance

Environment: Cognos Tm1 10.2/ Active Forms/ Rave, Cognos 10.2, Cognos/ Report StudioConfidential

Cognos Developer

• Confidential Germany is leading Telecom provider in Germany. The Confidential Germany business has been outsourced to India in terms of Development and testing
• Worked closely with business users while gathering requirements
• Developed Active Reports in Cognos Report Studio 10.2.1
• Effort Analysis and Effort Forecasting
• Status calls within the project and deliverables
• Designed the effort analysis tracker
• Incident Mgmt. and monitor incidents/tickets in the project were used in various Analysis Studio reports

Environment: Cognos 10/ Cognos Data Manager 8.4, DB2, SQL, Clear Quest

Confidential

Cognos Developer

• Played a major role (From Requirement gathering until Deployment - Full life cycle development) in building the following Cognos DMR-Dimensionally Modeled Relational -DMR FM Packages and Relational Reports and support Business users for the IBM Cognos reports, dashboards and applications
• To support Business users for the IBM Cognos reports, dashboards and applications To clarify Business users with respect to documented features and troubleshoot issues when Business users are experiencing unexpected results
• To monitor IBM Cognos reports, dashboards and application performance and to apply optimization techniques, Effort Analysis and Effort Forecasting, Status calls within the project

Environment: Cognos 8 BI, Cognos/Report Studio, Cognos TM1, Power Play Transformer, Query Studio, Analysis studio, Frame Work Manager, DB2, SQLConfidential

BI Developer

• Developed and Creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, reports) Architected the project and created all the necessary schema, application and configuration objects.
• Involved in partitioning the tables, indexes and management of the schema objects
• Involved in optimization of code and tuning queries for performance

Environment: Cognos Data Manager 8.4, DB2, Clear Quest, Cognos 8