Home

Rakshitha - SQL/ Data Analyst

[email protected]

Location: Dallas, Texas, USA

Relocation: Yes

Visa: H1B

Raksha SQL Developer/Data Analyst [email protected] +1(302)200-4070 PROFFESIONAL SUMMARY Over 8 years of professional experience specializing in data warehousing, data analytics and business intelligence across various industries. Expertise in managing and optimizing databases, including MS SQL Server, ORACLE, IBM Netezza, and cloud databases like AWS Athena, Amazon RedShift, and Azure SQL Database. Proficient in cloud environments, including Azure, AWS, GCP, and Snowflake, with strong experience in cloud-based data solutions and architecture. Proficiency in Microsoft Business Intelligence (MSBI) stack, encompassing SQL Server Integration Services (SSIS) for ETL, SQL Server Reporting Services (SSRS) for reporting, and SQL Server Analysis Services (SSAS) for cube data. Skilled in ETL development using SQL Server Integration Services (SSIS), Azure Data Factory (ADF), and Informatica, ensuring efficient data transformation and loading processes. Experienced in data modeling using Star/Snowflake schema design, Data Marts, relational and dimensional data modeling, slowly changing dimensions, and physical and logical data modeling. Advanced knowledge in reporting and data visualization tools such as SSRS, Power BI, Tableau, and MicroStrategy, delivering actionable insights to stakeholders. Extensive experience in data modeling, including the design of Fact & Dimension tables and multidimensional models. Strong command of DAX for data manipulation and creating calculated columns and measures in Power BI. Proficient in Python for data manipulation, analysis, and optimizing query performance in relational databases. Skilled in defining and tracking KPIs, conducting trend analysis, and implementing dynamic reporting with parameterized filters. Extensive experience in data profiling and ensuring data quality through thorough analysis and issue resolution. Proficient in using GIT for version control, ensuring efficient collaboration and streamlined code management. Familiar with software engineering principles and experienced in optimizing dataflows for efficient data processing. Strong experience in designing and managing data warehouses, applying best practices in data architecture, and optimizing performance across OLAP and OLTP environments. Demonstrated ability to deliver actionable insights and strategic recommendations to executive stakeholders, driving informed, data-driven decision-making across various business domains. Proven expertise in managing and executing complex data projects, balancing multiple priorities, and delivering high-quality results under tight deadlines with minimal supervision. Strong communication and collaboration skills, effectively working with cross-functional teams, including business analysts, data scientists, and IT professionals, to meet project goals and business needs. EDUCATIONAL DETAILS Master s in Electrical and Computer Engineering, NYIT New York-2016 TECHNICAL SKILLS Databases MS SQL Server 2016/2014, ORACLE, GCP Cloudera, AWS Athena, Amazon RedShift, IBM Netezza, Azure SQL Database Cloud Environments Azure, AWS, GCP, snowflake ETL-Tools SQL Server Integration Services (SSIS), Azure Data Factory (ADF), Informatica Reporting Tools SSRS 2016/2014/2012, Excel, MS Access, Tableau, Power BI, MicroStrategy Data Modeling Fact & Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional, and Multidimensional modeling Programming T-SQL, Dynamic SQL, MDX, XML, .NET, Java, Python, Unix, Shell Scripting, Spark Building Tools Maven, SBT, Git Version Controls Microsoft TFS and GIT HUB PROFESSIONAL EXPERIENCE Indeed, TX July 2022 Present Data Analyst/Developer Responsibilities: Utilizing Tableau, I'm crafting visually captivating dashboards and reports to analyze and present data effectively. We initially leveraged the power of Google Cloud Platform (GCP) services before orchestrating a seamless migration to AWS Athena, boosting performance and scalability. Applied advanced data modeling techniques to design efficient and flexible database structures. Managing version control and fostering collaborative development using Git to ensure seamless code integration and team alignment. Executing development tasks in Linux environments, I rely on Visual Studio Code to streamline coding workflows for optimal efficiency. Implementing optimization strategies to boost system performance and optimize resource utilization, ensuring seamless project execution. Applying Agile methodologies to project management practices, I'm fostering iterative development cycles and adaptability to changing requirements. Conducting SQL tuning activities to fine-tune database queries, enhancing overall system efficiency and responsiveness. Developing comprehensive planning and strategy initiatives to drive project execution and align with our business objectives effectively. Providing proactive production support, troubleshooting, and issue resolution to maintain system stability and reliability throughout the project lifecycle. Orchestrating the migration from GCP to AWS Athena, I'm ensuring a smooth transition with minimal disruption to ongoing operations. Conducting thorough data and root cause analysis, employing strong problem-solving and analytical thinking capabilities. Collaborating closely with cross-functional teams to gather requirements, prioritize development efforts, and ensure alignment with project goals. Facilitating effective communication and collaboration among team members to drive project success and achieve milestones efficiently. Conducting regular code reviews and quality assurance checks to maintain high code quality standards and adhere to best practices. Documenting processes, procedures, and best practices to facilitate knowledge sharing and ensure continuity in project execution. Caterpillar,NC May 2021 Jun 2022 SQL/ETL Developer Specialist 2 Responsibilities: Designed, developed, tested, and maintained complex ETL programs for an Enterprise Data Warehouse, ensuring efficient data extraction, transformation, and loading processes. Identified limitations and deficiencies within existing systems and processes, proposing methods for improvement. Collaborated with source systems to gain a comprehensive understanding of data flows and interacted with users to gather business requirements. Developed and evaluated an ETL strategy to efficiently populate data from multiple source systems, implementing SSIS packages for data messaging operations. Contributed to the design and implementation of metadata, ETL, and reporting components, ensuring robust testing and successful deployment. Demonstrated proficiency in using T-SQL to develop complex Stored Procedures, Triggers, Tables, Views, and User Functions, ensuring data integrity and relational database models. Utilized various transformations in Data Flow to categorize data for different departments. Applied expertise in SQL joins, subqueries, tracing, indexing strategies, and query tuning to enhance performance. Created Power BI reports and dashboards from multiple data sources, incorporating effective DAX formulas and expressions. Integrated Custom Visuals based on business requirements using Power BI desktop, designing data visualizations for analysis. Developed analysis reports and visualizations using DAX functions like table function, aggregation function, and iteration functions. Translated business processes into BI reporting and analysis solutions, enhancing data accessibility and user experience. Implemented conditional filters and Action links to filter data on dashboards with Power BI Desktop. Designed and developed reports according to Tableau and Power Map requirements, creating calculated columns and measures. Established multiple user roles and groups for end-users, providing row-level security and managing access. Developed Workspaces and content packs for business users to access developed reports, facilitating collaboration. Documented processes, procedures, and best practices to ensure knowledge sharing and continuity. Caliber Home Loans, TX Dec 2020 May 2021 SQL Developer Responsibilities: Gathered reporting requirements from clients and crafted exploratory reports for in-depth data analysis. Acquired expertise in managing financial and insurance data, central to the project's focus on insurance and financial data. Participated in the design of data architecture structures essential for supporting BI initiatives. Managed Power BI workspace and optimized report performance to ensure efficient operations. Collaborated with business stakeholders to identify BI needs, conduct data analysis, and develop BI reports and dashboards using Power BI. Developed Power BI reports and dashboards from diverse data sources, employing data blending techniques. Integrated custom visuals into Power BI desktop based on specific business requirements. Designed Power BI visualizations, utilizing a range of charts and graphs for effective data presentation. Scheduled and distributed reports through Cognos connection's schedule management feature. Developed parameterized reports, drill-down reports, and sub-reports to meet specific reporting requirements. Embedded Power BI reports onto SharePoint portal pages and managed access control for individual users using roles. Enhanced performance of Cognos Analytics reports and dashboards through optimization efforts. Implemented conditional filters and action links in Power BI Desktop to enhance interactivity. Utilized DAX queries to create computed columns and perform advanced data analysis in Power BI. Implemented complex business logic using T-SQL stored procedures, functions, views, and advanced query concepts. AIG, WI May 2020 Dec 2020 Information Security - Data Developer/Analyst Responsibilities: Developed a framework for generating daily ad hoc reports and extracts from enterprise data, streamlining reporting processes. Employed data modeling techniques, including Star/Snowflake Schema Design, Data Marts, and Dimensional Data Modeling, to support robust data architecture. Managed the ETL pipeline to source and deliver calculated ratio data from AWS to Datamart (SQL Server), ensuring data accuracy and consistency. Built reusable data ingestion and transformation frameworks using PySpark, optimizing data processing workflows. Analyzed traditional SQL scripts and converted them to Spark SQL (PySpark) for improved performance. Automated data sampling processes using Python scripts, ensuring data integrity through comprehensive validation checks. Created interactive reports in Power BI, incorporating various controls and filters for enhanced data visualization and analysis. Leveraged Power BI Desktop to develop data analysis reports from multiple data sources, enhancing insights into business data. Published Power BI reports to the Power BI Service and managed access control for individual users using roles. Utilized stored procedures, queries, triggers, functions, indexes, and user-defined functions in SQL for efficient data management. Implemented SSIS and T-SQL stored procedures for data transfer from source databases to staging areas and data warehouses, optimizing data movement and storage. Demonstrated expertise in SQL joins, subqueries, indexing strategies, and query tuning to enhance performance. Produced client deliverables, including detailed design documentation, configuration documentation, unit test plans, and training curriculum to ensure project success. Ryder Systems, MI Mar 2019 Apr 2020 BI Reporting Analyst Responsibilities: Conducted interview sessions to elicit business rules and requirements, documenting them effectively for project execution. Provided mock-up visuals to expedite the visualization of requirements and align with stakeholder expectations. Managed creation and modification of data visualizations in Power BI to meet evolving business needs. Conducted data analysis and profiling using T-SQL and data profiling tasks to ensure data quality and accuracy. Developed and maintained SSRS reporting for shift-wise incident queue reporting needs, facilitating timely decision-making. Actively participated in weekly SCRUM calls, contributing to agile project management and iterative development. Leveraged extensive knowledge of Business Intelligence and Data Warehousing concepts and methodologies to drive project success. Deployed and maintained SSAS solutions in production environments, including troubleshooting and resolving issues to ensure high availability. Supported ad-hoc data analysis requests by leveraging SSAS capabilities to provide quick and accurate responses to business inquiries. Designed and implemented various BI/Data Warehousing projects using Tableau, MicroStrategy, Alteryx, and other tools. Ernst & Young, GA Mar 2017 Dec 2018 ETL Developer Responsibilities: Created and scheduled reports using Business Objects, Crystal, and SSRS (MSBI Reporting Services) for comprehensive data analysis. Designed and developed complex OLAP cubes using SQL Server Analysis Services (SSAS) to enable efficient data analysis and reporting. Created and optimized dimensional models, including star and snowflake schemas, to support SSAS cubes and enhance query performance. Conducted performance tuning and optimization of SSAS cubes, including aggregations, partitions, and indexing, to ensure fast query response times. Scheduled and managed data refresh and processing operations for SSAS cubes to ensure up-to-date data availability for analysis. Implemented improved data collection procedures to enhance data accuracy and reliability. Demonstrated proficiency in all stages of the SDLC (Software Development Life Cycle), ensuring project success. Utilized SQL queries, including Static and Dynamic queries, to extract and manipulate data for reporting purposes. Employed statistical techniques to interpret data from primary and secondary sources, providing actionable insights. ICICI BANK, Hyderabad, India Aug 2014 Jan 2015 SQL-BI Developer Responsibilities: Developed and scheduled SSIS packages for efficient data extraction and transformation, ensuring data accuracy and integrity. Enhanced reporting capabilities by creating SSRS metadata reports for comprehensive data analysis. Designed OLAP applications in SQL Server, constructing multi-dimensional cubes for in-depth data analysis. Keywords: business intelligence active directory information technology microsoft Georgia Michigan North Carolina Texas Wisconsin