For the given job description <<This is a W2 contract in Minneapolis, MN 55402.Bank is looking for a successful Data Analyst to support our Enterprise Data Governance (EDG) and Data Privacy and Protection (DPP) initiatives. This role will collaborate with the business line and technology groups. Primary responsibilities include: Effectively work in matrixed team of Data Analysts, Project Managers and Business Analysts in support of a specific business andor regulatory need. Research and build a detailed understanding of the problem and related data assets in order to code the data processing and analysis. Light development coding Ensure that the data used follows the compliance, access management and control policies of the company while meeting the data governance requirements of the business. Work with technical groups to support the collection, integration, and retention of the data sources. Apply data visualization and summarization techniques to the analytical results. Interpret and communicate the results in a manner that is understood by the business.
Basic Qualifications: Bachelor's or masters degree in mathematics, Engineering, Computer Science, or equivalent work experience. 5+ years related technical experience and 3+ years analytical experience in the BankingFinancial industry or similar highly regulated industry.
Preferred SkillsExperience: Proficiency with SQL & SAS (mid to expert level) Intermediate knowledge of application coding and development lifecycle. Analytical: (e.g., comfortable with data) and can combine an understanding of business objectives, customer needs, and data required to deliver customer experience and business results. Intermediate knowledge of data governance, data management, data architecture, data modelling concepts and data governance tooling and the complexities of data in a large financial andor highly regulated institution. Willingness to continuously develop and acquire new technical skills, learn new tools & programming languages and Big Data techniques. Proven ability to adjust quickly to shifting priorities, multiple demands, ambiguity, and rapid change. Effective oral and written communication with the ability for analyzing, slicing, and dicing data while deriving significant insights. Natural curiosity and self-directed ability to seek out information and meet goalsdeadlines. Agile experience: Very comfortable following Agile Scrum methodology.>> the resume: <<Career OverviewSeeking a job where I can effectively utilize my academic knowledge and learn new skills to continually enhance the development of my professional skills.
QualificationsProficient or familiar with a vast array of programming languages, concepts and operating systems, including:C, Windows 98/2000/03/XP/VISTA/7/8/10,Adobe Photoshop, Visual StudioNetwork fundamentals,MATLAB, SQL Server 2008R2,2012.SSIS,SSAS,SSRSMultisim, simulink, ImageProcessing.SQL, T-SQL. SQL Server 2012/2008/2005 Enterprise Edition, SSIS, SSRS, PPS, MS PowerPoint, MS Project, MS Access 2003 ,Oracle, Business Objects ,SharePoint , PL/SQL, C#,VB.Net,ASP.NET, XML, Visual Studio 2008 & 2005,MS Visio 2007,Borland StarTeam, Build Forge, Visual SourceSafe
Work Experience02/2017toPresentJr Data analystApex Systems–Gulfport,MS,Underwent internship program conducted by BSNL Telecommunications Vijayawada.Trained in designing PULSE DIGITAL CIRCUITS.Underwent internship program as Data Analyst at A4 Softech.Activities.Won prizes in many essay writings, elocution, quiz, debate competitions and talent search examinations in school and college levels.Active member of Institute of Electronics and Telecommunication Engineers (IETE).Project Work :
Title    
          Description          
Customer Master ETL Integration
The Repository: The Repository contains all of the metadata required for the training examples.It
is hosted, for these evaluation purposes, in a supplied database.Orders Application: An application for tracking customer orders, hosted in a supplied database.Parameters (File): Flat files (ASCII) issued from the production system containing a list of sales representatives and the segmentation of ages into age ranges.Sales Administration: The administration or tracking of sales, hosted in another supplied database .We will populate this data warehouse with our transformations.Exos is the cloud provider that offers various cloud services like virtual servers, storage, networking and hosted applications for corporate messaging, document management and company portals.Developed custom user interface for the document management solution that helps to easily sort, order, filter and manage documents in the cloud from the dashboard.Responsibilities:.Analyzed business requirements and built logical and physical data models that described all the data and relationships between the data.Created Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers to use them for updating and cleaning the existing and the new data.Created indexes to improve the performance of the queries.Performed job scheduling to ensure execution of certain jobs and daily updates.Extensively used T-SQL in constructing Stored Procedures, triggers, cursors, tables, user defined functions, views, indexes.Upgraded DTS packages to SQL Server Integration Services (SSIS) and used it to perform bulk insert operations from SQL Server 2012/2008R2/2008 databases to flat files/CSV files and vice versa.Configured the  SSIS Package for run time Parameters and Configured files as well as developed  the Documents for Logging/Error Handling for SSIS Packages.Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source) and created XSLT files for loading the XML data to database.Implemented custom error handling in SSIS packages and also worked on different methods of logging.Created batch files to load the data from text file to database tables.Developed packages to copy tables, schemas and views and to extract data from Excel and other legacy systems using SSIS.Developed complex SSIS packages to migrate the data from flat files to SSIS.Created ETL/SSIS packages both design and code to process data to target databases.Created technical documents for the process of executing the packages.Performed MS SQL Server Configuration, Performance Tuning of stored procedures, SSIS Packages, SSRS Reports.Performed unit and system testing, troubleshooting and bug fixing in development, QA environments and some of the production issues.Modified existing reports by creating new Parameters, Formulas etc,.Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of T-SQL and MDX queries.Logged & tracked defects in JIRA and followed up to make sure they are resolved and tested in QA environment before the code released to staging and production servers.Worked on source controls VSS (Visual Source Safe), Borland Star team.Involved in crystal report generation and also generated EXCEL based reports for business users.Reported and tracked the status of the bugs per project, resolved defects based on project severity of the defects using Jira for the development & QA team to prioritize.Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).Created adhoc reports based on the user requirements and worked on different on-demand reports.Created Drill down reports, parameterized reports, cascading parameterized reports and drill through reports.
Education and TrainingExpected intotoBachelors:Electronics & CommunicationsDHANEKULA-Vijayawada,APGPA:Electronics & Communications 63.28 91.2Expected in06/20/1993toto:Sri Chaitanya college-Vijayawada,APGPA:Availability     
Graduate student, Department of Electrical engineering, Fairleigh Dickinson University.
SkillsVB.Net, ASP.NET, Adobe Photoshop, Borland, Business Objects, C, good Communication skills, crystal report, Data Analyst, DTS, data warehouse, databases, Database, designing, document management, Electrical engineering, Electronics, English, ETL, XML, Image
Processing, Logging, MATLAB, messaging, MS Access, C#, EXCEL, MS PowerPoint, MS Project, SharePoint, 2000, Windows 98, Enterprise, Network, networking, OLEDB, operating systems, Oracle, PL/SQL, programming, QA, quiz, Reporting, Sales, scheduling, servers, Visual SourceSafe, Visual Source Safe, MS SQL Server, SQL, SQL Server, Tables, Telecommunication, Telecommunications, T-SQL, troubleshooting, user interface, Visio, VISTA, Visual Studio, XSLT>>. The result is, Good Fit

Fit assessment: Good Fit