SHAIK SIMRAN KAUKAB

*** ******* *****, *********, ** 21227 443-***-****

adkj4n@r.postjobfree.com www.linkedin.com/in/simrankaukab-shaik-612b0775 github: https://github.com/simranshaik601?tab=repositories EDUCATION:

University of Maryland Baltimore County (UMBC) Baltimore, MD MS, Information Systems,gpa:3.478 May 2021

Prasad V Potluri Siddhartha Institute of Technology Vijayawada, India B. Tech, Electronics and Communication Engineering, gpa :3.5 May 2014 TECHNICAL SKILLS:

Languages: C, JAVA (Basics),SQL, PL/SQL, UNIX

General: MS-Excel, MS-Word, Ms-Power point, Lucid Chart Tools/Methodology: Informatica, Selenium(basics), ALM, QTP(basics), Sybase, Toad (Agility Workbench), Putty, Talend Open Studio for ETL and Big Data, Power BI, Tableau,Oracle 11g database, SQL developer,Oracle Data Integrator., HP ALM,XML, Data bricks spark,R (basics),NumPy, pandas, Beautiful soup, Python, Mongo DB, Aws Ec2,Alteryx,Qlik Sense,Cassandra,Neo4j,Greenplum,Netezza,Hive,Hadoop,WEKA explorer. Other Skills: Mat lab, Crontab, WIN SCP, MPEG,STREAMCLIP1.9.2,Agile methodology, Test Cases creation using HP Application Life Cycle Manager during testing of Test Suite,, Data Modelling, Quantitative skills

,predictive analysis algorithms, Star and snow flake schemas implementation. PROFESSIONAL EXPERIENCE:

Systems Engineer at Tata Consultancy Services (March 2015 to July 2019) ILP(Initial Learning Program) Training: March 2015-July 2015

• Manual Testing of a website of a bank by writing test cases of different bank member roles with their accessibility to website and executing test cases in HP ALM, raising defects, fixing them. Testing the performance of different users on the application can say performance load testing using QTP and automation of scripts and writing scripts in selenium WebDriver where used Selenium IDE initially to record the tasks to get understanding of code and its functional working.

Informatica Administrator : Client: Credit Suisse Pvt Ltd

• Deployment (Static and Dynamically) and troubleshoot workflows, Relational Connection Creations, User access management, Migration of Unix Scripts using bash shell scripting, parameter files due to version enhancements of informatica, Data Profiling, created macros for applications after recording the required pattern for functioning and creation of pivot tables,reports creation, vlookup’s usage during testing different datasets, usage of merge sheets into a single query by using excel.

• Enhanced Unix scripts according to client changing requirements like hostname, port name factors,shell scripts to automate the workflows along with java required experience. ETL developer and ETL Tester: Client: Qualcomm,General Electric, Ericsson, Archer Daniels Midland Company

• Migration and Replication of data from oracle(source) to Greenplum(target) database with proper, Snapshot capture,Parent-child Dependency jobs development and testing of reports in Tableau against ETL jobs data using talend components like created mappings in TALEND, Big Data Testing in Talend for data migration.

• Microsoft Azure Data lake pipelines data fully loaded to ETL data integrator after incremental data is ingested in landing zone using hive scripts through push approach and reports created in Power BI compared against Data lake data according to different scenarios like to check against a specific id same data presence is in report and helped architects and developers closely with data modelling across whole software development lifecycle and also post implementation phase.

• Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.

• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning. Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

• Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.

• Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with the help of endpoints.

• Data Tested for reducing data redundancy, count, null, aggregate validations, Defect tracking and rectification with testers and developers collaboration after data ingestion.

• Interacted with Business Analyst in Qualcomm to test SAP BO reports where developers directly report to BA and also had Team meetings with Technical Architect to discuss about test cases scenarios, architecture of development where my job was to test the test cases functionality efficiently after framing Test Case Scenarios after observing the Data.

