Programmer Analyst Resume

SUMMARY:

10 years of IT experience working as a Programmer Analyst, BI Developer/Advisor and Administrator. Well versed in analysis, design, development, testing, and implementation of various applications for several domains.
Successfully worked as a Senior BI Analyst, created various reports, involved in visualizing charts, and analyzing models. Hands on experience in identifying trends, and opportunities for improving policies, processes, and procedures which will in turn improve top and/or bottom line results.
Also worked as a Technical Lead, directed and mentored junior programmers and participated in department /company initiatives.
As a professional always been very keen to explore and creating datasets, creation of project specific macros and formats, performing data checks as needed, to ensure integrity and correctness/quality of data displays and to understand structure and content of data.
Involved in gathering data, transforming databases, performing research analysis against data warehouse, solving business problems / issues, interpreting data and publishing/ generating reports as well as performing QC/ validation of datasets, tables, listings, figures to verify the output.
Profound knowledge and strong experience in SAS Programming, extensive experience with Statistical Analysis, Data Capture, Data Cleaning, Data Quality, Data Management and Reporting.
Good working experience with EBI components such as Management Console, DI Studio, Enterprise Guide, OLAP Cube Studio, Information Map Studio, Microsoft Add - in, Stored Processes Server, Data flux,Web Reporting Studio and Information Delivery Portal.
In depth working knowledge with databases including ORACLE, MS SQL, TERADATA and MS Access, and good understanding of statistical techniques and analytical site forecasting methods, and proficient in ETL (extract, transformation and load techniques) process and Data quality tools.
Hands on experience in managing and administering a SAS Grid Environment and has the expertise to distribute SMC processes across the SAS Grid architecture and deployment. Also been involved in troubleshooting and supporting SAS Server environment.
Well versed with Microsoft Office tools, has proven organizational, time management and multi-tasking skills and ability to work independently as a good team player. Takes pride in delivering high quality work and advocate of collaborative and diverse environments

TECHNICAL SKILLS:

Statistical Software: SAS, Base SAS, SAS/ STAT, SAS/ SQL, SAS/ MACROS, SAS/ GRAPH, SAS/ ODS, SAS/ ACCESS, SAS/ Connect

Databases: Oracle, DB2, MS-Access, TERADATA, BIG DATA (Hadoop)

ETL Tools: Informatica Power Center 8.x/7.x, Toad, Business Objects, Crystal Reports, Tableau

Data Modeling: ERWIN, Star-Schema Modeling, Snowflake Modeling, FACT & Dimension Tables

Languages: SAS, SQL, PL/SQL, JAVA, C, C++, .Net

Software Packages: Microsoft Office 2000 (Word, Excel, PowerPoint,)

Internet: HTML, Java Script, VB Script, XML

Operating Systems: Windows 2000/2003/XP/Vista/Windows7, UNIX, DOS

PROFESSIONAL EXPERIENCE:

Confidential

Programmer Analyst

Responsibilities:

Successfully worked as a Senior BI Analyst, created various reports, involved in visualizing charts, and analyzing models. Hands on experience in identifying trends, and opportunities for improving policies, processes, and procedures which will in turn improve top and/or bottom line results.
Also worked as a Technical Lead, directed and mentored junior programmers and participated in department /company initiatives.
As a professional always been very keen to explore and creating datasets, creation of project specific macros and formats, performing data checks as needed, to ensure integrity and correctness/quality of data displays and to understand structure and content of data.
Involved in gathering data, transforming databases, performing research analysis against data warehouse, solving business problems / issues, interpreting data and publishing/ generating reports as well as performing QC/ validation of datasets, tables, listings, figures to verify the output.
Profound knowledge and strong experience in SAS Programming, extensive experience with Statistical Analysis, Data Capture, Data Cleaning, Data Quality, Data Management and Reporting.
Good working experience with EBI components such as Management Console, DI Studio, Enterprise Guide, OLAP Cube Studio, Information Map Studio, Microsoft Add - in, Stored Processes Server, Data flux,Web Reporting Studio and Information Delivery Portal.
In depth working knowledge with databases including ORACLE, MS SQL, TERADATA and MS Access, and good understanding of statistical techniques and analytical site forecasting methods, and proficient in ETL (extract, transformation and load techniques) process and Data quality tools.
Hands on experience in managing and administering a SAS Grid Environment and has the expertise to distribute SMC processes across the SAS Grid architecture and deployment. Also been involved in troubleshooting and supporting SAS Server environment.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship