Surya Jagini

About Surya Jagini

I am an accurate and data-driven Information Systems professional with over 3 years of experience in analyzing large datasets, managing and maintaining databases, exploring marketing data, creating statistical models, and coordinating the reporting process. My core expertise lies in database management systems, data sources, data warehouse, financial analysis, business intelligence & analytics, business operations, interpersonal skills, communication skills, IT project management reporting.With excellent analytical skills and the ability to work in a team environment, I have proven knowledge in expanding existing data collection and data delivery platforms. I am proficient in Python, R, SQL Server, Microsoft Office, Power BI, MS Access, Project Libre, Tableau, Pentaho, MicroStrategy, SAS, and Amazon Web Services.In my professional experience, I have worked as a Data Management Analyst (II) at PharMerica Professional Services, LLC, where I was responsible for collecting and analyzing data to evaluate business performance, productivity of collectors, etc. I managed and maintained large databases, completed budget analysis, and coordinated the reporting process while assisting in project management. I have a proven track record of creating geographic and disruptive analyses to support the sale of new business, leveraging market data and industry trends to inform strategic decision-making.I have also worked as a Graduate Assistant in Database Management Systems at the University of Colorado, where I analyzed database needs and developed a long-term strategy for data improvement. I established policies and procedures related to data security and integrity and monitored and limited database access as needed. I built, maintained, and assured the validity of data files and panels contained in the university data management system and collaborated in the design, maintenance, and implementation of the creation of the database system.In my free time, I have also completed several data-related projects, including Sentimental Analysis Using R, building a Database on Indian Premier League, and developing a Tableau Project. I am always looking for new and exciting opportunities to grow and enhance my skills in the data management field.

Experience

1. Bi Analyst

   PharMerica

   Feb 2020 — Present · Longmont, CO, US

   Experienced Data Management Analyst skilled in recording, interpreting, and analyzing data in a fast-paced environment. Detail-oriented Data Analysis and Business Intelligence with a proven record of success Substantial analytical, technical and problem-solving skills combined with a strong cross-functional understanding of business processes and information technology.1. Collecting and analyzing data to evaluate business performance, employee satisfaction, and customerexperience.2. Managing and maintaining large databases, completed the budget analysis, and coordinated the reporting process, and assisted in project management.3. Helps coordinate improved cross-functional activity by utilizing analytics and key measurements to identify opportunities to eliminate waste in processes.4. Resolving any database process – increasing the efficiency of data collection.5. Updating the code of the macro as per requirement which will be printing a one-page BCN page, putting batch information into BCN, and printing pre-post with one-page BCN.6. Utilizing excel functionality to gather, compile and analyze data from pivot tables and create graphs/charts.7. Providing analysis on any claims data discrepancies in reports or dashboards.8. Generated executive-level Tableau dashboards with quick/context/global filters, parameters, and calculated fields which will help management to understand the data.9. Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and Joins in the databases to implement business rules.10. Connect closely with analysts from other functions to collaborate on analytical standards.11. Performing detailed analysis on key trends and findings, summarized and presented findings to managers.12. Extracting, cleaning, transforming, and validating model data with the purpose of understanding or making conclusions from the data for decision-making purposes.

Education

• University of Colorado Denver

  Master of Science - MS