We provide IT Staff Augmentation Services!

Data Analytics Specialist Resume

SUMMARY

  • Well - rounded, hands-on, innovative individual having 5 years of experience in Information technology with over 3 years in Data Analytics committed to solving business problems and improving skills
  • Experienced with full software development life cycle, object-oriented programming, database design, and agile methodologies.
  • Experience with Object-Oriented Programming (OOP) concepts using Python, JAVA.
  • Utilize Microsoft excel and access to manipulate, cleanse, and process large data set.
  • Proficient in SQL databases MS SQL and Oracle.
  • Experience in writing Subqueries, Stored Procedures, Triggers, and Functions on MS SQL and Oracle database.
  • Experience in Data Transformation, Metadata, Data Dictionary, Data Loading, Modelling, and Performance Tuning.
  • Experience implementing dashboards, data visualization, and analytics using Tableau desktop.
  • Experience in implementation of Data Cleanup Procedures, Transformation, Scripts, Stored Procedures, and execution of Test plans for loading the data successfully into Targets.
  • Good Knowledge of web services using SOAP and REST protocols.
  • Good knowledge of Version Control Software - SVN, GitHub.
  • Good knowledge of Apache Spark for using Big Data
  • Hands-on experience with bug tracking tools JIRA and IBM Peregrine.
  • Good Knowledge of SDLC, Waterfall, Test-driven development (TDD), and Agile/Scrum Methodologies.
  • Skilled in debugging/troubleshooting issues in complex applications.
  • Excellent team player with strong Communication and interpersonal skills, problem solving skills and positive attitude.

TECHNICAL SKILLS

Programing languages: Python, JAVA, R, SQL

Databases: Microsoft SQL Server, OracleData Visualization Tableau and Power BI

Source Control: SVN, CVS, Git, GitHub

IDE’s: NetBeans, Eclipse, PyCharm, Sublime Text

Bug Tracking Tools: Bugzilla and JIRA

Web Technologies: HTML, XML, CSS, JavaScript

Big Data Processing: Apache Spark (PySpark)

Machine Learning: Linear and Logistic Regression Algorithms, Random Forest, Cluster Analysis, K-Means Clustering, Support Vector machines, Time Series Modeling, Chi-Squared analysis and A/B tests Methods, Predictive Analytics

PROFESSIONAL EXPERIENCE

Confidential

Data Analytics Specialist

Responsibilities:

  • Was among the top 1% percent of the students who will be chosen as a Graduate Research Assistant at Confidential effectively handling more 400 Undergraduate Students each semester working towards their continuous improvement.
  • Developed Python scripts, to extract the student information and performed regression analysis to document the findings.
  • Developed Machine learning models and python scripts for analysis and real time data prediction and visualizing the data points.
  • Created a high-level ER model for the student database, used the ER model to build the database and populate it with the data.
  • Tested Database by writing queries in MS SQL to extract the data from the created database, writing SQL queries to extract data.
  • Present the final outcomes and findings to the assessment committee and working with other department counter parts for documenting.
  • Performed data analysis using SQL, provided quality assurance of imported data, working with quality assurance analyst if necessary.
  • Assessed tests and implemented new or upgraded software and assisting with strategic decisions on new systems.
  • Managed master data, including creation, updates, and deletion.
  • Provided technical expertise on data storage structures, data mining, data mapping and data cleansing.
  • Commissioning and decommissioning of data sets.
  • Processing confidential data and information according to guidelines.
  • Developed Tableau reports and analysis.
  • Managing and designing the reporting environment, including data sources, security, and metadata.
  • Supporting the data warehouse in identifying and revising reporting requirements.
  • Supporting initiatives for data integrity and normalization.

Confidential

Business Data Analyst

Responsibilities:

  • Collaborated with various business teams to document and translate business requirements to technical user stories using Agile methodology, decreasing gaps in requirements and requirements gathering time by 50%
  • Created Tableau dashboards to report key metrics, using action filters, parameters and calculated fields and communicated business insights and recommendations to stakeholders
  • Improved the process of predicting credit defaulters for a bank, by introducing Logistic regression algorithm in Python
  • Gathered large structured and unstructured data from multiple sources to perform data analysis using Python, making datasets usable for visualization reporting and analytical modeling
  • Conducted data mining techniques and retrieval of data by applying statistical and mathematical analyses, identifying trends and solving analytical problems
  • Worked on writing complex SQL queries in performing Data analysis using window functions, joins, improving performance by creating partitioned tables.
  • Analyzed 15 years of bank trade data using Oracle RDBMS and formulated an action plan for project migration and decommission, completing business sign off before deadline
  • Led a team of 8 people in migrating and decommissioning a module of Java applications
  • Wrote Subqueries, Stored Procedures, Triggers, Cursors, and Functions on MySQL and PostgreSQL database.
  • Developed tools using Python, Shell scripting, XML to automate some of the menial tasks. Interfacing with supervisors, artists, systems administrators and production to ensure production deadlines are met.
  • Involved in defining the source to target data mappings, business rules, and data definitions.
  • Created Data Mapping Document, for defining data flow between data source and target, with business rules.
  • Developed tools using Python, Power Shell scripting, XML to automate some of the menial tasks.
  • Knowledge of software engineering best practices and development life cycles, including coding standards, code reviews, source control, build processes, testing, and operations.
  • Experience working with Agile and Test-Driven development within the software development lifecycle (SDLC).
  • Participated in grooming backlog, daily scrums, retrospectives, and sprint reviews with product owner and technology partners to meet release timelines and adding business value.

Software Engineer

Confidential

Responsibilities:

  • Headed 35-member onsite and offshore team in client training and compliance to support client engagement
  • Automated job monitoring and ad hoc report generation using complex SQL queries and JAVA, improving application performance and reducing 80 manual hours/ month
  • Supervised new hires on technical knowledge to develop business logic coding, reducing training effort by 50 hours/month
  • Optimized a major issue that was causing financial reconciliation for the bank using SQL and Core JAVA, saving $100,000 for the client

Hire Now