SUMMARY

• 4 years of experience in Analysis, Design, Implementation of Business Applications using SQL Server, Oracle Relational Databases Management systems.
• Extensive working experience in Normalization and De - Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default) and indexes.
• Participated actively in all phases of SDLC including Requirement Gathering, DesigningData Models, Development, Testing, Go live and Post Go Live Support.
• Experience wif various databases like Oracle, SQL Server, Teradata and DB2.
• Strong experience in DataAnalysis, DataProfiling, DataCleansing & Quality,DataMigration, Data Integration.
• Good knowledge about the Teradata Architecture and Concepts.
• Extensive experience in Stored Procedures, Triggers, Functions, Cursors, Views, Materialize Views and Analytical Functions.
• Experience in dataload/export utilities like BTEQ, Fast Load, Multi Load, Fast Export and UNIX/Mainframes environments.
• Good knowledge in SSIS packages to load thedatafrom Text File to staging server and then from staging server to Datawarehouse.
• Involved in SSIS packages to extract datafrom different sources like SQL server 2008, MS Excel, MS Access, transform and then load into Dimension and Fact tables inDataWarehouse using SSIS.
• Created SQL queries to validate datatransformation and ETL Loading.
• Experience in metadata clean-up and processing at regular intervals for better quality of data.
• Good knowledge on Pivot Table reports in Microsoft Excel.
• Experience in Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Experience in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Involved in generating Drill down, Drill through reports using Local and Global Variables, Expressions and Filters in SSRS.
• Experience in creating the reports basing on the requirements using SSRS
• Good knowledge in SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of datasources.
• Good understanding of Relational Database Design, OLAP concepts and methodologies.
• Involved in complete Administration tasks on UNIX (SUN Solaris, Red Hat Linux, and AIX) and documentation for the projects executed.
• Installation and support of 3rd party software systems on UNIX like Web Servers, Application Servers, Middleware and Databases.
• Experience in programming for generating graphs, datalistings and tables using datasteps, procedures, SQL.

TECHNICAL SKILLS

Programming Languages: R, Python, Java, C#.

Databases: MySQL, T-SQL, NoSQL(MongoDB), MS Access.

Operating Systems: Linux, Windows, MacOS, Unix.

Tools: Pentaho, Informatica, MS SQL Server, Tableau, Eclipse, AWS - EC2, MS Visio, Optimizely.

Web Technologies: HTML, CSS, JavaScript, JQuery, AJAX, Bootstrap.

Functional Skills: SDLC, Methodologies - Agile,Waterfall, Critical thinking, Team Management.

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Data Analyst

Responsibilities:

• Analyze all the business strategies, rules and file formats to design maps and transformations in Informatica.
• Collected and documented business requests and effectively converted into implementable solutions.
• Developed and published well-organized, accurate, and insightful Tableau reports/dashboards/Storyline wif different charts and advanced functions to support strategic decisions.
• Maintained Tableau dashboards and datasources on the Tableau server.
• Accurately and effectively analyzed data, patterns, and trends wif Tableau and Excel.
• Developed and optimized complex SQL queries and ensured optimal performance using joins, grouping, aggregation, sub queries, and views to retrieve datafrom relational databases.
• Developed logical and physical models in the relational database.
• Managed the integrity, structure, and organization of datato maximize its value and accuracy wif queries.
• Extracted datafrom various datasources, and transformed, cleaned, validated, and loaded datainto Oracle databases, flat files, spread sheets, Salesforce, and other destinations.
• Tracked and documenteddataissues in the systems and coordinated wif clients to resolve the issues.
• Translation of business requirements and technical designs into test specifications and test cases.
• Worked on continuously updating the information in the Avature of the university relations team.
• Conducted data analysis to research root cause for data gaps, discrepancies and derive insights using analysis.

Environment: Teradata, Tableau, MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer, UNICA 6.4, Erwin Tool, Informatica, Salesforce.

Confidential, Milpitas, CA

Data Analyst

Responsibilities:

• Clustered customers wif R & defined improvement projects as redistributed resources and saved 11% of the company’s budget and Participate in requirement gathering and analysis.
• Work wif users to identify the most appropriate source of record and profile the datarequired for sales and service.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the business/transformation rules applied for sales and service data.
• Define the list codes and code conversions between the source systems and the datamart.
• Worked wif internal architects and, assisting in the development of current and target statedata architectures.
• Involved in defining the source to target datamappings, business rules, business and data definitions.
• Worked wif BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests wif the requestor and coordinate wif the development and testing team.
• Coordinated meetings wif vendors to define requirements and system interaction agreement documentation between client and vendor system.
• Created SSIS packages to load the datafrom Text File to staging server and then from staging server to Datawarehouse.
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and datacleaning in staging server to maintain child and parent relationship.
• Deliver reports and ad-hoc analysis focused in the area of client behavior and profiling using SAS, SQL and Excel.
• Designed SSIS packages to extract datafrom different sources like SQL server 2008, MS Excel, MS Access, transform and then load into Dimension and Fact tables in DataWarehouse using SSIS.
• Developed SSIS packages using for each loop in Control Flow to process all excel files wifin folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction logdatainto the SQL table.

Environment: Teradata, Tableau, MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer, UNICA 6.4, Erwin Tool, SSIS & SSRS.

Confidential, Somerset, NJ

Data Analyst

Responsibilities:

