PROFESSIONAL SUMMARY:

• Master of Science in Information Systems major with strong problem solving, programming and critical thinking skills seek a Business Intelligence (BI) Developer / Data Analyst position.
• 8 + Years of experience as a Business Intelligence (BI) Developer / Data Analyst.
• Skillful in Descriptive (KPI, Dashboard), diagnostic (find the reasons - -> further action), predictive (building predictive model), and prescriptive analytics.
• Industry domain experience: Retail, Real Estate; Finance and Banking; Manufacturing/Automobiles, Transportation, Consulting, and industries.
• Skill in the Software Development Life Cycle including requirements, analysis, design, development, testing, deployment, and maintenance as per Waterfall and Agile (SCRUM) methodologies.
• Skillful in Sprint Grooming (create backlog), Sprint Planning (assign task), Daily Stand up (status), Sprint Review(showcase), Defect triage meeting, and retrospective Meetings
• Skillful in creating and maintaining the product backlog, writing requirements, EPICs, user stories, acceptance criteria, and test cases.
• Creating Reports, Dashboard, Visualization & data modeling using databases: Teradata, Hadoop, Oracle, and SQL Server.
• Creating complex reports, dashboards, and Visualization Using Cognos, Power BI Desktop, Tableau, and MicroStrategy
• Creating cubes based on the MS BI solution (MSAS) & developing reports by using Power BI Desktop, Excel template, and SSRS tool, also creating cubes on the MicroStrategy reporting tool.
• Creating Hadoop/Hive tables for reporting analysis and troubleshooting data quality issues.
• Developing data models and cubes to create reports, dashboards, Visualization using Hadoop/Hive
• Creating a mapping document for Hadoop/Hive tables based on the requirements
• Applied data science techniques: Prediction, classification, regression, clustering, and optimization

TECHNICAL SKILLS:

Reporting Tools: IBM Cognos Analytics; Business Objects; SAS; MicroStrategy; Tableau; RapidMiner; Hyperion Reporting Studio; MS Power BI Desktop; SSRS; WebFocusTechnology, Google Analytics

Metadata Modeling tools: Erwin; MSAS; Cognos Framework Manager

Databases: Oracle; MySQL; MS SQL Server; Teradata; Essbase; Hadoop; Google Big Query; DB2; MS Access; Hive

Programming Languages: MATLAB, Python; C++; C#; JAVA; MS Visual Basic

Scripting Languages: Shell Scripting; Perl; DAX; M code, JavaScript/JS; SQL; PL/SQL, R

Design Languages: UML; Business Process Diagram; Data Flow Diagram; MS Visio Page 1 Resume of Chiranjib Nath

Operating Systems: Microsoft Windows 7/XP/NT/Vista/2000; UNIX (Linux); Macintosh OSX

Networking Systems: TCP/IP; VOIP; SIP; Codec; IPv4; IPV6; FTP; HTTP; HTTPS; BGP

Software Applications: Microsoft Office; MS Project 2010; IBM Rational Requirements

Web Applications: Web 2.0; PHP; XML; HTML4/5/ XHTML; ADOBE; AEM

Testing Tools: QTP; HP Quality Center; Load Runner; Nomad

Batch Processing Tools: Autosys

Management/Collaboration Tools: ALM; TFS; Share Point

ETL Tools: Informatica 8.1; Data Stage 8.x; SSIS

Other Tools: MS Visual Studio 13/15/16; SmartView; FDMEE; DbVisualizer; Tortoise SVN; Beyond Compare 4

WORK EXPERIENCE:

Confidential, Austin, TX

Senior Business Intelligence Developer

Responsibilities:

• Leaded and executed Projects on MicroStrategy to profile data and build prototypes solutions, reports, and dashboards for displaying information based on business needs.
• Analyze business problems and issues using data from internal and external sources to provide insight to end-user/Business team and decision-makers.
• Created monthly Digital Commerce Analytics Roadmap and Priorities - walkthrough based on the active list and open it up for BI developers to contribute to modifying/add initiatives accordingly.
• Created document for report requirements, design, and architectures, also created best practices document for BI design standard, MicroStrategy standard.
• Managed Omnichannel classification/hierarchy data: Brick & Mortar (Customer shopping, 3rd party delivery - Instacart, Shift, Favor); Ecommerce orders: HEB.com (Make ready, Ship from store, Digital Delivery, Ship to Home, Central Market Hotline), HEB2U: Pickup, Delivery(Home Deliver -Favor, Home Deliver-HEB2U Lash, Home Delivery-HEB2U Pronto, Home Delivery-Shipt ); Apollo Bloom.
• Created the dossier, Documents, and Analytics Solution on MSTR Developer and web.
• Worked on gathering business requirements from the business partners and created Logical and Physical models.
• Planning and Analysis for Sales, Indirect spend, and Product data.
• Created Projects on MicroStrategy - Planning and Analysis (P&A) and eCommerce (aka Digital Commerce) data.
• Created MicroStrategy Schema objects - Attributes, Facts, Hierarchy, Transformations, Logical Views
• Created MicroStrategy Public objects - Metrics, Filters, Consolidations, and Groups, cubes, document, Grid and Graph reports, dashboards on MicroStrategy (MSTR) reporting tool.
• Performed Data blending for Source data and created Dossier based on the Business requirements.
• Created Aggregated Fact table based on Data Mart on MSTR Developer.
• Created Snowflake Schema, views on Teradata.
• Analyzed data for Indirect Spend, Department (Accounting, Floral, Pharmacy), Sales, and Product, location, time, Home Delivery, Cold Chain, Omnichannel.
• Performed Unit Testing after developing new artifacts - Grid reports, Documents and Dossiers.
• Performed Deployment activity - Creating RFC, IBOP.
• Supported Production issues and resolved in on time.
• Good understanding of MicroStrategy SQL engine and generation, Query engine, and Analytical engine.
• Analyzed the SQL for the Report Results
• Explored SQL for hierarchies, consolidations, custom groups on a report
• Analyzed SQL for conditional metrics, transformational metrics, also analyzed SQL for a report as filter
• Exploring the SQL changes for the report, Document and Dossier, also analyzed multi-pass SQL
• Written complex queries and views, based on report requirements. Page 2 Resume of Chiranjib Nath
• Optimized Joins between tables, also optimized the Dashboard/Dossier by changing the derived metrics replacing with Standalone metrics.
• Heavily worked on SQL - data profiling to troubleshoot production issues and new development.
• Provided ongoing reporting and subject area for H-E-B BI users, also provided guidance on areas for increased efficiency/automation and influenced others as subject matter expert on policies and practices.
• Designed architecture and foundational layout of reporting structure for connecting with traditional data warehouse: Teradata, Oracle, SQL Server, and big data cloud platform: AWS (Kinesis/AWS managed Kafka/AWS Lambda, AWS data bricks, S3, Athena); Azure (Azure Databricks, Azure Data Factory, Azure Event Hub, Azure Blob storage); Google Cloud (Google Analytics, Big Query, Google Storage, Pub sub)
• Assisted with defining data requirements, data collection, processing, cleaning, analysis, modeling, and visualization
• Designed and developed complex reports and dashboards for business requirements; recommends the best visualization representation for a solution; collaborates with Data
• Collaborated to understand project vision from the product owner; assisted in coordinating efforts with a cross-functional team of Partners
• Collaborated with the product owner and business analyst to understand reporting needs; applied understanding of the reporting tool; provided guidance on the feasibility to product owner to set stakeholder expectations
• Ensured access, security, and performance solutions are considered and thought through internal and external audiences
• Provided ongoing support for products built by the vertical scrum team and across verticals, also provided ongoing support for products developed for a business-facing data solution engineer
• Provided PowerPoint Presentation to showcase POC (Proof of Concept), current development, and final product to end-users and scrum team.

Confidential, Austin, TX

Software Development Associate (BI Data Analytics Developer)

Responsibilities:

• Played an integral role in creating the next-generation platform for Business Intelligence at GM.
• Worked on report development, performing requirements gathering, and testing.
• Created Cognos Reports, Dashboard, Visualization & Framework Package modeling using databases: Teradata, Hadoop, Oracle, and MS SQL Server, also created complex reports, dashboards, and Visualization Using Power BI Desktop and Tableau tools.
• Created cubes based on the MS BI solution (MSAS) & developed reports by using Power BI Desktop, Excel template, and SSRS tool, also created Hyperion Reports using Essbase multi-dimensional database Cubes.
• Reverse engineered MicroStrategy reports, Dashboards to the Cognos report, reverse engineered WebFocus Technology reports, Dashboards to the Cognos report, also reverse engineered Tableau reports, Dashboards to the Cognos report.
• Created a data dictionary using Erwin data modeling tool, also created Hadoop/Hive tables for reporting analysis and development
• Applied understanding of data/business solutions represented in the dashboards
• Designed architecture and foundational layout of reporting structure for every subject area, connecting with traditional data warehouse and big data cloud platform
• Worked in supporting the deployment activities in Test/MTT, CERT/MTC, and production/MTP by using the TFS tool.
• Worked in Operation support - root cause analysis, defect resolutions, also worked in supporting QA Phase.
• Worked in data analysis - deep-dive analysis to support production issues, also worked on Analyzing the reports using the Smart View tool.
• Responsible for analyzing the existing Data landscape at GM IT and work with the larger team in reconciling, enhancing, and creating streamlined data models and data integration strategies.
• Excellent collaborator - the ability to work cross-functionally.
• Involved in identifying 3rd party data for profiling, also developed tie-out reports for critical datasets and applications.
• Identify source systems and data-model.
• Financial and cost data analysis, Planning and Forecasting data analysis.
• Provided white-glove support and to business.

Confidential, Austin, TX

Software Engineer

Responsibilities:

• Applied Data Warehouse principles including Fact and Dimension Tables in a Star Schema model
• Written complex SQL Query
• Planning, Designing, execution, and reporting of tests and defects
• Tested both Type 1 and Type 2 Slowly Changing Dimension (SCD) Data Warehousing tables.
• Translated business requirements and/or report specifications into QA test cases.
• Validated Data Warehouse specific tenants such as business to surrogate key mapping,
• Validation of slowly changing dimension logic andtesting source to target data lineage
• Validated Fact and Dimension tables with Microsoft SQL Server 2008 utilizing data models and mapping documents
• Validated the BI report by using MicroStrategy tool, also Validated the ETL package by using SSIS tools.
• Performed data analysis and root cause analysis techniques
• Written Stored Procedures and triggers using t/SQL
• Validated reports and comparing them back to the source system.
• Extensive experience in creating Test Plans and Testing approaches in a Data Warehouse / Business Intelligence environment: planning, designing, management, execution and reporting of test cases and defects as well as the entire testing effort around a reporting/Data Warehouse
• Ensured that QA tasks are linked to Sprint Backlog items in
• TFS Develop test cases in TFS
• Leaded the testing team and being responsible for test planning and scheduling

Confidential, Irvine, CA

Software Engineer

Responsibilities:

• Written SQL query to validate the source to target data by using SQL server 2008 R2
• Validated the ETL package by using SSIS tools.
• Extensively used the Team Foundation Server (TFS) for team query, documentation, and task analysis
• Used Microsoft Test Manager for executing test cases.
• Followed Agile methodology, also analyzed business requirements to help drive and develop test cases.
• Developed test cases in TFS, also executed test cases and provide feedback to Project Management and Development.
• Captured test results in TFS, also, worked with QA automation engineers to drive and capture test cases in automated tests.
• Participated in sprint task breakdowns
• Recorded tasks in TFS, also ensured that QA tasks are linked to Sprint Backlog items in TFS
• Ensured that test cases are linked to QA tasks, also ensured that bugs reported are linked to test cases or QA tasks
• Ensured that progress is being captured in TFS, also collected and provided constructive feedback for Sprint retrospectives

Confidential, New York, NY

IT Engineer

Responsibilities:

• Provided front-line, end-user support for Windows and Macintosh clients to ensure proper computer operation so that end-users can accomplish business tasks.
• Diagnosed and resolved hardware, applications, and operating system problems
• Established network architectures, organized estimation of network traffic, and capacity to the network configurations that reduce costs and improve service.
• Extensively performed essential functions of Routers to provide a link between networks, to provide routing and delivery of voice, data between processes on systems from different networks; to provide these functions without requiring modification of underlying networking architecture
• Deployed, configured,maintained,andmonitoredactively network equipment
• Concentrated on the overall integrity of the network, server deployment, security, and ensuring that the network connectivity throughout a company’s LAN/WAN infrastructure
• Received, prioritized, documented, and actively resolved end-user phone/email help requests.
• Conducted email maintenance and archiving for Outlook and Entourage clients.
• Provided functional support to Data Analysis/Business Development team including the creation and execution of SQL scripts
• Performed installations, upgrades, backups, and recoveries
• Performed quality acceptance testing
• Performed software updates including OS, antivirus, and MS Office suite.
• Extensively contributed with vendors and common carriers and network engineering in the identification and resolution of complex network problems.
• Diagnosed and troubleshot basic printer problems, connectivity, and installations.