Data Analyst Software Development

Name: Chandrashekar N

Email: ******.*****@*****.***

Ph: +1-603-***-****

LinkedIn: www.linkedin.com/in/chandra-shekar-88831b211

Summary

Around 7 Years of experience as a Business Data Analyst with extensive experience in stages of SDLC, database management, and data visualization. Strong exposure to securities trading in capital markets and CRM and manufacturing domains.

Expertise in Software Development Lifecycle (SDLC), Project Lifecycle, Business Process Modelling (BPM), Software Development Methodologies including Waterfall, Spiral, and Agile with SCRUM process.

Proficient in analyzing and modeling business processes, gathering comprehensive business requirements, designing databases, and developing robust web-based and client/server applications.

Experience with Tableau server for granting access permissions for specific purposes to the required teams and scheduling timely extracts for dashboards using Tableau server.

Excellent communication skills and proven ability to work with business customers and technical teams, as well as independently with minimal supervision.

Technical Skills:

Database Operations: SQL, MYSQL, NZSQL, Oracle, MS Access

Programming Languages: Shell, Python, XML, HTML, Machine Learning

User Interface Design Tools: MS Visio

Methodologies: Waterfall, Agile, RUP, Jira, Scrum

Project Management Tools: MS Project, MS Office (Word, Advance Excel, PowerPoint, Access), SWOT analysis, Critical Thinking, Data Cleaning

Data Visualization Tools: Tableau, Powe BI, Qlik, SPSS Modeler

Data Mining Models: Clustering, NLP, KNN, Linear, Decision Trees, Regression, XML

Governance and Compliance: Data Governance, Trade Surveillance Knowledge, Data Security and Privacy

Cloud Computing: AWS, Azure

Business Process Improvement: Business Process Improvement methodologies (Lean, Six Sigma)

Soft Skills: Critical Thinking and Problem Solving, Stakeholder Management

Experience:

Client: Techmind Software Solutions LLC, Nashua- NH, USA Feb 2025 - to present

Role: Business Data Analyst

Responsibilities:

Designed and developed Power BI reports and interactive dashboards to track parts manufacturing and cross- referencing processes, enabling stakeholders to make informed decisions.

Collaborated with cross-functional teams, including IT, production, and business users, to gather requirements and provide necessary data extracts using SQL and Hadoop.

Utilized Hadoop’s ecosystem (multiple schemas and tables) to pull and process production data for report generation.

Provided support for Oracle E-Business Suite, resolving production issues such as missing part details by extracting specific data or troubleshooting errors.

Worked with Syndigo and PIM systems to manage and track parts information, ensuring accurate cross- referencing and streamlined operations.

Partnered with financial and compliance teams to align parts-manufacturing data processes with internal controls that meet industry auditing standards.

Developed visual dashboards to track parts and inventory metrics, leveraging banking-style KPI transparency to streamline internal audit reviews.

Managed day-to-day incident tickets in ServiceNow, prioritizing compliance-related hardware/software issues for prompt resolution.

Monitored data quality and flagged anomalies in real-time, coordinating with technical teams to align with the organization’s technology roadmap.

Prepared and maintained SOPs and training materials for end-users to effectively utilize reporting tools and systems.

Automated repetitive data preparation tasks using advanced Excel functions, including VBA macros.

Analyzed parts production data to identify trends and discrepancies, presenting insights to leadership for improved inventory and supply chain management.

Enhanced data accuracy by developing quality checks and validation processes for reports derived from multiple data sources.

Streamlined reporting workflows by creating reusable templates in Power BI, reducing turnaround time for report generation.

Assisted in the design and implementation of new features for the PIM system to improve tracking of parts and cross-referencing capabilities.

Acted as a liaison between business and technical teams, ensuring seamless communication and delivery of solutions in a fast-paced manufacturing environment.

Resolved critical production issues by extracting and validating data efficiently, minimizing downtime for business users.