• Designed and developed various analytical reports in Tableau Desktop, expert in quantitative problem solving.
• Expert in Design, build and automate dashboards and custom reports.
• Participated on the risk management teams to onboard tranche 1- 10 departments.
• Responsible for datavalidation across the risk management systems.
• Created requirements document wif end-to-end traceability.
• Generating responsiveness, turnaround time related metrics and performance dashboards to the management on a weekly basis.
• Weekly project status reporting, tracking milestones, issues, risks and action items.
• Experience in DataModeling, Integration, Analysis, Reporting and Visualization.
• Coordinated wif team members to create impactful analyses and forward-thinking strategies.
• Communicate wif executives and managerial staff regarding datafindings and potential new-technologies, dataentry, dataauditing, creating datareports & monitoring all datafor accuracy.
• Demonstrate exposure/experience in dataprofiling, cleansing and datawrangling techniques.
• Excellence in datastructures, programming and Demonstrated experience in understanding of complex data. Solid understanding of big dataecosystem and ability to acquire/ingest data.
• Strong Analytical problem-solving skills and involved in SWOT analysis.
• Involved in creating various documents such as Use case, Business and Functional Requirement Specifications. Well versed in Project Management skills like MS Project for project planning and scheduling. Able to process new dataquickly and communicate it effectively to lay individuals.
• Created SSIS packages to load data into Data Warehouse using tasks like Execute SQL Task, data flow task and expert in designing of ETL (Extract, Transform, and Load) flows.

Environment: Tableau 9.0, SQL Server 2012/2014, Windows XP, Microsoft Project 2000, HTML, R, Linear Regression, MS Excel, MS PowerPoint, MS Visio and MS Outlook.

Confidential, Somerset, NJ

Data Analyst

Responsibilities:

• Developed and Tested web pages and also used visualization for Graphs, Charts, etc. and worked wif SQL scripts, Map Reduce, query optimization and operated wif data schemas to manipulate data for data loads and extracts.
• Used MS Excel to maintain the research database and generated spreadsheets, pivot tables and dashboards, developed and initiated more efficient datacollection procedures.
• Built Databases, Stored Procedures, Packages, Table structures and Views, writing queries using SQL Server. Designed UML diagrams and work flow diagrams by using MS Visio.
• Involved in creating database objects like tables, procedures, triggers and functions to maintain dataefficiently. Participated and facilitated discussions through JAD sessions, conference calls and business workshops held to plan business strategy.
• Hands on experience in using project management, modeling tools such as MS Project, MS Visio, Microsoft Office Suite.
• Conducted research tests and performed analysis to determine best solutions to improve product quality.
• Created visually impactful dashboards in Excel and Tableau for datareporting by using pivot tables.
• Mastered the ability to design and deploy rich Graphic visualizations wif Drill Down and Drop Down menu option and Parameters using Tableau.
• Responsible for extracting, compiling and tracking datafor making reports weekly & monthly basis.
• Effectively identified errors and issues involving data flow discrepancies, improved effectively.

Environment: MS Excel, MS Office 2007, SQL Server 2012/2008R2, Visual Studio 2010, Tableau

Confidential

System Configuration Specialist

Responsibilities:

• Code, test, debug, document and implement Informatica maps following ETL procedure.
• Identified sources and performed dataprofiling on the identified sources.
• Prepared specification documents (BRD / FRD), based on business rules given by Business.
• Prepared Business Process and DataProcess Models using MS Visio.
• Involved in DataMigration between Teradata, MS SQL server, DB2 and Oracle.
• Involved in dataload/export utilities like BTEQ, Fast Load, Multi Load, Fast Export and UNIX/Mainframes environments.
• Extensive experience in Stored Procedures, Triggers, Functions, Cursors, Views, Materialize Views and Analytical Functions.
• Knowledge in developing SAS Programs using SAS/Base, SAS/macro and SAS/SQL.
• Involved in Installing Firmware Upgrades, kernel patches, systems configuration, performance tuning on Unix systems.
• Involved in troubleshooting of UNIX technical problems received through e-mail and Clarify Ticketing Tool, Backup solutions according to the SOP & SLA. Generating reports, Preparing Quality Documentations & uploading to VSS tool.
• Validateddatain the report against the business databy running the SQL queries against the Teradata and Oracle.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of datasources.
• Experience in creating the reports basing on the requirements using SSRS.
• Created Parameterized, Cascaded, Drill-down, and Drill-through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Participated in daily Scrum meetings to review the status of sprint backlogs and sprint review meetings to discuss the accomplishments and issues faced.
• Worked on metadata clean-up and processing at regular intervals for better quality ofdata.
• Extract, summarize and compile datafor required external reporting, Including Weekly Metadata Reports for the DataIntegrity.
• Created a database of the frequently faced issues& launched troubleshooting webpage, reducing problem by 40%

Environment: Teradata15.10, PL/SQL, UNIX, MS SQL Server 2012, SSIS & SSRS, MS Office, SCRUM, Microsoft Visio, Erwin Tool, Tableau.

Confidential

Business Data Analyst

Responsibilities:

• Clustered customers wif R & defined improvement projects as redistributed resources and saved 11% of the company’s budget and Participate in requirement gathering and analysis.
• Collaborate wif clients to extract &transform the confidential projects data for firm’s analytical engines usage and automated the generation of data quality and reports using tableau, cutting down total analysis time by 75%.
• Designed, developed, and maintained tables, views, and other SQL server database objects.
• Performed ETL and maintained data quality against relational database.
• Generated Tableau dashboards/reports wif the medical and research datafrom various sources.
• Troubleshot Tableau Server issues and explained Tableau Server functionality to users.
• Successfully analyzed datawif Excel, Power BI, and the statistical tool SAS.
• Summarized and presented project updates/analytical findings/problem-solving proposals.
• Trained new team members and new users.
• Excellently used Salesforce for Nonprofits proficiency using Salesforce data uploads, Report creation, etc.
• Used Hive data warehouse facilities reading, writing, and managing large datasets in distributed storage using SQL.

Environment: Teradata, Tableau, MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer, UNICA 6.4, Erwin Tool, ETL(Informatica), SAS.