• Tested payment flows where inputs like files are created, messages queued in app watch where request is tagged and response is recorded in Informatica Data B2B exchange console, regression testing done for FRP US enhanced application in process of attaining automated process without manual intervention. Tableau Developer and Analyst: Client: General Electric and Arched Daniel Midland Company

• Worked on Turbines data set from General Electric Power department towards dashboards implementation of data, metric insights reports converted to dashboards, adhoc report generation, Prepared for tracking KPIs and provided weekly and monthly mock run status reports, generated tableau combination charts, used hierarchies, filters, calculated fields, sets and parameters usage in KPIs and other rich graphic visualization dashboard creations for predictive analysis according to scenario requirements definition. Text Mining Developer – Data Analyst Intern: Client: CMS June 2020-August 2020 Company: Index Analytics LLC, Baltimore Maryland .

• Created an automated data base by web scraping the html and css tags as per the case study excel sheet so as to validate the manual entry with the existing database, assessed the research questions as required and printed them if necessary by toggling through different hyperlinks to get the requirement satisfied in an automated way by extracting them into a csv, mined the decision memos in the site as required in python using a beautiful soup library.

• Interacted with clients,stakeholders and required IT development directly to propose the ensured processes and systems to verify they meet the desired needs.

• Performed requirement analysis and had interaction with cross functional teams like support and HR team for few developments and also to know whether their applications are affected if in case.

• For code please: https://github.com/simranshaik601/web-scraping Advanced Database Projects: August 2019-December 2019

• Designing of database for Course Schedule Management System for different 16 features using PL/SQL procedures,functions,triggers,Sql Queries for different members of courses where members are student and faculty.

https://github.com/simranshaik601/is620_course_schedule_management_system Client Server Communication: January 2020-May 2020

• Have designed a code for client and server communication of vector clock using python Socket API and RPC Implementations.

• Converting Permissioned into Permission less Blockchain and addressing if any issues associasted literature review.

COVID 19 data Analysis: January 2020- May 2020

• Analyzed the COVID 19 Data for live extract and observed the map distribution, global analysis, region wise breakdown,cumulative by country,deaths and lives cumulative forecast, deaths and live daily forecast, daily by country, cumulative by country with help of a project team. published a dashboard in tableau public . Link:

https://public.tableau.com/profile/simran.kaukb.shaik#!/vizhome/COVID- 19AnalysesPredictionsbyRohanRamVaswani/COVID-19Dashboard

• Created Sample database, executed queries to demonstrate on tools of Neo4j,Cassandra,MongoDB, AWS ec2 instance, with help of iowa liquor dataset visualized with help of Qlik Sense reports,created KPI’s, visualized the decision .

Systems and Information Integration: Aug 2020- Dec 2020

• Integration of 4 local databases and their metadata by creating an integration layer known as metadata layer using PL/SQL programming using Tokenizer, passing global query as string, sub queries automatically generated by system, temporary tables holding the subquery results, producing consolidated results of the local databases later. Data Mining : Aug 2020- Dec 2020

• Creating different Machine Learning models using algorithms like support Vector Machine, Logistic Regression, Naïve Bayes, Association Rule Mining, Random Forest, Decision Tree, K-Nearest Neighbour and evaluating the performance efficiency of models as algorithms are designated under supervised and unsupervised algorithms where dataset is UCI Machine Learning Repository’s HCV Dataset. Project and Systems Engineering Management: Aug 2020- Dec 2020

• For Health Management and Records Reporting System Statement preparing deliverables like Life Cycle Acquisition Process (LCAP), CDRL deliverables table defining the deliverables each control account manager

(CAM), Work Breakdown Structure, Project Schedule integrating WBS items as summary tasks which are allocated to CAMs.

CERTIFICATIONS:

• Tableau 10 essential training,LinkedIn learning

• Power BI essential Training,SQL Data Reporting and Analysis,LinkedIn Learning

• Tableau Analyst Badge issued by Tableau software .

• Data Analytics Fundamentals by AWS

Contact this candidate