Improved reporting processes by designing scalable Power BI solutions that integrated data from Oracle and Hadoop.

Increased reporting efficiency by 30% through the development of automated workflows and reusable templates.

Client: IT trail blazers LLC., Hyderabad, India August 2022- July 2023

Role: Business Data Analyst

Responsibilities:

Designed and developed Power-BI visualization and interactive dashboards based on business requirements.

Extensive experience in using Tableau for analyzing data sources from Excel/ MySQL, Oracle, SQL server.

Modified existing Tableau reports and collaborated with business to integrate new data points to streamline workflow and company processes.

Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL Azure etc.

Designed and developed interactive Power BI dashboards to visualize key workforce metrics, enabling leadership to make informed

strategic decisions.

Integrated data from various sources (SQL Server, Oracle) into Power BI, providing a consolidated view of workforce performance indicators.

Collaborated with cross-functional teams to analyze workforce metrics, facilitating data-driven decisions that support staffing in the capital markets sector.

Analyzed workforce data to support regulatory reporting processes, ensuring accuracy and timeliness in submission to relevant regulatory bodies.

Performed Data cleaning and normalization along with profiling to ensure Data Quality.

Collaborated with the data engineering team to deploy data visualization solutions on AWS, ensuring scalability and efficiency.

Utilized AWS services such as S3 for data storage and EC2 for running analytical workloads, enhancing the data analysis process.

Gave permissions to specified Business users to access the Report using Tableau server.

Managed and analyzed large datasets using Excel, utilizing Pivot Tables and VLOOKUP functions to derive insights and present data summaries to stakeholders.

Developed complex Excel models to track and analyze workforce data, ensuring accuracy in data-driven decision-making processes.

Designed and Developed reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Coordinated Phased Data Migration process to handle large and complex volumes of data and address dashboard reporting capabilities.

Supervised and collaborated with data coordinators and other team members to provide technical support and end-user training on the developed applications.

Created detailed documentation for Power BI dashboards and data sources, ensuring clarity and accessibility for technical and non-technical stakeholders.

Client: Horizonsoftch Inc., Hyderabad, India March 2017 - July 2022

Role: Business Data Analyst

Responsibilities:

Developed Microsoft Power BI Dash boards to showcase the result of data analysis from the database.

Generated dash boards in Power BI Desktop and Power BI Service using the latest data visualization features.

Involved in defining the source to target data mappings, business rules and data definitions.

Integrated custom visuals based on business requirements using Tableau desktop for better clarity of information.

Designed and implemented data integration modules for Extract/Transform /Load (ETL)functions.

Experience with various ETL, data ware housing tools and concepts.

Used data analysis techniques to validate business rules and identify low quality missing data in the existing Amgen enterprise data warehouse (EDW).

Led requirements gathering sessions using Agile methodologies to facilitate efficient communication between business and technical teams, ensuring that project deliverables were met within timelines.

Documented business processes, data mapping, and ETL procedures, ensuring all stakeholders had access to clear and concise information on project requirements and methodologies.

Integrated and transformed data from various sources (e.g., SQL Server, Oracle) into Power BI, creating visually impactful dashboards that provide key insights into workforce performance metrics.

Conducted in-depth data analysis to identify trends, gaps, and opportunities, presenting actionable insights to stakeholders to support

Conducted workforce data analysis using Excel, providing management with insights into staffing needs and resource allocation.

Created detailed process maps in Visio to document business processes, enabling clear communication of workflows and identification of bottlenecks.

Worked closely with business units to redesign processes, ensuring alignment with organizational goals.

Developed and maintained Tableau dashboards to track and report on key performance indicators (KPIs) related to workforce management.

Customized Tableau visualizations based on stakeholder requirements, ensuring clear and actionable insights.

Education:

MBA (Information Technology Management) from Rivier University, NH, - Dec 2024

B. Com (Computer Applications) from Osmania University, Hyderabad- India, July-2018

Contact this candidate