| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Power Bi Project Management Arlington, TX Project Manager Management Dallas, TX Mechanical Engineer, Preventive Maintenance, Project Mgr., Nucle Fort Worth, TX Project Manager Roanoke, TX Machine Learning Power Bi Irving, TX Digital Marketing Project Management Dallas, TX Quality Assurance Power Bi Dallas, TX |
|
Click here or scroll down to respond to this candidateCandidate's Name
Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLESummary: Passionate Analyst with over 6+ years of experience skilled in SAS Applications, capable of leveraging advanced SQL and ETL processes for data transformation and system enhancements. Proven track record in building strong business relationships and delivering insightful reports to improve decision-making. Eager to utilize analytical skills to optimize productivity and communication for the company.SkillsDatabases: Oracle DB2, MySQL, SAS SPDS, Microsoft Excel, Teradata Programming Languages: SAS, SQL, Unix/Linux Shell Scripting, ORACLE PL/SQL Software: SAS Tools (Management Console, SAS Studio, SAS EG, SAS EMiner, SAS Viya), Microsoft Azure(Databricks, Web Portal), Power BI, TableauOperating Systems: Linux, Solaris, Windows, MAC OS Project Management: MS Office tools like Excel, MS Visio, PowerPoint Certification: SAS Certified Specialist: Base Programming Using SAS 9.4 26/Jun/2024 https://www.credly.com/badges/099cf13c-12a3-4031-a901-92848b8abccb/public_url RelatedExperience: Career Sabbatical and FreelancingTexas, USA Jan/2020 Current Moved to the United States to support my spouse, I have had the great fortune of focussing on my family. My passion for data analysis kept my urge to step up and solve real world problems. Stayed current on industry trends and learned to remain fully prepared for the next corporate challenge.o I updated myself with new SAS features (SAS Viya 4) (Certified in Base SAS Specialization) and created Dashboards with multiple pages and features like Hierarchy, slicer, Dual Axis Bar Charts, Multiple Reports on one Dashboard and their automated updation.o Completed Microsoft trainings and projects successfully in Azure Fundamentals, DataBricks, and Power BI.EXL Services, IndiaData Analyst Aug 2018 - Dec 2019 Expertise with SAS 9.4 and SAS Viya Environment, creating dashboards and reports using SAS datasets. Designed data extraction processes, automation, testing, and monitoring with SAS Management Console, crontab/Autosys on SAS Platform. Expertise in developing a complete automation process from extracting data from various data sources like SQL, ORACLE, and external networks drives like Web based (SharePoint) and Windows Isilon Shares and use them to create SAS Viya Dashboards Reports. Created various SAS Viya Reports for internal and external Teams which were highly appreciated and efficiently utilized by the higher management. Converted traditional excel VBA reports to the SAS Viya Dashboards where reports can be drilled down to multiple hierarchy levels successfully which increased the report delivery by 50% and saved business time. Good Experience of converting Reports to the Power BI using SAS Datasets. Enhanced performance of existing ETL processes and efficiently addressed fixes and enhancements. Proficiently authored SQL queries and debugged SAS programs, addressing issues effectively. Maintained strong business relationships through direct client interaction, understanding business problems, and delivering solutions promptly. Well familiar with Linux OS & commands, extracted data using SAS by utilizing Unix Commands. Automated data extraction from external APIs using SAS scripts and created comprehensive reports. Performed complex data analysis and report conversions, identifying key performance indicators (KPIs) using SAS tools like SAS DI and SAS EG. Extracted data from different sources (Flat files, Teradata, oracle DB, SPDS), transformed and restructured data and loaded it into data warehouses for reporting and analysis purposes. Practiced Waterfall, Agile, and Kanban frameworks using freeform boards to manage tasks and track progress. Created dashboards and reports for team management using ServiceNow. Involved in SDLC process elements like requirement gathering, designing, testing, and implementation with detailed documentation for Dev/Prod environments. Created SAS Stored Process programs to automate Excel workbook updates, incorporating external data queries. Utilized advanced Microsoft Excel to develop pivot tables and applied advanced functions such as HLOOKUP and VLOOKUP.TechMahindra Ltd, IndiaSAS Analyst (Synchrony Financial/GE Money) Aug 2015 - Jul 2018 Prepared, analysed and distributed monthly revenue report, quarterly historical performance report for various merchants like JCPenney, Wal-Mart etc. Experience of working on the ADHOC requests, gathering client requirements by having direct interaction with the clients and understanding Business problems. Migrated SAS Grid 9.3 and SAS Viya 3.3 to SAS grid 9.4 and SAS Viya 3.5 Environment and migrated users critical reports and data securely. Work with IT/Support teams and make them understand the SAS requirements and coordinate with them by running through Project timelines. Maintained project progress documentation (Run Book, Data Dictionary, Root cause analysis Issue trackers, etc.) for tracking and validation purposes. Created an extensive Artifact and Retail data SAS Stored Process to automate the data loading into the excel template for non-sas users. Provided extensive support in the code conversion from different tools and codes into SAS. Well familiar with the process to create a SAS Track with SAS for code enhancements. Experience in troubleshooting the SAS SQL Code issues and fix them efficiently. Automating the SAS jobs thorough SAS EG, Management Console for the Business Users for high efficiency. Led multiple projects simultaneously, ensuring timely delivery of results. Education:The Heritage Academy, Kolkata, West Bengal, India Aug/2012 Jun/2015 Bachelor of Computer Applications GPA: 7.67/10 |
