SUMMARY

• IT Project Management (ITPM) certified with 6+ Years of professional experience in IT - Gathering Requirements, Data Analysis, Design, Development and Testing with extensive work in Analytical tools and Data warehousing technologies.
• 4.5+ years in System Analysis, configuration, testing and 1.5 years in Software Development.
• Extensive experience of providing IT services in Defined Benefit and Health Care domain
• Proficient user of Base SAS, MACRO and PROCS such as REPORT, TABULATE, FREQ, MEANS, SORT, PRINT, SUMMERY, UNIVARIATE, TRANSPOSE.
• Hands-on experience in using Amazon Web Services ( AWS) like EC2, EBS, RDS, S3, Glacier etc.
• Skilled in using Informatica Power Center for ( ETL ) Extraction, Load of data and Transformations
• Strong knowledge of Data warehouse concepts - Star Schema, Snowflake and Slowly Changing Dimensions.
• Good understanding of Normalization/De-normalization, Database design, Entity-Relationship (E-R) model and application-oriented design.
• Extensive experience in writing SQL Queries for Data analysis, Data mapping specification, Data Migration, Data Mining and creating Data Dictionaries.
• Good understanding of Statistical Modeling and Machine Learning techniques (Linear, Logistics, Decision Trees, Neural Networks, Regression) in Forecasting/ Predictive Analytics,
• Hands-on experience with JCL, TSO, ISPF on IBM mainframe .
• Created LINUX scripts for monitoring the file systems and delivering automated alert mails.
• Skilled in MS VISIO to create Business Process Models, Use Case diagrams and Activity Diagrams to visualize data flow.
• Strong experience in Waterfall methodologies and Agile methodologies with Scrum and Kanban.
• Experience in Tableau BI reporting tools & Tableau Dashboards Developments
• Skilled in Excel VLOOKUP formula development and Pivot Table generation
• Experience in Software Testing like integration/smoke/system/regression/performance/user acceptance Testing.
• Experienced in using Project Management tools- Jira and Maestro.
• Strong problem-solving, planning, analytical, team-building, communication and project management skills.

TECHNICAL SKILLS

• Analytical/ Data Warehousing Products: SAS Enterprise Guide, SAS Enterprise Miner, SAS 9.3/9.4, Informatica Power center 9.x
• Databases: IBM DB2, SQL Server, MySQL, Oracle, MongoDB
• ERP Software: SAP R/4, SAP Lumira for Data Visualization
• Operating System: RedHat Linux, CentOS, Z/OS, WINDOWS
• Languages: PHP, JavaScript, jQuery, Shell Scripting (bash), PowerShell, XML, AJAX, HTML, CSS, Python, C#, Java, VB.net and ASP.net

PROFESSIONAL EXPERIENCE

System Analyst

Confidential

Responsibilities:

• Responsible for analyzing the needs of the business and its customers and coming up with solutions to business problems for clients Fiat Chrysler Automobiles and Confidential Controls International.
• Identified, analyzed and translated business requirements into technical specifications.
• Analyzed the feasibility of implementing Business requirements (to-be) and inspecting the existing environment (as-is) to create Process model and Analysis Artifacts.
• Interacted with client and worked with the Business Implementation Managers and Business Operation Managers to clarify the requirements and analysis artifacts.
• Created Test Strategies (covering scope, risk, responsibility, timelines, resource, deployment, exit/entry criteria).
• Daily activities included programming, debugging, data manipulation and report generation in SAS.
• Developed and implemented stored procedures, views, functions and triggers
• Created Tableau visualizations and dashboards using Tableau Desktop
• Created and debugged SAS members in Windows, Linux as well as Mainframe environment.
• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time
• Handled migration processes from development to production environment using Control-M scheduler .
• Optimized queries by creating various clustered, Non-Clustered indexes and indexed views.

Senior/Setup Configuration Analyst

Confidential

Responsibilities:

• Extensively used SAS Tools and SAS procedures such as FREQ, REPORT, SORT, PRINT, SUMMARY and MEANS for data/system analysis, statistical analysis and producing Adhoc/Monthly reports.
• Analyze issues/defects and debug /Configure the proprietary System to fix system defect or complete a client request/change.
• Assist project manager in determining the scope and Work Breakdown Structure ( WBS ) to meet project milestones.
• Experience in extracting, manipulating data and creating Data Sets from various sources like Excel, flat files etc. which are further used as source datasets for report generating programs.
• Modify existing datasets using SET, MERGE SORT, function s and conditional statements.
• Used the SAS Access engine to retrieve the data into SAS from the database.
• Responsible for troubleshooting and delivering outputs on PROD/DEV/QA environments.
• Evaluated data mining request requirements and developed queries for the requests using SQL/SAS.
• Set up client calls for requirement analysis and layout discussions
• Performed Unit Testing and Database Testing using Aon-Hewitt's proprietary tools.

Software Developer

Confidential

Responsibilities:

• Responsible for creating and maintaining web-applications.
• Worked on UI development for web applications using HTML, CSS, Adobe Flash and back-end using PHP, Database Management using MySQL.
• Responsible for creating and maintaining web-based software tools used by Engineering Network Services Staff and the Engineering Department.
• Design, code and maintain new and existing web-based applications and tools
• Conduct data-analysis and research, interfacing with the university’s database using MySQL .
• Writing SQL querie s to fetch data from the database (MySQL) using PHP and Ajax to send the data dynamically to the jQuery and JavaScript at the client side.
• Wrote SQL queries, Stored Procedures, Functions and Views.
• Monitor performance and optimize SQL queries for maximum efficiency.
• Write bash scripts to manage users and groups accounts, passwords, permissions, logging, disk space usage and processes.
• Develop applications from scratch, implemented feature enhancements and update the applications written in ColdFusion to PHP and JavaScript.