SUMMARY

• Certified Senior BI professional with 11 years of experience involving complete development life cycle of Business understanding, requirement gathering, analyzing, designing, developing and delivering business intelligence solutions using a wide range of BI offerings, tools, methodologies, to convert large datasets into actionable insights.
• Extensive experience with all phases of Software Development Life Cycle in different environments like Healthcare, Banking, Retails & Sales and Information Technology.
• Good working experience in implementing Data Warehousing BI Application Development using Cognos 8X,10X, Cognos Analytics 11X, Power BI, MSBI (SSIS, SSAS, SSRS) and Tableau v2018.1.
• Developing the Relational and Dimensional Model using Cognos Framework Manager and applied data level and object level securities.
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
• Hands on experience in different versions of MS SQL Server with Business Intelligence in SQL Server Analysis Services and Power BI Desktop and Services.
• Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Proficient in RDBMS and good programming experience in oracle11g /SQLServer2012 and DB2.
• Experience in Handling Heterogeneous data sources like SQL Server, Oracle, MY SQL, Hadoop, Excel, and CSV files using Power BI and Tableau.
• Responsible for creating SQL datasets for Power BI and Ad - hoc Reports.
• Performed data cleaning, data validation, and data analysis using Data Analysis Expressions (DAX).
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Handled change requests and provided support/maintenance for deployed projects.
• Worked on creating Azure Data Factory for moving and transforming the data.
• Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations.
• Connect Azure SQL DB to prepare Audit reports to monitor user usage in client network.

TECHNICAL SKILLS

BI Tools: Cognos8x,10X and Analytics, Tableau, Power BI, SSRS, SSAS and SSIS.

Databases: Oracle11g/10/9I, SQL Server 2012/2008, Teradata and IBM DB2.

Data Modeling: Star and Snowflake Schemas Modeling, Facts & Dimensions.

ETL Tools: Knowledge of Informatica 9, SSIS

Operating Systems: Windows and UNIX Server.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Cognos and Power BI Developer

Technologies: Cognos Analytics 11.0.6, Power BI Desktop, Power BI Services, SSIS, Oracle 11g and SQL Server 2012.

Responsibilities:

• Working closely with the business users to gather requirements.
• Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Developing the Relational and Dimensional Model using Cognos Framework Manager and applied data level and object level securities.
• Developing and Improved performance to Cognos Analytics Reports and Dashboards, which are taking longer time
• Migrated Reports and Dashboards from Cognos Analytics to Power BI.
• Using a Query Editor in power BI performed certain operations like Fetching data from different file.
• Working with import and direct query mode in Power BI, creating custom tables in the power BI.
• Merge Queries and Append Queries, remove columns and split columns, choosing required columns in the data.
• Working with different transformations, Applied steps in query editor.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Setting up Power BI Environment, creating app workspaces, publishing apps and setting up PowerBI Gateway.
• Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.
• Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
• Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
• Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps.
• Connected Azure Data Lake Store and created competitor reports to show growth.

Confidential, Cincinnati, OH

Sr. Cognos and Tableau Developer

Technologies: Cognos 10.2, Tableau Desktop, MotioCI, Oracle . SSIS, SSRS, Power BI Desktop

Responsibilities:

• Working closely with the business users to gather requirements.
• Developed Transformer models with alternate hierarchy dimensions, cube groups and drill through reports.
• Implemented best practices in ETL development and ability to load data into relational tables.
• Involved in development activities for data loads from Source systems to Staging tables.
• Working on bug fixing and enhancements to existing Cognos Analytics Reports in Report Studio and development.
• Migrated Reports and Dashboards from Cognos to Tableau and Power BI.
• Designing, developing, testing, and maintaining Tableau Reports and dashboards based on user requirements.
• Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
• Designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports, bar charts, water fall charts, score cards, Gantt charts, Bubble charts.
• Created Filters, Groups, Sets on Tableau Reports.
• Implemented data blending advanced visualizations in Tableau.
• Worked on Dual Axes, Individual Axes, and Blended Axes concepts while working with reports.
• Generated Dashboard with Quick Filters, Parameters and Sets.
• Generated Tableau dashboards with combination charts for clear understanding.
• Monitor the schedules and tasks on regular basis and create schedule job based on the user request.
• Worked on the incident tickets raised by the user based on their requirement.
• Migrated Reports and Dashboards from to Cognos Analytics Power BI.
• Using a Query Editor in power BI performed certain operations like Fetching data from different file.
• Working with import and direct query, creating custom table in the power BI.
• Merge Queries and Append Queries, remove columns and split columns, choosing required columns in the data.
• Working with different transformations, Applied steps in query editor.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Setting up Power BI Environment, creating app workspaces, publishing apps and setting up PowerBI Gateway.

Confidential

Cognos Developer

Technologies: Cognos 8.3 (Framework Manager and Transformer), SQL Server 2005, SSRS and SSIS.

Responsibilities:

• Installed cognos in distributed environments and involved in administration.
• Preparation of Metadata in Framework Manager by importing tables views and stored procedures from Database.
• Developed Framework Manager Models by following best practices and modified to in corporate the new data elements as per the business needs.
• Developed Framework Manager Models by following best practices and modified to in corporate the new data elements as per the business needs.
• Modified the Cognos Impromptu query definition (.iqd) files.
• Developed Complex Report Studio Reports and Dashboards using Lists, Crosstabs, charts, singleton, sections, Drill Through, Joins, Unions, Images and HTML applications using Report Studio.
• Published Reports in various Cognos Portal environments.
• Converted SSRS reports to Cognos.
• Gathered Requirements from the end users.
• Provided End User Training and Support.
• Involved in monitoring the dataflow and in optimizing the load times.

Confidential

Cognos Developer

Technologies: Cognos 8/8.1/8.2 (Framework Manager & Report Studio), Informatica PowerCenter 9.1.0, Teradata and Oracle.

Responsibilities:

• Involved in Gathering Requirements and the reporting issues from the business and end users.
• Installed Cognos in distributed environments and involved in administration.
• Preparation of Metadata in Framework Manager by importing tables views and stored procedures from Database.
• Developed Framework Manager Models by following best practices and modified to in corporate the new data elements as per the business needs.
• Migrated Reports cognos 8 to Cognos 8.1/8.2.
• Worked on report performance and query optimization.
• Implemented File System for bursting reports.
• Implemented external/ Internal triggering/ Watch list item for report studio reports
• Exported and importing packages for different Environments.
• Created complex dashboards as per client requirement.
• Involved in creating efficient multiple parameterized stored procedures for various kinds of reports.
• Performance tuning by analyzing and comparing the turnaround times between Pl/SQL and Cognos.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new reports.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.